General Ledger
Discussion List
-
can we add 53rd week in 2023?Summary: can we add 53rd week in 2023? Content (required): Currently we are following 4-4-5 calendar and business would like to add 53rd week in 2023 calendar in GL,AR a…User_2025-07-18-06-50-46-162 51 views 2 comments 0 points Most recent by User_2025-07-18-06-50-46-162 General Ledger & Intercompany -
Account Analysis report SQL Code requiredSummary: Account Analysis report SQL Code required Content (required): Account Analysis report SQL Code required. We need to customize this report based on Natural Accou… -
How to create cost centers massively?Summary: Want to create cost centers massively in IFRA16 Content (required): Version (include the version you are using, if applicable):23A Code Snippet (add any code sn…Ravali Akula 71 views 7 comments 0 points Most recent by CA Nirmal Choudhary General Ledger & Intercompany -
How to convert old journal entries from the primary ledger to the secondary ledger?Summary: Hi All, Thank you in advance for your help. Kindly note the following: I have created a new secondary ledger (Creation date: Feb 2023) with the data conversion …Paul Younes 84 views 4 comments 1 point Most recent by CA Nirmal Choudhary General Ledger & Intercompany -
GL_BAL_TRANSFER_NO_TO_CCID - mapping from ledger 1 to ledger 2Summary: I'm receiving this error when running process Transfer Ledger Balances My mapping rules are: and then I have specific rules for these segment values: My journal…Bo Tøpgaard 84 views 4 comments 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany -
Is there a way to delete the corporate rates in Oracle Fusion?Summary: Is there a way to delete the corporate rates in Oracle Fusion? Content (required): Version (include the version you are using, if applicable): Code Snippet (add…Surya08 61 views 3 comments 0 points Most recent by Sandeep Nayak-Oracle General Ledger & Intercompany -
GL Daily rates reportSummary: GL Daily rates report Content (required): User can query and download exchange rates from specific From/To Currency and Date range in single go in Manage Daily …Kumar 57 835 views 3 comments 2 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany -
How to translate the "Account Analysis Report" in a different currency that the ledger one?Summary: I need to translate the "Account Analysis Report"/"Generate Financial Reports and Account Groups" into a different currency than the ledger one. Content (requir…Teodora Bulancea 52 views 4 comments 0 points Most recent by Teodora Bulancea General Ledger & Intercompany -
SQL Query to extract Journals in particular date rangeSummary: SQL Query to extract Journals in particular date range Content (required): Business wants to migrate Journals (Transactional data of all categories) from EBS to… -
Less Segment in Secondary Ledger Compared to Primary LedgerSummary: In the Primary ledger we have 8 segments (Entity, Natural Account, Cost Center, Geography, Operation, Intercompany, Future1 and Future2) Due to localization req… -
Bank reconciliation - account receipts in details in GLSummary: We have an issue with manual reconciliation of bank lines. When receipts are booked in GL lines are merged. Our account rule has been changed to: Merge Matching… -
Localization Report for TurkeySummary: Need E-Ledger Report for Turkey Content (required): Hi All, We have Turkey localization and below reports are required: Quarterly Advance Tax Declaration (Incom…Jakeeagarwal 147 views 2 comments 0 points Most recent by Jakeeagarwal General Ledger & Intercompany -
Need detailed steps for Norway SAF-T report requirementSummary: Norway SAF-T requirement for our business. We have CoA structure with GL accounts (7 digits) and other segment values (4 digit). I have tried to read some docum…Jakeeagarwal 248 views 9 comments 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany -
FBDI Loading Segment Values and Hierarchies Interface does not delete valuesSummary FBDI Loading Segment Values and Hierarchies Interface does not delete valuesContent Hi, I'm loading the FBDI to load segment values and hierarchies and it does n…Michelle Haynes 71 views 4 comments 0 points Most recent by CA Nirmal Choudhary General Ledger & Intercompany -
After Upgrade 23A Account Analysis Report is emptySummary: Scheduled update was made for 23A and when generating the report Account Analysis with any account and parameters does not return data. Content (required): Sche…Yerwin Blanco 241 views 1 comment 0 points Most recent by Haripriya-Oracle General Ledger & Intercompany -
Context DFF on a ADFDI spreadsheet for journal entrySummary: Hi , we have created a context DFF at the journal header and deployed it without errors. We want to use this DFF information while entering journals using the A… -
Translate GL account balancesHi,We did a change in the exchange and had to rerun the Translate GL account balance program However, the TB balances are not reflecting the rate changes that we did.It … -
Error in External Revenue GL Posting when Create Accounting Parameter (End-date) is Future DateSummary: We are encountering error in posting external revenue and labor costs when we run the Create Accounting for Projects with End date parameter (Feb-28). Content (…Rich Borja 147 views 3 comments 0 points Most recent by Elena Enache-Oracle General Ledger & Intercompany -
Loading Accruals at Month EndSummary: We have an issue at month end where we need to create receivables accruals for invoices that we will not load into Oracle until after month end, the invoices (b…Robert G Wilkinson 42 views 1 comment 0 points Most recent by Harry Zhu General Ledger & Intercompany -
I was wondering what the max number of rules allowed in a RuleSet to work successfully in OracleSummary: I was wondering what the maximum number of rules allowed in Allocations RuleSet to work successfully in Oracle Cloud? Content (required): Allocation Rules Versi… -
Specific European Local ReportingSummary: As a background we operate in 8 different European countries each country has their own local financial reporting standards and returns that need to be complete… -
Is the override function available for manual journals?Summary We are able to use the "override" function for tax journals but not manual, can anyone use it for manual journals?Content The override function allows us to chan…User_2025-02-04-05-09-46-595 82 views 6 comments 2 points Most recent by Mariam Umar General Ledger & Intercompany -
Privileges required for Manage Account Combinations and Manage Account HierarchiesHi All, Can you please help identify privileges required for Setup and maintenance >financials>manage account combinations Setup and Maintenance > Financials> Manage Acc… -
Allocation is ended with Error in Journal saying unbalance Journal when using Descendants functionSummary: We have allocation rule that was working on our previous roll out. But now we have to create allocation to another region, and using the @descendants function t…Tsikoy Caringal 24 views 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany -
Import Journals fails for adjusting periodSummary: We want to load data into GL adjusting periods and I have found this excel: When running the Load Interface File I'm stuck with this error: What is causing the …Bo Tøpgaard 61 views 4 comments 0 points Most recent by Madalina R-Oracle General Ledger & Intercompany -
Join Subledger Tables to AP_INVOICE_DISTRIBUTIONS_ALLSummary: I'm not sure if this belongs more in the Reporting forums, however I am looking to join any of the following Subledger accounting tables to the AP_INVOICE_DISTR… -
How can i add new legal entity as Intercompany key flexfield?Summary: Newly created legal entity is not in the drop down list (key flexfield) in journal. Content (required): I am creating a legal entity with new ledger as well. Wh…Teodora Bulancea 41 views 2 comments 0 points Most recent by Madalina R-Oracle General Ledger & Intercompany -
GL exchange rates decimalsSummary: GL exchange rates decimals Content (required): Business would like to upload daily rates with four decimals and inverse rate also should be 4 or 5 decimals. Use…Kumar 57 146 views 1 comment 0 points Most recent by Elena Enache-Oracle General Ledger & Intercompany -
Restrict Natural Account value by Journal Category when entering manual journalsSummary: How can we restrict Natural Account segment values by Journal Category when entering manual journals? Content (required): Our client needs to restrict natural a… -
How can i change the report format?Summary: I need to change the format of report from word to pdf Content (required): Hello, I need to change the format of report from word to pdf and i found the below n…Teodora Bulancea 51 views 2 comments 0 points Most recent by Teodora Bulancea General Ledger & Intercompany