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
-
best way to retain cost centre account code hierarchy at the end of each financial year?What is the best way to retain a snapshot of the cost centre account code hierarchy at the end of each financial year? Would I be best to explore the option of versions … -
How to Reconciling General Ledger and Budget with Different Conversion Rate Types in OracleSummary: Budget Control: Set Default Rate Type: BOT Selling Transaction:Create a Transaction AP Invoice by specifying Coversion rate type as user rate. Compare Amount be…
-
BICC PVO's for Trial Balance & Vouchers (Journal/Inter Company) & Posted GL Transactions ReportSummary: Can you please help to provide the below report PVO's to extract the data using BICC. Posted GL Transactions Report Trial Balance Vouchers (Journal/Inter Compan… -
Allocation Rule(Formula) Deployment errorHi, We got a requirement for year end allocation rule where ending balance should go to equity and non equity account. Please help with the Run time variable selection a…
-
Moved: How to convert Assets using Historical Rate in Reporting CurrencyThis discussion has been moved. -
Privilege for specific actions - APISummary: One of the client requirements is to restrict users only for API calls and that too users should have access to a specific set of APIs. Like - File Upload to a … -
Getting error when trying process Reverse multiple Journal Batches using REST ( Doc ID 2739516.1 )Summary: Getting error when trying to process Reverse multiple Journal Batches using REST ( Doc ID 2739516.1 ) Content (please ensure you mask any confidential informati… -
Unable to create allocation rule between 2 balance cubesSummary: I am not able create allocation rule between 2 different balance cubes. Is it possible to select source from 1 balance cube and target from another balance cube…
-
How to active Primary to Secondary Ledger Mapping status?Summary: We created a new secondary Ledger but we are not able to activate its conversion status. How to enable it? Content (please ensure you mask any confidential info…
-
Multiple COA mapping from source to targetSummary: Hello, We have a situation where our primary ledger COA source is our Global COA and the secondary ledger is our statutory book that has its own COA. The primar…
-
Reference Date in GL Journal HeaderSummary: Hi do you know, if it's possible to use Reference Date in the Journal Header level to recalculate value from Primary Ledger to Secondary Ledger with exchange ra…
-
Unable to create the new employee number under the Employee segment due to Child Values are ExhaustSummary: Unable to create the new employee number under the Employee segment due to Child Values are Exhausted Content (please ensure you mask any confidential informati…
-
How to modify Journal batch name for all journals and add period and created by objectsSummary: Our client is using EBS R12 as their legacy system and currently they have to automate the journal batch name user need not provide the details automatically sy…
-
Is it possible to batch create allocation rulesSummary: Currently, we create allocation under General Ledger → Create Allocation Rules, and all the rules can only be edit and created one by one at a time. We are goin…
-
Intercompany transactions between different ledgersWe currently have 4 ledgers configured, and we need to be able to make intercompany transactions between them, can you tell us if this is possible. Best regards.
-
Can we have same batch name for different ledgers?Summary: We post journals with different ledgers within one spreadsheet template using multiple journals sheet ADFDI. This creates so many journals and journal batches. …
-
Our business requirement is to have two different Avg rates and Period-end Rates for one ledgerOur business requirement is to have two different Avg rates and Period-end Rates for consolidation and FRS reporting. But in Oracle we have only one type of Avg and peri…
-
Absortion companyHi gurus: We need to merge two companies into 1, and we would need to know if there is any process (automatic or manual workflow) in Oracle Fusion Cloud that allows us t…
-
How to Delete Multiple Account Hierarchy Tree VersionsSummary: We would like to know if there is a way to delete multiple hierarchy tree versions at a time in Oracle Financials Cloud. I mistakenly created 1,254 tree version…
-
Revaluation Journal- Forex account balance and Asset Account balance needs to be nullifiedSummary: An incorrect revaluation journal was posted in Nov-19 to the unrealised Forex and Asset account, during Data migration, while conversion from AUD to USD. which …
-
How to remove Journal Import errors after Purge Inteface Tables has been run?Summary: We have four journals that are no longer in table GL_INTERFACE, but the errors still exist in table GL_JI_ERROR_CODES. We have run the Purge Interface Tables pr…
-
journalentries callback serviceSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Restrict User RateSummary: Is there a way to warn/restrict user if the User rate enter deviates from the threshold or by reference rate type by certain percentage? Content (please ensure …
-
Journal approval assignee top participantSummary: We currently have a journal approval rule (FinGlJournalApproval) where the journal will go to the submitter's line manager for approval, then if it's not action…
-
Why allocation formula don't get transferred during a clone?Summary: Why allocation formula don't get transferred during a clone? Content (please ensure you mask any confidential information): We cloned our PROD environment to ou…
-
How many records can be loaded for one value set in a file without impacting process' performance?Summary: We have got a file which contains close to 392k records for one value set only. The file is loaded into UCM and the process "Upload Value Set Values" is schedul…
-
List of all tables from which data gets purged as part of FAH - Purge final accounted transactionsSummary: We are looking for the list of all tables from which data gets purged as part of fusion accounting hub - Purge final accounted transactions process Content (ple…
-
Mix of STAT and normal currency journal batch is getting autoapprovedSummary: Mix of STAT and normal currency journal batch is getting autoapproved. Our expectation is that, journal batch or journal should get autoapproved only if it has …
-
How to join GL_JE_BATCHES and FA_FUSION_SOAINFRA.WFCOMMENTS tables in Oracle FusionSummary: What is the key column to join GL_JE_BATCHES and FA_FUSION_SOAINFRA.WFCOMMENTS tables in Oracle Fusion Content (please ensure you mask any confidential informat…
-
Natural Account (SEGMENT2) Description on a custom reportSummary: Hello, We have built a custom report to compare the FA SLA balances to GL which contains an account column but which GL table do we use to include the account d…