Journals
Discussion List
-
How to Extract Chart of Accounts Values and HierarchiesSummary How to Extract Chart of Accounts Values and HierarchiesContent Hi I would just like to inquire if there is a standard report (OTBI), program or an API that can e…User_2025-02-11-12-30-38-982 1.4K views 9 comments 4 points Most recent by Truptesh Solanki General Ledger & Intercompany -
How to test CVR without creating journal or even going to Create Journal pageLet's say I have 200 Cross Validation Rule setup in the system and I want to test it. What are my ways to test the CVR if it is working or not without going to the Creat…Butch Melvin 13 views 1 comment 0 points Most recent by Julien_Dubouis General Ledger & Intercompany -
subledger entries how to override cost centerHi, Fixed Assets and has 4 journal lines that ended in invalid status because the firm/cost center combination is no longer valid. There is any way to override the accou… -
Do we have an archive functionality for Journals in GL (Oracle Fusion)Summary: Do we have an archive functionality for Journals in GL (Oracle Fusion). In Oracle R12, we have Archive and purge functionality. Wanted to know whether similar f… -
role custom only viewit is possible to create a custom role for viewing only the journal or balances? -
Entered currency same as Reporting Currency, but different from Ledger currencySummary: trying to nail accounting details when GL journal has Entered currency as USD for ledger with functional currency as EUR and reporting currency as USD Below scr… -
Access restriction for passing journal entries in Adjusting period in GLSummary: Can we restrict the user access for the entries in adjusting period. Only specific users should be permitted to enter the journal entries in adjusting period. C… -
Which Spreadsheet file to use when UPDATING journal approval rules?Summary: Which Spreadsheet file to use when UPDATING journal approval rules? Content (please ensure you mask any confidential information): I navigate to the task 'Manag…ramesh.sivapalan 18 views 4 comments 0 points Most recent by Haripriya-Oracle General Ledger & Intercompany -
What is 'Incomplete Journal Entries' in Create Accounting Execution Report?Summary: What is 'Incomplete Journal Entries' in Create Accounting Execution Report? Content (please ensure you mask any confidential information): We have generated 'Cr…ramesh.sivapalan 46 views 1 comment 0 points Most recent by Mary Ramirez-Oracle General Ledger & Intercompany -
'AutoPost Journals' job ending with error : ORA-01458 invalid length inside variable characterHi Team, some of the users are running job: 'AutoPost Journals' but it is ending in error : ''ORA-01458: invalid length inside variable character string'', we are unable…Kalpesh Salunke-Oracle 35 views 1 comment 0 points Most recent by Sharada Beleramane-Oracle General Ledger & Intercompany -
Can Clearing account automatically reconciliation add more condition such as supplierSummary: As I know, Clearing account automatically reconciliation feature using same amount as condition. Is it possible to add more condition such as supplier to automa… -
External Data Loader Client - Journal UploadWe are currently looking over the possibility of using the EDLC to upload journals from external sources into Fusion, as there is a dependency on splitting the files bef… -
How is the conversion logic from primary ledger to reporting ledger (accounted amount)?Summary: How is the conversion logic from primary ledger to reporting ledger (accounted amount)? I found different logic conversion for corporate vs user rate from prima… -
Is there any possibility to make PO Number as a Hyperlink from GL Journal for Source: PO ReceiptSummary: Is there any possibility to make PO Number as a Hyperlink from GL Journal for Source: PO Receipt (That GL Journal belongs to PO Receipt) Content (please ensure …Vasu N0897645321-Oracle 14 views 1 comment 0 points Most recent by Julien_Dubouis General Ledger & Intercompany -
Is there any standard solution in Oracle Cloud for Inflation Adjustment in Argentina?Summary: Is there any standard solution in Oracle Cloud for Inflation Adjustment in Argentina? Content (please ensure you mask any confidential information): I couldn't …Gabriel Rega 18 views 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle General Ledger & Intercompany -
Journal Ledger Report ended in errorSummary: Hi! I tried to run Journal Ledger report for period Jan-21 to Dec-21 and this ended in error, but when I run the same report for period Jan-21 to Feb-21 it work… -
Funds Check SQL or APISummary: Is there a REST / SOAP API available to check funds in Oracle ERP Cloud General Ledger? If not, what would be the SQL / related tables to fetch the fund availab…Prithis 85 views 2 comments 0 points Most recent by Pooja Asthana-Oracle General Ledger & Intercompany -
Is there an available report that can retrieve the historical data of Allocation Rule execution?Summary: Is there an existing report in Oracle Cloud where we can extract data on when a particular Allocation rule was last executed/triggered? Content (please ensure y…Ilona Jean P. 13 views 1 comment 0 points Most recent by Laura Petre-Oracle General Ledger & Intercompany -
Antara De 73 views 7 comments 0 points Most recent by RajendraV-Oracle General Ledger & Intercompany -
Are new versions of ADFDI identical across environmentsSummary: When a new version of ADFDI releases alongside a quarterly release, the installer file is available from our lower environments several weeks before our product… -
How to upload Accounting sequence number through Journal Import FBDI TemplateSummary: How to upload Accounting sequence number through Journal Import FBDI Template Content (required): I am migrating Journals from EBS system to Fusion system. Busi… -
Is bulk uploading of Allocation rules in Calculation Manager possible?Summary: Is bulk uploading of Allocation rules in Calculation Manager possible? Content (please ensure you mask any confidential information): Is it possible to upload/u…Ilona Jean P. 58 views 2 comments 1 point Most recent by Ilona Jean P. General Ledger & Intercompany -
intercompany journals not posting automaticallySummary: intercompany journals not posting automatically Content (please ensure you mask any confidential information): intercompany journals not posting automatically w…Kumar 57 33 views 4 comments 0 points Most recent by Narayanan M S-Oracle General Ledger & Intercompany -
Is it possible to Unreserve funds on a Journal when the period status is 'Future Enterable'Summary: We are trying to delete some Journals as the users have typed an incorrect date in the spreadsheet journal template. The import process has attempted to Post th…Bhavya Batra 49 views 3 comments 0 points Most recent by Antima Rai-Oracle General Ledger & Intercompany -
Journal not getting posted in the Reporting LedgerSummary: System is trying to use inverser rate upto 6/7 places of decimal in the Reporting ledger Content (required): Hello, we have INR Primary ledger & an associated R…RajibPramanik 296 views 7 comments 1 point Most recent by Korrapati Chakradhar Reddy -Oracle General Ledger & Intercompany -
Is there a way to differentiate manual journal in reporting ledger vs flow from primary ledgerSummary: Hi, 1.When post a manual journal source in primary ledger, it will auto post to reporting ledger as well. 2.On another side, user will post manual journal direc… -
Srujana Vemanamanda 12 views 2 comments 0 points Most recent by Cezar M-Oracle General Ledger & Intercompany -
How to change the Date format in Subledger Journals nameHello Team, When we import the Inventory transaction with correct date format (YYYY/MM/DD) through FAH, after running the required jobs we see incorrect date format in J…Md Fasi Ahmed 5 views 1 comment 0 points Most recent by RajendraV-Oracle General Ledger & Intercompany -
Is there anyway we can park Journals until we ready to send it for ApprovalSummary: Currently We have ESS scheduled AutoPost Journals every 1 hr which is actually sending it for Journal Approval without user click on for Approval. Right now - a…Bhaskar Koduri 33 views 4 comments 0 points Most recent by Bhaskar Koduri General Ledger & Intercompany -
Is there a way to identify deleted journals so that we can exclude them from reporting?Summary: Is there a way to identify deleted journals so that we can exclude them from reporting? Content (please ensure you mask any confidential information): We have a…