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
-
Is there a way to delete unused combinations from GL_CODE_COMBINATIONS tables in Oracle Fusion CloudIs there a way to delete unused combinations from the GL_CODE_COMBINATIONS table in Oracle Fusion Cloud? These combinations have zero balance and are no longer used in o… -
Need Journal Posting Error Report or Table nameSummary Need Posting Error report or backend table name to see errored batches with detail posting errorsContent In General Ledger if Journal posting goes it to error, t…
-
How to create advanced rule in Workflow spreadsheet with condition 'Each' or 'None'?Summary: In BPM it was possible to use expressions like EACH and NONE in Advanced Mode. In the workflow spradsheets it is not present. At least it seems that way. How ca…
-
What's the best practice to limit revaluation journals cannot be modifiedHi team, We are a global company and APAC users request to have their revaluation journals cannot be updated after generation under audit requirements. We know that we c…
-
Audit report to capture critical events of user activitySummary: Hi Everyone, One of our clients is looking for the reports that show logons, access attempts, and data modifications. Does any seeded report exists in the Oracl…
-
How to create journal lines using REST API?Summary: How to create journal lines using REST API? Content (required): I can find resources for creating journals using FBDI or webservices but no resources on creatin… -
DATE_CREATED_IN_GL field on the GL_INTERFACE tableHow does the DATE_CREATED_IN_GL field on the GL_INTERFACE table gets populated? As per the tables and views description: Oracle internal use only. Date journal import cr…
-
Is there a workaround to view combinations for a combination set?Summary: I have followed steps to View Combinations for a Combination Set available in Oracle Help Center. When I get to step 8 listed below to download it freezes my pa…
-
Debit and Credit Columns Greyed Out in Oracle Fusion GL Journal EntryWe are working with a custom role in Oracle Fusion General Ledger. When users with this role create a journal, the Debit and Credit columns are visible but appear greyed…
-
24B New Feature: Accounting Data Archive and PurgeI am trying to Archive the data for the General Ledger as per the instructions provided in the new update 24B, but when i am trying to enable the data for archiving, it …
-
Need to create Approval depends on Journal Category and Journal Amount on same BPM RuleHi All, Please I tried to create a BPM Rule that says If Journal Category is "XXXXX", And Journal Debit Accounted Amount is "XXXXX" However, the Journal Category conditi…
-
Can I add non-qualified custom Segment Label to existing COA Segment which is already in use?Summary: We have requirement to create OTBI Report to fetch data for a particular COA Segment. The segment is not visible in Subject Areas. We have already tested it in …
-
Redwood RoadmapSummary: Is there a roadmap of Redwood changes for GL and ERP generally please. Can find lots on HCM, but not ERP Content (please ensure you mask any confidential inform… -
How to prevent changing a segment value when an Alias is being used?Summary: We are trying to figure out a way, that an alias could be used to enter some (not all segments) of the GL Code combination (when entering transactions), and whe…
-
How to upload DFF values in bulkHi, I have created a DFF name "Supplier name" at journal lines level, Validation type=independent, Display type: List of values I want to add values in that DFF means su…
-
Budget Data is not visible in GL_BALANCES tableSummary: We have created a custom scenario 'Budget' in Accounting Scenario value set. Then we have loaded data through Create Budgets in Spreadsheet task. The budget bal…
-
How can I change segments in an existing chart of accounts structure?Summary: The Customer wants to changue the order of the. segments in the char of account structure, in this moment we already did the configuration but they have no made…
-
API for accrual transaction in subledger accounting transaction dataSummary: There is a requirement to pull out the previous accrual transaction for correction which was made by integrating subledger accounting transaction data into AHCS…
-
Segment Value Set Security Control for Ledger SetWe have enabled Segment Security control by ledger-wise and have also a ledger set. When we assign the ledger set to a user and they select a ledger from the LOV while m…
-
Journal approval - Level 2 approval should be triggered if journal (already in approval workflow) isSummary: Journal approval - Level 2 approval should be triggered if journal (already in approval workflow) is not approved by certain business day and not based on journ…
-
Incorrect Account type reclass from Revenue to ExpenseWe went live in April-25 and we noticed after loading all the TB's some of the expense account was wrongly setup as Revenue account due which it is impacting the FRS rep…
-
Impact Of Changing the Account Type of Natural Account segment value from Revenue to ExpenseSummary: In the current landscape of our client's environment, COA values and related information will flow from EDMCS to Fusion ERP. Now there is a requirement from Cli…
-
Overlaps with updating GL tables and BIP executionSummary: Overlaps with updating GL tables and BIP execution Content (please ensure you mask any confidential information): I am developing a BIP that outputs balances fr… -
how to configure intercompany balancing with transaction type IC invoicingSummary: Fro a projects perspective I need to create invoices for transactions between 2 legal entities within the same business unit. In Project Contracts I have an Int…
-
Is there an out of the box trial balance report that can be run over multiple years?Summary: We are looking to see if there is currently a TB report within scheduled processes that could be run over multiple years. Content (please ensure you mask any co…
-
Balances are not being translated at Average RateSummary: We have setup Reporting Currency for the purpose of translation and consolidation of balances. When translating Balances, system is not translating balances at …
-
How to handle foreign currency transactions in AP so that there is minimal impact on revaluationHi, Need to understand how to handle day to day foreign currency transactions in AP so that there is minimal impact on revaluation. For e.g, AP invoice in Foreign curren…
-
How To Create 4 Revaluation Job Sets For 4 Companies that have more than 50 revalution processesHello, I am trying to create 4 Revaluation jobs set based upon the the ESS Job ( Revalue balances) that must have several revaluation sets inside. I found the following …
-
Excel Add-ins to export TB directly from Fusion applications to Excel directly.Summary: Excel Add-ins to export TB directly from Fusion applications to Excel directly. Content (please ensure you mask any confidential information): Business would to… -
What is the maximum currency precision and extended precision in Fusion GL?Hello Gurus, What is the maximum currency precision and extended precision in Fusion GL? Highly appreciated for any feedback/help in advance. Thanks and Regards, David