General Ledger
Discussion List
-
when trying to access Manage Secondary Ledgers task getting errorSummary: When trying to access manage secondary ledger task in Oracle financials cloud getting error like "View row with key oracle.jbo.Key[null ] is not found in Primar… -
How to update Chart of Account Segment Values and GL Account Hierarchy in bulk easily1. Update Chart of Account Value Set Values Sometimes there is a requirement to update COA value set values in bulk e.g. Value Description, Enable flag, Segment Value At…CA Nirmal Choudhary 4.4K views 19 comments 6 points Most recent by Zoe Su General Ledger & Intercompany -
How to Delete Multiple Account Hierarchy Tree VersionsSummary: We would like to know if there is a way to delete multiple hierarchy tree versions at a time in Oracle Financials Cloud. I mistakenly created 1,254 tree version…Jayendra Sreekar Kurali 6 views 3 comments 0 points Most recent by User_78TOA General Ledger & Intercompany -
Control budgets not populating in LOV in Enter Budget in SpreadsheetSummary: Hi Team We have created a Control Budget: OH Control Budget_1 and completed all the required setups. The required roles and data access also given to the user b… -
Defining Approval rule in SRC for late journal entries(post business day 10th)Summary: We have a requirement to create an approval rule for journals based on journal batch creation date. All journals created after populated accounting period end d… -
Has anyone set Allocation rule in GL to create Standard Recurring Journals?Summary Unable to create variable for Accounting PeriodContent Hi, We are trying to use allocation rule to create Standard recurring journals and I'm unable to create va…Sathya Kannan 100 views 5 comments 1 point Most recent by Sudhakar Reddy N-Oracle General Ledger & Intercompany -
Accounting Date Range in AutoPost Criteria SetSummary: Query: The user wants to post journals based on the Accounting Date. Does the “Autopost Journals” process work based on the Submission Date or the Accounting Da…Rama Mohan ReddyB 10 views 1 comment 0 points Most recent by Jamal Saboonchi General Ledger & Intercompany -
Is there a way to automate the configuration steps when there is a new entity COA value?When there is a new entity value that feeds into ERP from EDMCS, we then complete the required configuration steps for the new entity, such as Manage Legal Entity, Assig… -
How can I find correct load_request_id for transactions those are stuck in the GL_INTERFACE tableSummary: How can I find the correct load_request_id for transactions that are stuck in the GL_INTERFACE table? Please help to a SQL query. Content (please ensure you mas… -
Common GL Posting Errors and How to Troubleshoot ThemHi everyone, As a beginner when transferring journals from subledgers to General Ledger in Oracle ERP Cloud, I sometimes get posting errors. What are the most frequent c… -
can’t delete the journals that are currently in an error statusHello, In GL, I have journal entries that were imported and ended in error, and cannot be deleted. I have already executed the "Delete Import Data" and "Purge Interface …Teresa Martinez-Oracle 7 views 1 comment 0 points Most recent by George-Oracle General Ledger & Intercompany -
Unable to select the BU in "Assign Business Unit Business Function".Summary: Unable to select the BU in "Assign Business Unit Business Function". Content (please ensure you mask any confidential information): We have created a setup user…koji shinoda 17 views 3 comments 0 points Most recent by George-Oracle General Ledger & Intercompany -
Changing prompt for FUTURE KFF segment in COASummary: The company wants to change the Name/Prompt of a FUTURE segment in COA KFF. Please share your experience and thoughts regarding the considerations and consequen… -
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 … -
Showing unbalanced intracompany journalSummary: I am interfacing journals directly to GL through OIC (From other Application). The journals involve multiple LEs under the same Ledger. Sequencing by LE is enab…Subrat Kumar Dash 6 views 0 comments 0 points Started by Subrat Kumar Dash General Ledger & Intercompany -
GL Calendar importSummary: Is it possible to import the GL calendar from UAT to Production via Export and Import functionality Content (please ensure you mask any confidential information… -
All ERP Transaction Console Errors need to email to abcxyz.com and also to the submitter.Hi Community Please help me with below requirement. All ERP Transaction Console Errors need to email to abcxyz.com and also to the submitter. Thanks in advance. JakeeJakee_Agarwal-Oracle 24 views 7 comments 0 points Most recent by Lakshmi Alagappan-Oracle General Ledger & Intercompany -
Get 201 Created response on fscmRestApi/resources/11.13.18.05/erpintegrations but process is not runSummary: Get 201 Created response on fscmRestApi/resources/11.13.18.05/erpintegrations but process is not actually run 56 = batch id from the file Content (please ensure… -
How to assign access to GL for a specific Company and only the revenue accounts?Summary: We would like a Team Member to have access to a specific companies GL but only for Revenue. Content (please ensure you mask any confidential information): Versi… -
While creating journal entry, JE creation date is overridden by system dateWhile importing journals through FBDI spreadsheet, the journal entry creation date is getting override by the sys date. Is it possible to populate the date that is given…Dharanidhar 44 views 5 comments 0 points Most recent by Karun Jain-Oracle General Ledger & Intercompany -
how do I edit the expression builder for journal batch name ?how do I edit the expression builder for journal batch name in oracle sandbox so that it will autopopulate the journal name feild as sequence number first then the sourc…Akshay28 8 views 1 comment 0 points Most recent by CA Nirmal Choudhary General Ledger & Intercompany -
Allocation formula is not generating allocation journalsSummary: Allocation formula is not generating allocation journals, we are getting below message in the log - Message data is :::::FUN_ALLOC_NO_LINES The allocation gener…D Mandal 20 views 1 comment 0 points Most recent by CA Nirmal Choudhary General Ledger & Intercompany -
GL: Anyone migrated the allocation rules from one instance to another by using export and importHas anyone successfully migrated General Ledger (GL) Allocation Rules from one Oracle instance to another using the Export and Import functionality? If yes, could you pl… -
Unable To Delete The Unposted SLA Journal in GLHi, We are busy introducing a GL housekeeping / maintenance process to clean up the GL after ledger close each month. As part of the process, we would like to delete any…Steve Collop 23 views 2 comments 0 points Most recent by CA Nirmal Choudhary General Ledger & Intercompany -
Customize / Restrict GL Journal Approval Email NotificationsSummary: We have a business scenario where Business don't want to enable Notifications (EMAIL) for all Journal Approvals Requests in BPM. But requesting to have Emails g…BALA RAYUDU 11 views 1 comment 0 points Most recent by CA Nirmal Choudhary General Ledger & Intercompany -
Cannot Delete Rejected GL Journal - Funds Stuck as ReservedHi We are running into a critical issue where a Rejected Journal entry is holding up reserved budget funds, and we are blocked from deleting the journal. We suspect the …mohana ungarala 12 views 2 comments 0 points Most recent by CA Nirmal Choudhary General Ledger & Intercompany -
How to print prompted value as a header text in FRS report?I am creating a balance sheet report in oracle using FRS. Business has a requirement keep accounting period, entity, budget scenario as prompts. I have created the promp… -
General Ledger Account Groups query criteria to include Chart of AccountsSummary: We are looking for Query by example on General Ledger Account Groups to include Chart of Accounts criteria, is anyone aware if this function available with a pr…Raj Gutta 2 views 1 comment 0 points Most recent by CA Nirmal Choudhary General Ledger & Intercompany -
How to default open accounting period in FRS report?We are creating a Balance Sheet report using FRS. We want to pass / default open accounting period as a parameter. How to do it? -
Cross validation rules importSummary: Content (required): Hi, i am getting the following error when importing CV rules with mode 'Replace' : Cross-validation rules can't be imported for a chart of a…El1a 1.3K views 9 comments 0 points Most recent by CA Nirmal Choudhary General Ledger & Intercompany