General Ledger
Discussion List
-
Account change from parent to childDear All we have a recommendation to change an account from parent to child. what are the impacts regards -
Want to Update an Existing Oracle GL Accounting CalendarSummary: Our client is now using the June to May fiscal calendar and wants to shift it to July to June. Is there another method for meeting this requirement than creatin… -
Can we use the Parent value to create the transaction in GL if we give Allow Posting as Yes?We have Account segment parent value summary field Yes, Allow Posting field Yes. Submitted the Inherit segment value attributes process for Primary ledger and Submitted … -
Change the Accounting Period from Quarterly to Semi-Annual in SmartviewHi, This is to ask from your assistance regarding this matter. Client asked us if there’s a possible way to format/have an options in Smartview from Quarterly basis (Ima…Felipe M. Ignacio II 12 views 4 comments 0 points Most recent by Felipe M. Ignacio II General Ledger & Intercompany -
Restrict Subledger Application access for GL userSummary: In our project we have a unique requirement to restrict the Subledger Application Journals for a few GL Users in General Ledger. Let me explain with an example.…Priyanka Jain 11 views 1 comment 0 points Most recent by James McBride General Ledger & Intercompany -
what are the tables where i can find project and its accouting detailsSummary: Hello , I want query or table names from which i can pick projects inofrmation of accounting like GL_date ,Account number,Account description. I am attaching th…
-
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…
-
How to make journal lines context default based on ledger for existing contextSummary: How to make journal lines context default based on ledger for existing context Content (please ensure you mask any confidential information): We have two ledger…
-
Error to Post to Ledger invoice with prepaymentSummary: Cannot accountinf AP Invoice when there is prepayment applyied due error "You must either modify the account rule to balance the journal by balancing segments o…Anderson Aparecido Bertoni 83 views 6 comments 0 points Most recent by Anderson Aparecido Bertoni General Ledger & Intercompany -
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 32 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… -
💡Do you know how to delete old Essbase cubes after the P2T?💡Do you know how to delete old Essbase cubes after the P2T? Content: Please be informed that after P2T, if for example, you have a COA name different on TEST instance co…Andreea Brem-Oracle 136 views 2 comments 6 points Most recent by Sean Rogers General Ledger & Intercompany -
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 19 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 Jose 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 2 views 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 3 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 13 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…
-
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 22 views 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany