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 it possible to transfer ledger balance by group of balancing segment values?Summary: In the customer’s organization, multiple primary ledgers are in use, along with a consolidated ledger. Users are assigned access only to a subset of primary bal… -
Why can't I edit accounting period for unposted journal?Content (required): Hi all Why can't I edit the accounting period for unposted journals coming from journal import where journal source is Assets? Journal source for Ass… -
Migrating foreign currency balancesSummary: Hello, We are migration balances from r12 to cloud. We have both functional and foreign currency balances in our extract. The issue is when we will load the for…
-
Autopost Journal Error GL_ADFDI_UPL_ER_NO_LEDGER_INVSummary: We have an automatically scheduled process for Autopost Journals and are receiving an error GL_ADFDI_UPL_ER_NO_LEDGER_INV: the ledger isn't valid for your curre… -
Not able to select Ledgers in the Create Opening Balance Journals in Reporting Currency or SecondarySummary: We are not able to select Ledgers in the Create Opening Balance Journals in Reporting Currency or Secondary Ledger Schedule process, which setup must be missing…
-
When Cross-Validation Combination Set is better than Cross-Validation Rules?Cross-validation combination set and cross-validation rules have the same purpose, which is to prevent invalid account combinations during journal entry. These two are d…
-
Journal reversal - Accounting date if frozenSummary Journal reversal - Accounting date on reversed journal is frozenContent Hi GL Guru's As a routine process Accrual journals are reversed -- User tried to update a… -
Sub ledger foreign currency Transactions are Importing to Journal with Conversion Rate as "User"Summary: In AR Sub ledger transactions, we have selected conversion rate type as Corporate, but the same transaction journal header UI level conversation rate type showi… -
How to reverse signs of Revenue and Liability accounts in Oracle GL balance essbase cube?Summary: We are looking to identify the best approach for reporting Revenue and Liability account numbers in Smart View. Currently, these accounts appear as negative val…
-
query to get all roles,security context and security context value (without users)Summary: Hi I need help in getting the roles ,security context and security context values for all the roles defined (without USERS). created the below query could you p…
-
Subledger Journals posted to GL but not showing in Trial Balance and Account Analysis ReportSummary: Hi there, We have run the create accounting for Payables and transactions posted to GL but some transactions are not reflecting in Trial Balance and Account Ana…
-
Need to Add Privilege in a RoleWe are Facing issue in Create Opening Balance Journals in Reporting Currency or Secondary Ledger, schedule process, not able to select the Target ledger. this privilege …
-
Create a sequence for a specific Journal Source and CategorySummary: Hello, For our migration we have the requirement to create a specific journal source and category for the migrated entries of GL. The requirement also specifies…
-
Cross Validation rules works differently when using the FBDI for import JournalsSummary: The Cross Validation rule configured in the environment is not correctly picked up / works differently when using the Journal Import FBDI The CVR rule is set-up…
-
Use SQL predicate in segment value security conditionHi, we are trying to create segment value security condition using SQL Predicate. The requirement is to show all the segment values except for few. This segment has hier…
-
newly added costcenter is not adding showing in smartviewUser recently added one cost center , but this cost center is not showing in smartview. Transfer General Ledger Balances to Balances Cubes process is running in every on…
-
Close monitor and Business UnitsSummary: The user's guide is refering to Business Units. Is not working from me. Did anyone made it work? Reference The period status information that's displayed is bro…
-
RESTAPI for audit reportSummary: We've Audit reports to identify/track the changes happened in the application. As part of MCA India audit, its required to keep a daily backup of audit reports.…
-
How to exclude natural account segment from Revaluation Process?Summary: We need to exclude some Natural Account value from Revaluation Process Content (please ensure you mask any confidential information): When we run Revaluation Pr… -
DFF Attribute to be populated based on Standard UI fieldSummary: Hi Team We need to populate a Descriptive Flex field attribute values based on an existing standard field in the UI page But we do not find any option to refer …
-
How the continuous transfer of budget balances to the budget cube affects tablesPlease tell me about the impact on tables of the ESS job "Continuous transfer of budget balances to budget cube: transfer schedule" being run. Currently, the BIP report …
-
How can I pull in all ledgers within one report regarding 'Subledger Period Close Exceptions Report'We have 20 + ledgers and have to run a report for each due to 'Ledger' as a required field. Does anyone have any workarounds if Oracle has not created another BIP report…
-
Closing Journal were generated with only one line with amounts in debit and credit.Summary: When executing the process “Create Income Statement Closing Journals”, two line items with a debit and a credit amount were generated. When executing the proces… -
Need to enable GL Date From and To as parameters in Account Analysis ReportSummary: Need to enable GL Date From and To as parameters in Account Analysis Report Content (please ensure you mask any confidential information): Account Analysis Repo…
-
Identify Journals Missing in Secondary ledgerSummary: Journals missing in secondary ledger. We need to indentify list of those journals and correct. Content (please ensure you mask any confidential information): Hi…
-
Can we edit error message in ADFDI spreadsheet in Journal/ AGIS transaction import spreadsheet.We having a business requirement where to edit error message in ADFDI spreadsheet in Journal/ AGIS transaction import spreadsheet, EX when error out the details will com…
-
Moved: How do we efficiently get a detail by contract of the RMCS accounts?This discussion has been moved. -
Do we have BICC PVOs for GL_SETS_OF_BOOKS and GL_TRANSLATION_RATES?Need to extract data from cloud tables- GL_SETS_OF_BOOKS and GL_TRANSLATION_RATES. I am unable to find any PVOs in any lineage sheets. Do we have PVOs available for them?
-
Is there any alternate way to run the Clearing Account Reconciliation for both PL and SL at once.Summary: User currently running Clearing Account Reconciliation separately for Primary Ledger and then for Secondary Ledger. As per business user they have to do TWO tim…
-
Restrict Value Set Access per COA Admin in Setup Using Page ComposerWe have multiple Chart of Accounts (COA) structures, each managed by a different administrator. We want to restrict access in the “Manage Chart of Accounts Value Sets” p…