To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
General Ledger & Intercompany
Discussion List
-
Difference between Original Distributed Accounted Amount and Distributed Accounted AmountSummary: Hi , In a JVM Distribution, I have the Original Distributed Accounted Amount different from the Distributed Accounted Amount. I can see that The Original Distri… -
FRS - Option to get the 'Prompt' of the COA segment in the POV instead of the segment nameSummary: Hi All, We had a requirement to change the segment name of the Future segment. Since it had multiple implications as suggested in the forum we have only changed…
-
IC Transaction Transfer to GLWhat is the required set-up to transfer AGIS transactions straight to GL? I would like to note that I also need to be able to transfer transactions to AP/AR. So I need t… -
Publish Chart of Account Dimension Members and Hierarchies to Balances Cubes in Parallel not endingHello, Since around the end of 2024/8 we have been experiencing an issue where ESS job: Publish Chart of Account Dimension Members and Hierarchies to Balances Cubes in P…
-
Financial Reporting Studio Report for Ledgers in Different CubesSummary: Hi, We tried to include 2 GL balances cubes (1 Primary Ledger - 2 Secondary Ledgers: Primary and Sec ledgers share common CoA and currency but Calendar is diffe… -
General Ledger Journal Entry Database InquiryHi Oracle Experts, I have a question regarding the General Ledger Journal Entry report. Could you please clarify if the field JRNL_Effective_Date refers to the journal c…
-
MaxFetchLimit setting in REST API generates errorSummary: We are trying to get the GL balances using REST API (LedgerBalances) but having issues with large volumes. Documentation says to add MaxFetchLimit = N to allow …
-
Client is asking if there's a way to mass open period for both GL and Budget Period at the same timeHi team, Is there a way to run an open period in bulk/ mass open period for both GL and Budget Period at the same time?
-
Segment value security which will be only applicable in PayableSummary: We have defined a segment security rule and everything is working as expected. while I am doing additional research on this and testing, wanted to know if someo…
-
FOREIGN CURRENCY VALUATION ACCOUNTING FOR FINANCIAL SERVICESHello, according to the Release Note of the 24C update, a question arises, 'This feature is applicable to financial institutions and the banking sector in particular tha…762Jonathan 33 views 3 comments 0 points Most recent by Abhijit Dhakephalkar Gr Manager Financials Product Management-Oracle
-
How to specify the percentage for the source amount in general ledger allocationSummary: We are creating a new allocation rule where we need to specify the percentage to be allocated from the source amount. There is no field for such and it seems th…
-
Journal reversal in Primary ledger not reflected in reporting currency ledgerGood day, I'm aware of the Synchronize Reversals Between Primary and Secondary Ledgers option in Specific Ledger Options, however, does this also apply for Reporting Cur…
-
Restrict DFF Attribute to fixed lengthSummary: Requirement to Restrict DFF Attribute to fixed length Content (please ensure you mask any confidential information): We have requirement to set DFF Attribute wh…
-
When do you need to run the "Review and Submit Accounting Configuration"Summary: We have an existing Ledger which has a Legal Entity assigned to it and one balancing segment assigned to the Legal Entity. This setup has been in place for a nu… -
Is there any rest api or soap webservice to request approval for a journalSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Options for Uploading BPM approval rules for Intercompany transactionsSummary: We need to setup approval rules for Intercompany transactions across 50+ entities, with each entity requiring its own set of rules. While we can configure these…
-
how to exclude our custom application data from being picked by Account Analysis Report?Summary: Recently We has implemented a custom application. Data for this custom application flows through accounting hub. The data volume is huge (millions of data each …
-
Rounding off amount balance in Credit Note or Advance without any impact on liabilityHow can we adjust Remaining balance in Suspense Account or in GL without impacting Subledger Account and Bank Clearing Account. Need to adjust Yellow highlighted amount.
-
purge accounting dataIn R12 there used to be programs for Archive and Purge data. Is there something similar in Oracle cloud. Is there something similar for AR, AP and PO transactions... -
While posting subledger journals using ADFDI we had faced issue XLA-FUN_INTRA_RULE_NOT_DEFINED.Summary: While posting subledger journals using ADFDI the journal went into error showing the following error - XLA-FUN_INTRA_RULE_NOT_DEFINED. I am using Journal Source…
-
Trial Balance Report IssueIn Report credit side are just totals wherein it should have been broken according to each related account, like shown in the debit side, below is the 2 SS with wrong on…
-
Difference between Date_created column and creation_date column in GL_INTERFACE TableSummary: Difference between Date_created column and creation_date column in GL_INTERFACE Table. Name Datatype Comments CREATION_DATE TIMESTAMP Who column: date and time …
-
How to automate entry and creation of recurring journals WITHOUT using ADFDI and Allocations ?Summary: Outside of the Auto Copy function, to automate the entry and posting of recurring or memorized journals which could be journals that are based off a monthly sch…
-
Create Allocation Rules issueHi, We have two issues in Allocation Rules page - Issue1: Unable to see the values of any dimension and the existing rules also shows error that values doesn't exist. Be… -
Journal Approval Serial Approval SequenceSummary: Hi, We have a journal approval requirement where there are Two Approval groups that need to approve a journal in sequence. Lets assume there are 2 groups having…
-
Can one change the alias of a GL period name for use in SmartViewSummary: We are running GL with a Fiscal Year starting October and Ending September. The fiscal year starting for example 1 st of October 2024 is FY25. Thus for example … -
Missing time in JrnlHdrPostedDateTime column of FscmTopModelAM.FinGlJrnlEntriesAM.JournalLinePVOWe use FscmTopModelAM.FinGlJrnlEntriesAM.JournalLinePVO to extract journal lines. The time part (hour, minute, and second) in both JrnlHdrPostedDate and JrnlHdrPostedDat…
-
Manage Business Units update to who columnsSummary: I am trying to find out the changes done to the Manage Business Unit setups from the last updated date and last updated by. But I see that when anyone changes t…
-
When historical rates and daily rates are used?Daily rates - revaluation Historical rates - translation Are these correct? Any insights?
-
Best practice of Chart of Accounts Structure design for Manufacturing IndustrySummary: Looking for the best practices for Chart of Accounts Structure for Manufacturing Industry. Content (please ensure you mask any confidential information): We are…