General Ledger
Discussion List
-
What jobs need to be run after a child segment value is added to a parentSummary: If you manually add child account segment values to a parent value via the Manage Accounts Hierarchies screen, what jobs do you need to run for the child values… -
Purpose of 'Budget Execution' Journal CategorySummary: Hi all, We want to actually transfer some budget amount from one account combination to other. Will the Journal Category 'Budget Execution' serve the purpose? I… -
COA Hierarchy Update - Help RequiredSummary: I have to update a new hierarchy to add new parent for certain accounts, but after loading the file, I found in the system that we have 2 Accoumt hierarchy Vers…
-
Unable to find Ending balance column in GL balance TableI am looking for a Ending balance for a particular account in gl_balances table. Is any other table contains this value ?
-
how to delete bulk Journal Import errors data using templateSummary: User wants to delete the journals through ADFDI/spread sheet for bulk import errors. Is there a way other than delete journal import job(Passing mandatory param…ndevabathina 81 views 9 comments 0 points Most recent by Antima Rai-Oracle General Ledger & Intercompany
-
Journal Approval Serial Approval SequenceSummary: Hi, We have a journal approval requirement where there are Two Approval groups that need to approve a journal in sequence. Lets assume there are 2 groups having…
-
COA segment value end dated and journal can be approved or postedSummary: COA segment value has been end dated. Enabled COA doesn't always show an error and when COA combo is disabled, a journal can still be approved Content (please e… -
GL Lookups - FINANCIAL_CATEGORY x2 - System vs UserSummary: There are 2 GL Lookups for FINANCIAL_CATEGORY. What is the difference and which one should be used/defined for the Chart Natural Account? Thank you. Content (pl…
-
Source accounts for allocation from different parentsSummary: We have an allocation rule that contains source accounts with different parents. for example: accounts 66122, 66123, 66124, 66125 (parent: 66100) and accounts 5…Boaz Nurieli 11 views 3 comments 0 points Most recent by Vlad CONSTANTIN General Ledger & Intercompany
-
Journal reversal in Primary ledger not reflected in reporting currency ledgerGood day, I'm aware of the Synchronize Reversals Between Primary and Secondary Ledgers option in Specific Ledger Options, however, does this also apply for Reporting Cur…
-
What are the possible statuses returned by an ESS Job in REST APISummary: Content (please ensure you mask any confidential information): I am submitting an ESS job and checking the status. I want to understand what are all the possibl…Jaeyshree K K 22 views 2 comments 0 points Most recent by Jaeyshree K K General Ledger & Intercompany
-
Configuration change - adding a parent for all P&L accountsSummary: I want to add a parent for the existing COA hierarchy, but I am not sure how to export the current hierarchy and import the new hierarchy, Can anyone please hel…Gifty V 11 views 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany
-
Can we restrict view access transactions of different bus within same ledgerSummary: Our business have 3 different business units under 3LE and all records transactions are under same ledger, now a part of business one business unit is sold out …Lokesh Koppera 1 view 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany
-
Restrict users from adding new attachments to an approved/posted journalSummary: Is it possible to restrict any new attachments from being added to a journal that is approved and posted. Currently users can add additional attachments but the…Brian Burns 1 view 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany -
Document to identify seeded journal category used for journals coming from subledger transactionSummary: Document to identify seeded journal category used for journals coming from subledger transaction. Content (please ensure you mask any confidential information):…Shivani Somani 11 views 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany
-
Can CVR Rule Supersede Combination sets?We created a CVR Rule where all Balance Sheet accounts are only allowed to post with Department 0000. However there is an exception to this rule, for example a particula…JPLED415 11 views 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany
-
Is there a way to lock the Reversal Period fields on a journal once the journal is posted?When a journal is posted, if the Reversal Period fields are blank, a user can still edit those fields. Is there a way to prevent the reversal period from being edited af…Steven Woods 11 views 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany
-
Can Allocation journals go through Approval?Summary: Can allocation journals created through Calculation Manager go through approval? I have heard mixed feedback where an Oracle SR has that it is not doable but al…Prasanth Selvakumaran 11 views 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany
-
Enterprise Structures Setup ReportSummary: Enterprise Structures Setup Report Content (please ensure you mask any confidential information): We created custom role for General Ledger Account manager role…Kumar 57 11 views 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany -
Approve and Reject Button on GL Journal UI are not visible to an ApproverWe have configured approval rules for GL Journals where in journals are routed to an Approval Group based on Journal Source. The approvers which are part of the Approval…Ankur_P 102 views 1 comment 1 point Most recent by Andreea Brem-Oracle General Ledger & Intercompany
-
how to create consolidation and elimination ledgerSummary: I have a questions related to consolidation we have company X 001 company y 002 company z 003 all of them have there own ledgers and legal entity we need to cre…Hadeer Ahmed 41 views 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany
-
HOW CAN WE CREATE ENCUMBRANCES JOURNAL USING API?We have see ENCUMBRANCES JOURNAL CREATION WITH JOURNAL IMPORT SERVICE (Doc ID 2560454.1) Since then (the note is dated to a few years back) we see no reference, not to t…
-
Is it possible to fetch ledger id in OTBI?Summary: Hi, I want to add a column that shows the Ledger ID in OTBI for reporting. I have checked in all the Subject areas as shown in the image below but I have not go…Gautam Buragohain 21 views 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany
-
how to update manage clearing account reconciliationWe have defined our account reconciliation before but business have requested to add new accounts to it, but when we try to update the list just blink and we are not abl…Kurt Ki 11 views 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany
-
Fusion table for Journal import error codes and descriptionSummary: is there a table in fusion that stores the Journal import error code and description that we can see in Output file. Couldn't find anything in FND_LOOKUPS and G…Divya Mangtani 222 views 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany
-
file-based data import process to import segment valuesHello I would like to use the following XLSM template ChartofAccountsSegmentValuesandHierarchiesImportTemplate.xlsm to massively modify the descriptions of 50 segment va…User_RH8BI 41 views 1 comment 0 points Most recent by veerendranath pulivarthi-Oracle General Ledger & Intercompany
-
The attachment does not gets copied to the autocopied Journal transaction when we copy a journal.Summary: The attachment does not gets copied to the autocopied Journal transaction when we copy a journal. Content (please ensure you mask any confidential information):…Srivatsan 1 view 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany
-
Create a Consolidation Ledger for a legal requirementSummary: We need help to how to configure a consolidation ledger to supply a legal demand. We have 3 different ledger and we must consolidate all in a single ledger. We …
-
Issue with Run time Prompt variable in General Ledger Allocation RulesSummary: We have an issue where the Run time Prompt (Accounting Period in this case) is showing up twice when we are running Generate Allocations process. Content (pleas…Bhanu Prakash Sharma 94 views 5 comments 0 points Most recent by Bhanu Prakash Sharma General Ledger & Intercompany -
Revaluation process required to hit the Gain and loss at the same time.Hello, We have the request to split the offset account for the revaluation process. This means that instead to netting the revaluation and affect a Gain or loss, custome…Juan Carlos Bobadilla-AA 21 views 1 comment 1 point Most recent by Juan Carlos Bobadilla-AA General Ledger & Intercompany