Journals
Discussion List
-
Enterprise journals via SmartView - In practiceSummary: Does anyone have experience of using Enterprise journals via Excel SmartView and seen any benefits from having journal workings in Excel to drive the journal. O…David Hiscutt 45 views 1 comment 0 points Most recent by uchitha-Oracle General Ledger & Intercompany -
Is it possible to add Approver uploaded attachments in Approval task to Journal HeaderSummary: How to add Approver uploaded attachments in BPM Approval task to Journal Itself to retain the attachments for Audit Purposes Content (required): Hi, We have a r…Madhu Chalamalasetty 58 views 2 comments 1 point Most recent by Haripriya-Oracle General Ledger & Intercompany -
Journal Import Error : Rejected-Error ontable GL_INTERFACE, column LEDGER_ID ORA-01722: invalid numbSummary: We are importing Journals relating to Payroll from a third party application via UCM. The in bound Journals File has Journal lines with Ledger Name. LEDGER_ID i…Swaroop Mitta 414 views 2 comments 0 points Most recent by Balaji Rangaswamy General Ledger & Intercompany
-
How can i create a custom filter for field?Summary: create a field Content (required): Is it possible to create a custom filter to use in gl? (example a filter based on the COA) Version (include the version you a…
-
is it possible divide journal in general ledger by Business unit?Summary: General ledger and business unit (security context) Content (required): we would like to divide the journal in general ledger by business unit, so is it possibl…
-
How to disable notification for journal uploaded through spreadsheet?Summary: Would like to find way to disable the email notification for journal imported thru spreadsheet. Content (required): It was found that the submitter received an …Chow Ka Ming Jason-Oracle 46 views 2 comments 0 points Most recent by Chow Ka Ming Jason-Oracle General Ledger & Intercompany
-
How to edit unfrozen automated journal entries?The Oracle Help Center says you can prevent edits to journal entries by freezing the journal source (https://docs.oracle.com/en/cloud/saas/financials/22b/faugl/how-can-i…User_2025-02-12-21-42-51-760 149 views 4 comments 2 points Most recent by Sanket Darokar General Ledger & Intercompany -
Timeout Error when uploading journals using ADFDISummary: For the last 1 week, we are noticing timeout error associated with uploading journals using ADFDI. This is happening only in production and we are unable to rep…Bangar Aaloori 67 views 1 comment 0 points Most recent by Cezar - Fusion Oracle Support-Oracle General Ledger & Intercompany -
ERP - issue posting journal entry to Primary ledger due to mapping to secondary ledgerSummary: Content (required): Since receiving February maintenance into 21D, we are experiencing an issue with Primary to secondary ledger mapping. Is anyone else experie…Colette Gillespie, KU 34 views 3 comments 0 points Most recent by K Hart13 General Ledger & Intercompany
-
Accruals and Default Reversal Information21D (11.13.21.10.0) A customer I support has a standard accounting calendar setup with 13 periods per year (13th period is an adjustment period). The "Manage Journal Rev…
-
Auto reversal journal to by-pass Adjustment PeriodSummary: Example: Dec last fiscal period. Adjustment period:Dec. Reversing JE passed in Dec (non-adjustment period) gets reversed in Adjustment period. Can this behavior…Giri Venkatesan 56 views 2 comments 0 points Most recent by Giri Venkatesan General Ledger & Intercompany -
Unposting of a posted journalSummary: How to unpost a posted journal Content (required): We have a journal that is posted. But the accounting strings are incorrect. Rather than enter a reversal we w…
-
Manual Set up or use of Rapid Implementation file for loading chart of accounts, hierarchies, legalSummary Manual Set up or use of Rapid Implementation file for loading chart of accounts, hierarchies, legal entities, accounting calendar, primary ledgers, business unit…
-
Unable to post journals due to error message "the journal isnt balanced by balancing segment values"Summary: Unable to post GL journals due to error message "the journal isn't balanced by balancing segment values and intercompany isnt enabled for ledger X. You must ena…Martha Labbate 193 views 2 comments 0 points Most recent by Martha Labbate General Ledger & Intercompany
-
Can you disable the Approve/Reject buttons in GL Journal ScreenSummary: In Manage Journals > Edit Journal page, Approve/Reject buttons are enabled for a Journal created via a spreadsheet loader (ADFDi). Journal had already been sent…Martha Labbate 75 views 6 comments 1 point Most recent by Martha Labbate General Ledger & Intercompany
-
Is Reference Date Segment in Journal Header not available in the Journal Import TemplateSummary: Is Reference Date column not in the Journal Import Template (FBDI)? What column should I use instead? Content (required): Hi I want to use Reference Date in GL …
-
General Ledger account wise restriction to see the dataSummary: General Ledger account wise restriction to see the data Content (required): We are implementing for Govt agency and suggesting single ledger instead of multiple… -
How to assign a UOM to a stat accountSummary: If I go to the config task "Manage Statistical Unit of Measure" and try to assign a UOM with an account value, UOM LOVs do not show up. My understanding is, all…abhishekdeobhakta 78 views 4 comments 0 points Most recent by abhishekdeobhakta General Ledger & Intercompany
-
Is there an option to default the exchange rate date and type in the Journal ADFDI spreadsheet?Summary: The customer is asking why they need to populate the conversion rate date and conversion rate type when loading a foreign currency journal. Why can't it default…
-
Journal ImportSummary: Journal Import Content (required): Journal imported from an external subledger is reflected as successful from Oracle integration, however journal is not reflec…
-
Is there an Audit Log of User that Deletes Import Journal File in ErrorSummary: Journal Files are imported from external systems. If the File is unbalanced, or has some other error, it goes to Journals with Import Errors. If this file is th…user10700011 25 views 1 comment 1 point Most recent by Jeff Hare CPA CISA CIA General Ledger & Intercompany
-
Accounting Sequence is not create for GL JournalsSummary: I have enabled document sequencing ( Accounting Sequence) in GL for 'Manual' journal entries by following the below steps Enabled document sequencing in Specify…Rajiv.Karande 181 views 1 comment 0 points Most recent by Vaishnavi Aryasomayajula-Oracle General Ledger & Intercompany
-
Is it possible to get the journal's ADFdi spreadsheet to upload partially?Content (required): Is it possible to get the journal's ADFdi spreadsheet to upload partially? Hence, get the successful lines uploaded when there are other lines with e…Daniel Lundsteen Minke 14 views 2 comments 0 points Most recent by Daniel Lundsteen Minke General Ledger & Intercompany -
Is there a way to resolve the ADFDI 00505 error when uploading a journalSummary: While uploading a journal via ADFDI - ADFDI 00505 error is seen. However, The journal gets created and posted successfully. Looking for a cause and resolution C…User_2025-02-05-23-59-27-298 817 views 2 comments 0 points Most recent by Alex D-Oracle General Ledger & Intercompany
-
How can I purge a GL_INTERFACE transaction stuck.Summary: When loading a Journals with ADFDI, it always end up in warning because there is a transaction stuck in error in the gl interface. By interogating the GL_INTERF…Francois Desjardins 441 views 4 comments 1 point Most recent by Francois Desjardins General Ledger & Intercompany -
How to derive conversion date based on the Journal Accounting Date for Journal Approval RuleSummary My requirement is to derive conversion rate for the previous year's last month, month end rate for journal approval rule.Content My requirement is to derive conv…Gaurav Sansanwal 63 views 2 comments 0 points Most recent by Gaurav Sansanwal General Ledger & Intercompany
-
GL Balances change after data migrationSummary: Content (required): We did Data Migration of GL Balances and got the extract from GL_BALANCES table. After closing all the periods, when we got the extract agai…Vinay Gharge 40 views 1 comment 0 points Most recent by Balaji Rangaswamy General Ledger & Intercompany
-
Change CalendarSummary: Content (required): We have an Oracle Cloud customer who is looking to change their General Ledger Accounting Calendar from 30th June year-end to 31st March yea…
-
Journal Ledger Report - transactions "Not Transferred" but posted to GLSummary: Content (required): I have a bunch of transactions in the report when I run Journal Ledger Report with posting status Not Transferred, however most of these tra… -
Defaulting GL Journal Lines to say n number.Summary: We have requirement from our client to Defaulting GL Journal Lines to say n number. As of now Oracle Fusion standard displays only 2 lines in Journal while crea…