Journals
Discussion List
-
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 186 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 71 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 64 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 21 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 164 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 11 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 754 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 418 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 59 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 37 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…
-
Privileges for accounting period close and open in GL for custom roleSummary: A custom role for the purpose of GL period management Content (required): Hi all, As per a requirement, a GL custom role was created to period management. The r… -
Journal ValidationSummary: Journal Validation Content (required) Where do I find these setups >GLDI: Force Full Validation >GLDI: Force Journal to Balance Version (include the version you…CraigX 11 views 1 comment 1 point Most recent by Cezar - Fusion Oracle Support-Oracle General Ledger & Intercompany
-
Journal in a Spreadsheet ErrorSummary Receiving "The combination is not valid" error when combination is validContent We have users copying and pasting values from other workbooks to a journal spread…James McBride 15 views 4 comments 0 points Most recent by Baskar.Chakravarthi General Ledger & Intercompany -
'Submit Journal Import' submission option not showing in ADFDI journal UploadSummary 'Submit Journal Import' submission option not showing in ADFDI journal UploadContent Hi Team, 'Submit Journal Import' submission option not showing in ADFDI jour…Rohit Kumar Singh 142 views 1 comment 0 points Most recent by venkatanarayana p General Ledger & Intercompany
-
Journal Issue - "No sequence version is enabled or defined for sequence **** XX GL Accounting SequencContent Hi Guys I would just like to inquire if anyone of you have encountered this kind of error for created journals? Please kindly refer below "No sequence version is…User_2025-02-11-12-30-38-982 274 views 1 comment 1 point Most recent by Kallol Sinha General Ledger & Intercompany
-
GL_INTERFACE Status ColumnSummary GL_INTERFACE Status Column meaning of code PContent Hi team, hope you are fine! Does any one know what the letter P means on the GL_INTERFACE table, and why it d…Luiz Mendes Jr 40 views 3 comments 1 point Most recent by alexey.shtrakhov General Ledger & Intercompany -
Prevent user entering negative value into ADFDI journal's Credit Column?Content Hi, We have noticed users have created some lines on ADFDI Spreadsheet journals, with a negative value in the Credit column. On the same journal there are cases …
-
Journal Import issue - Reference field need to load with CommaSummary Journal Import issue - Reference field need to load with CommaContent Hi All, When loading a Journal Import interface, the process fails the data load for record…Prathishver B 32 views 3 comments 2 points Most recent by Prathishver B General Ledger & Intercompany -
GL | Assigning BSV directly to primary ledger instead through a legal entityContent Question - Under what circumstances would you attach a BSV(balancing segment value) directly to a ledger instead of attaching it through a legal entity? What are…AMJ_001 49 views 2 comments 3 points Most recent by Sriram Swaminathan-Oracle General Ledger & Intercompany
-
Revaluation Accounting DistributionsSummary We would like to change the revaluation accounting distributions for one of our Business UnitsContent We would like to change the revaluation accounting distribu…Robert G Wilkinson 39 views 1 comment 2 points Most recent by Sriram Swaminathan-Oracle General Ledger & Intercompany
-
eText Template File for Journals Import InterfaceSummary Looking for an existing eText Template to use for importing journal entriesContent Has anyone created an eText Template for the Journal Import Interface that can…Meredith Bickell 33 views 5 comments 2 points Most recent by Meredith Bickell General Ledger & Intercompany -
How to call GL Journal Load Webservice in a SaaS environmentSummary How to call GL Journal Load Webservice in a SaaS environmentContent We have a requirement of calling the GL web service, we are able to load this using SOAP call…Sam Samaddar 92 views 3 comments 2 points Most recent by Daniel Perez Soto General Ledger & Intercompany
-
How to Auto post Supplier Costs without any approvalsContent Our Journal entries for Purchase Invoices are auto posted without anyone intervention but our Supplier Costs are not auto-posted, they require approval from Acco…Sabarish Reddy Ganda 36 views 11 comments 2 points Most recent by Sabarish Reddy Ganda General Ledger & Intercompany