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
-
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… -
Schedule "Revalue Balances" ESS JOB With Incremental PeriodHi, We want to Schedule "Revalue Balances" job to be run monthly and also for all the revaluation categories created. parameters at the time of scheduling Accounting Per…
-
Report for Unused Natural AccountSummary: We would like to find list of unused natural accounts (if a account was not used for booking/journal entry in any entity for a certain period of time). Is there…
-
FX Revaluation - Conversion from Transaction Currency (Non-USD) to Functional Currency (USD)Hi, It is required to achieve conversion from Transaction Currency (Non-USD) to Functional Currency (USD) In a third party tool (Non-Oracle system), for all those transa…
-
How to use Custom AR Transaction Source for Intercompany TransactionsSummary: AR Transaction source “Global Intercompany “is defaulting for intercompany transactions (In oracle Fusion). How to use Custom AR Transaction Source for Intercom…
-
Stat Journal Auto Approval Rule Not WorkingSummary: Stat Journal Auto Approval Rule not working Below is what has been created By Oracle. Can you Assist by Reviewing and seeing what is incorrect?
-
How to transfer net difference of VAT Payable and Receivable a/c balances to VAT Clearing a/cRequirement: There is balance in VAT Payable a/c and VAT Receivable a/c. Net balance [VAT Payable a/c – VAT Receivable a/c] is to be transferred to VAT Clearing a/c. -
How can we solve the issue of only one parent value showing in member id selection in SmartviewHello Experts, We have noticed that when selecting the member ID in Smartview, only one parent value is shown on the "All Department" member ID, while the other parents …
-
balance initializationHi In May I set up the following Secondary Ledgers, in production. I noticed that there were large variances when I created my monthly Primary to Secondary Balancing fil…
-
Currency Conversion Rate for HCM CloudSummary: Our client doesn't have license for ERP (GL) & Payroll module. Can we still load currency rate using steps specified in document Load Currency Rates To Oracle F…
-
Is there a way to massively update the financial category in the natural account?Summary: Is there a way to massively update the financial category in the natural account values registered in the coa? Content (please ensure you mask any confidentia…