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
-
How can we capture additional fields in Journals though spreadsheet/ADFDI templateCurrently for manual JE entries, field options are limited. Accounting team needs enhanced upload template capabilities so that information, e.g., supplier name, PO #, i… -
Budgetary ControlHey All, Can I simply enable budgeting in GL configuration to avail Budgetary controls at PO, or i'll have to configure complete encumbrance setups to achieve the budget…
-
Automate the opening of AP periodSummary: Opening Next AP period Automatically on 1st of Every month Content (please ensure you mask any confidential information): Hi Everyone, we have a client requirem…
-
Restrict the hierarchies in FRS report promptSummary: We have about 10 account hierarchies defined for one of the COA segments. We are developing an FRS report, which requests a prompt for accounting period and thi… -
Can we perform allocation rule across ledgersHi All, Do we have any documents with an example to perform allocation rules across the ledgers or intercompany entities. Please let us know. Code Snippet (add any code … -
Can Historical Rate be used as the workaround to import translated historical balanceSummary: We are implementing the cloud transformation project from Oracle EBS to Oracle Fusion. Summary journals as of the cut-off period will be used to convert the GL …
-
Intercompany Balancing Rules use cases and how to use them?Hello, I went through with the oracle Document (Implementing Enterprise Structures and General Ledger) explaining intercompany balancing rules with the examples but i co…
-
Does a legal entity need to be assigned to a ledger for it to work FRS ReportSummary: We have one FRS report which is working properly for all the ledgers except one ledger which is not assigned to any legal entity and No BSV assigned to LE. The …
-
How to setup Intercompany balancing rules if we have two different LOB values under same ledgerSummary: Content (please ensure you mask any confidential information): Hi Team, we are getting incorrect line of business segment value in Receivable class due to IC Ba…
-
Web service to reverse journalDear All, I need to reverse journals in bulk. Is there a web service or an FBDI that can be used to achieve this objective? Thanks and best regards, George Mattar
-
what is the column name and table name for accounting date in GL_JE_headers of Oracle FusionSummary: what is the column name and table name for accounting date in GL_JE_headers of Oracle Fusion Content (please ensure you mask any confidential information): Vers…
-
Possibility of sending notifications to Oracle users from system :expecting to send notificationsSummary: Possibility of sending notifications to Oracle users from system :expecting to send notifications Content (please ensure you mask any confidential information):…
-
Chart of Accounts Mapping - Filtering and SortingSummary: We have thousands of lines in Chart of Accounts Mapping, and now user wants to modify some mappings. However, there is no filtering feature (Pic.1) on the "From… -
Data access set list of values empty in journals UI for custom roleSummary: Hi all, A custom role was created for general accounting. All the privileges were assigned and the tasks can be seen in the journal and period lose clusters tha… -
Ledger ID stored in FA subject area instead of GL subject area (OTBI).Summary: The Ledger ID is an important key used to identify ledgers configured in the General Ledger application. In the database this is stored in the GL_LEDGERS base t…
-
Chart of Accounts Mappings and conv level "Balance" secondary ledgerWhen creating secondary ledger of conv level "Balance" how can i use the COA mapping? i would like a use case here for this secondary ledger, so after transferring the b…
-
Which role or data access to be able to drill down to AP transaction?In Manage Journals, when drilling down to AP invoice transaction by clicking debit amount - user is unable to view the subledger journal lines, thus view transaction but…
-
GL Period Close program completing in errorWe maintain a primary ledger and a corresponding secondary ledger for France, encompassing 8 legal entities. Reporting sequences are configured to generate exclusively f… -
Trying to use gl_interface_control_s.NEXTVAL but getting ora-02287 is there any specific role.Summary: Trying to use gl_interface_control_s.NEXTVAL but getting ora-02287 is there any specific role required. I am using it in OIC Content (please ensure you mask any…
-
Manage Account Combination is not working in ADFDI as expected and showing as successfulIn the "Manage Account Combinations" function, using the "Create in Spreadsheet" option, the Create Account Combinations in Bulk template is returning a row status of "R…
-
User should be able to view only the journals created by them in GL dashboard.Summary: Hi Team, Our business requirement is that the GL dashboard should show the journals requiring attention for the individual who is logged in and not show pending… -
How to switch to a new hierarch tree version in FRS report automatically without editing the report?we end dated our old chart of account hierarchy tree version, and created a new tree version with start date of today. We published both hierarchies. However, when we ru…
-
more than 15 characters when create journal and create journal in spreadsheet on the ERPSummary: Is it possible to extend the input to more than 15 characters when create journal and create journal in spreadsheet on the ERP Content (please ensure you mask a…
-
How to add between condition in Journal Approval Spreadsheet templateSummary: How to add between condition in Journal Approval Spreadsheet template Content (please ensure you mask any confidential information): Could you please let me kno…
-
How to get Node name and description from Manage Account Hierarchies: Specify NodesSummary: I need to get this value for a report, someone knows in which table this information is? Content (please ensure you mask any confidential information): Version … -
Moved: Can we create intercompany balancing journals based on Intercompany segmentThis discussion has been moved. -
How do we exclude unapproved but validated AP invoices from Accounting Automation?Summary: We have Accounting Automation enabled for Payables and for all error categories. We noticed that error notification emails include a lot of errors with message:…
-
Standard recurring journal in oracle erp cloudThe client would like to create a standard recurring journal in Oracle ERP cloud as the client is an ex EBS user. I found that they way forward for this is to use the AD…
-
Are there any Performance Issues when Setting Up One Primary Ledger with Multiple Secondary Ledgers?Summary: Are there any Performance Issues when Setting Up One Primary Ledger with Multiple Secondary Ledgers? Content (please ensure you mask any confidential informatio…
-
How can we change a party NameHow can we change a party Name Segment Value for Entity was changed from ISO Ltd to a new name but the Old name is still appearing in the Reports as you can see below , …