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
-
ORA-20001：Posting Error Caused by Accounting SequenceWhen we executed the posting process, the following error was displayed: >> glpsqn() 07-JUL-2026 09:52:55PERF0005: Oracle error detected in function glpsqn() - ORA-20001… -
How to populate Reconcile Reference column at GL Journal Lines in bulk post the journals are createdSummary: Client has requirement to populate the Reconcile Reference column in the GL Journal lines based on the custom business rule written in the PaaS extension. It's …
-
How to use Cost Center Manager setup in Departments in General Ledger journal approvalSummary: in payable the Cost Center Manager is part of the LOV for Start Approver, for General Ledger it is not. I would like to know how to route to Cost Center Manager…
-
Cross Validation Rule Display this Error Message "The combination does not exist or cannot be used"Summary: Why the Cross Validation Rule Display this Error Message "The "combination does not exist or cannot be used" The particular combination was disabled. So instead…
-
Can we have Escalation enabled for one ledger & disabled for anotherHi If we have two ledgers with approval rules required but one ledger requires escalation rule enabled & other don't Is it possible to have so? can we disable for one sp…
-
BPM Approval Rules Changes HistoryHi There, We got an Audit Observation that something was updated on Oracle Approval Rules for Journals on specific date, is there any method to exactly know what has bee…
-
I configured the ledger agent But getting operational issues like fields are not getting validated.I configured the ledger agent and all the configurations are completed, But getting operational issues. Please see below But whenever I'm making a query, I'm getting thi… -
can I keep same COA in source and target in COA mapping oracle fusionSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
How to enable Journal Line DFF for particular journal source or categorySummary: Can we enable Journal Line DFF for particular journal source or category Content (please ensure you mask any confidential information): Version (include the ver…
-
Loaded value to account hierarchy via API, but not seeing the value in the UISummary: Added a value via (KB60505) REST API - addValueTreeNode Content (please ensure you mask any confidential information): We can't see the value in the UI, but whe… -
GL_ADFDI_UPL_ER_NO_LEDGER: The ledger is invalid for your current data access setHi Guys Please can you help, I am getting this error intermittently: GL_ADFDI_UPL_ER_NO_LEDGER: The ledger is invalid for your current data access set I need to set up a…
-
How to add intercompany filter when performing manual clearing account reconciliationWe are trying to use clearing accounts reconciliation functionality in GL and currently struck with below 2 points How to filter based on intercompany segment Can we do …
-
Regarding GL Journal Line Amounts and GL Balances Exceeding 15 DigitsI have a question regarding GL journal line amounts and GL balances that exceed 15 digits. Based on the Essbase product specifications, my understanding is that GL journ…
-
Delete journal interface by 'Purge Interface Tables', but import errors repord still thereSummary: Delete journal interface data by process'Purge Interface Tables', but import errors repord still there Content (please ensure you mask any confidential informat…
-
payroll query in oracle ebs r12 2.7i want paroll data of an employee using oracle ebs r12 2.7
-
Data migration for fusion ERP and EPM,best practice for migration of historical translated balSummary: As part of the data migration work for oracle fusion ERP and EPM implementation, what is best practice approach for migration of historical translated balances …
-
What may cause the smartvew error: Duplicate name [XXXX] found in Grid, unable to resolveHi team, We have observed an intermittent issue when refreshing Smart View reports. In some cases, even though the chart of accounts has not changed and the same templat…
-
Allocation offsetSummary: Hi Team, we have a requirement to build allocation rule using Allocation Wizard. For eg The scenario is we would allocate costs from one particular cost center …
-
next year period is open ; Inquire detail balances - not showing up previous year dataSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Make Attachment Mandatory at Intercompany TransactionsSummary: Our client would like to force users to always add attachments on IC transaction, I'm wondering if we can customize the page to make the attachment field mandat…
-
Is It Possible to Default DFF Value from Another DFF FieldSummary: Client plan to enable DFF on IC transactions on batch, transaction and distribution level, and all DFF will fill in the same value. I'm wondering if user can on…
-
Immediate Manager should be skipped for the journal creater/SubmitterSummary: Immediate Manager should be skipped for the journal creator/Submitter and to be routed to particular users. For example, if X user(JOB LEVEL is 1) creates or su…
-
Inquiry on Best Practice for Period Adjustment to Retained Earnings after Fiscal Year Close(2025)Summary: We are facing a critical reconciliation issue where the P&L total from the official FY2025 financial statements does not match the Retained Earnings Opening Bal…
-
After Fusion IAM migration to OCI IAM Migration users are not able to access smartview with <25.xSummary: Recently We migrate from Fusion IAM to OCI IAM .After Migration users are not able to access smartview with version below 25.x . Is there any documentation that…
-
How to Display Daily Movement Debit and Credit Separately in FRS Using the ADB CubeSummary: We have a requirement to display Daily Movement Debit and Daily Movement Credit in separate columns in an FRS (Financial Reporting Studio) report using the ADB …
-
FRS rounding differencesAll Journal Entries are in 2 decimal figures but the amount stored in cube at multiple decimal that creates rounding differences in FRS & Smartview at Parent level repor…
-
Segment Security rule is restricting all other roles other than the role assigned in the Policy RoleSummary: Segment Value set Security rule is restricting all other roles other than the role assigned in the Policy Role Content (required): Created a security rule and a…
-
Year end process for budgetary controlSummary: Hi , We have defined a budget calendar from Jul-25 to June-30 for Australian client. Source Budget type-Other and Project-No project on the transaction what are…
-
How to set up a VAT account in the Intercompany Accounting moduleSummary: Currently, I manually create an invoice from the intercompany accounts module and transfer it to Receivable. When the invoice migrates to accounts receivable, t…
-
Custom General Accountant role to remove AllocationHow can we remove privileges' from General accountant seeded role for allocation and Clearing accounts Reconciliation and create custom role