General Ledger
Discussion List
-
23B Spreadsheet: How to configure auto approval rule Journals if the Intercompany BSV is 0000Summary: 23B How to configure auto approval rule using spreadsheet for Journal batch if the Intercompany BSV is 0000 for all JE lines. Content (required): Our requiremen…Saran Kumar Suru 167 views 13 comments 0 points Most recent by Saran Kumar Suru General Ledger & Intercompany -
Is it feasible to create new reporting currency for a existing primary ledger?Summary: Is it feasible to create new reporting currency for a existing primary ledger? If yes, any consideration or key points to be aware of? Content (required): I wou…
-
Can Oracle realize three-currency bookkeeping?Summary: Can Oracle realize three-currency bookkeeping? Content (required): Can Oracle realize three-currency bookkeeping? The company is registered in Albania, and the …
-
Is there "Purge Temprory Journal Import Interface Table" ESS job in cloud?Summary Is there "Purge Temprory Journal Import Interface Table" ESS job in cloud like we have in EBS?Content Currently, in EBS, client runs the "Purge Temporary Journal…
-
How to Stop a Company's Financial Operations in FASummary: How to Stop a Company's Financial Operations in FA Content (required): Planning to stop a company's financial operations in Fusion Application. This requires th…Karin Hori-Oracle 51 views 2 comments 0 points Most recent by Karin Hori-Oracle General Ledger & Intercompany
-
Negative amount as credit lineSummary: Can system generate a credit line in the journal if amount entered is negative? e.g. if we enter -100 in debit column of journal import spreadsheet then can a j…Richa Arora-Oracle 42 views 2 comments 0 points Most recent by Hussian Sharief M-Oracle General Ledger & Intercompany
-
How do you create opening balances in Reporting Ledger ?Summary: The primary ledger currency is NZD and was created 3 years ago. There is a requirement to do consolidation in AUD currency. We are setting up a Reporting Curren…Prakash_Khanchandani 103 views 2 comments 0 points Most recent by Prakash_Khanchandani General Ledger & Intercompany
-
What action is required to disable the primary ledger?Summary: What action is required to disable the primary ledger? Content (required): Is there any action required to disable a ledger other than: How to Delete or Disable…Karin Hori-Oracle 84 views 2 comments 0 points Most recent by Karin Hori-Oracle General Ledger & Intercompany
-
General Ledger FAQ for Retained Earnings (REA) (Doc ID 136510.1 for cloudSummary: General Ledger FAQ for Retained Earnings (REA) (Doc ID 136510.1 for cloud -this doc is for EBS, I need a similar document for Cloud or confirmation that Cloud w…User_2025-07-18-09-47-41-042 56 views 1 comment 0 points Most recent by Baidehi Nanda–Support-Oracle General Ledger & Intercompany
-
New Implementation: In GL, Open New Financial Year before posting prior year balancesSummary: Go Live Date for a new legal entity: MCB Leasing Ltd is expected for 01 July 2023. Accounting Calendar for MCB Leasing is from July YYYY-1 to June YYYY+1, with …VDoolhur 66 views 3 comments 0 points Most recent by User_2025-07-18-09-47-41-042 General Ledger & Intercompany
-
How to find an equivalent PVOs for 11i Tables in Fusion. example GL_Translation_Rates, Finacials_SysSummary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):Rocco Lucarelli-Oracle 62 views 4 comments 0 points Most recent by MariCostache-Oracle General Ledger & Intercompany
-
Can someone help me with the query for customizing the trial balance report.Summary: Currently i am trying to customize the oracle standard trial balance report for fetching the YTD,PTD and QTD balances. Need someone who can help with the logic …Rudraksha Vishnu 125 views 1 comment 0 points Most recent by MariCostache-Oracle General Ledger & Intercompany -
How to fetch invalid record count based on process/request id for FX Daily rates importSummary: We have a requirement to fetch success and error counts for a specific run by passing process id of a specific run . We noticed that the Interface GL_DAILY_RATE…Susmitha R 73 views 1 comment 0 points Most recent by Laura Petre-Oracle General Ledger & Intercompany
-
Translated Balance TB Load through Journal Import FBDISummary: Translated Balance TB Load through Journal Import FBDI Content (required): Business translates multiple countries ledger balances into "INR" Currency. As per my…Kumar 57 56 views 1 comment 0 points Most recent by Mary Ramirez-Oracle General Ledger & Intercompany -
How to set up cutoff date for posting to GLSummary: Hi! We need to set up a cutoff date so that users cannot post to GL after a certain date of the month, nearing period close. Could someone please provide us wit…ShailenS 105 views 4 comments 0 points Most recent by Antima Rai-Oracle General Ledger & Intercompany
-
SQL Query required to extract Translated Currency balances from Fusion or EBSSummary: SQL Query required to extract Translated Currency balances from Fusion or EBS Content (required): We are migrating from EBS to Fusion and migrating all TB's of …Kumar 57 744 views 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle General Ledger & Intercompany
-
Cross Instance ConsolidationSummary: Cross Instance Consolidation Content (required): We used to have a process for the Cross Instance Consolidation in E.B.S and would like to equivalent for this i…Afaq_Baig 42 views 3 comments 0 points Most recent by MariCostache-Oracle General Ledger & Intercompany
-
How can I auto reject the journals if journal lines have different balancing segments.Summary: I need to auto reject the journal if journal lines have different balancing segments. Content (required): Not sure how to configure BPM to auto reject a journal…Sabrinaxwang 53 views 3 comments 0 points Most recent by MariCostache-Oracle General Ledger & Intercompany
-
Security rule not work on Business unit levelSummary: We have TWO Security rule conditions and TWO Polices EX: Condition 1. Allow company 101(BU1) 2. Allow company 102(BU2) we have Two AP Invoice creation custome J…SIVAIAH JANAGANI 52 views 2 comments 0 points Most recent by MariCostache-Oracle General Ledger & Intercompany
-
Reverse Batch button is grey outSummary: Hi , We have some period end Accrual Journals for receipt accounting are created manually for the month of Sep and we want to reverse them Manually. Currently S…AJSHI 169 views 6 comments 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany
-
Balance Transfer ErrorSummary: Balance Transfer Error Content (required): Error message received when uploading balances to the GL. Please assist in resolving value used for ROWS parameter ch…CraigX 51 views 3 comments 0 points Most recent by MariCostache-Oracle General Ledger & Intercompany
-
Is there any solutions when spreadsheets freezes just before it connects to the environment?Summary: Spreadsheet freezes just before it connects to the environment. Is there any way to handle the following situation besides shutting down Excel? Content (require…Sawako Nishiuchi-Oracle 52 views 2 comments 0 points Most recent by CA Nirmal Choudhary General Ledger & Intercompany
-
GL Periods opened by MistakeSummary: We are in Jun period, one of the users accidentally opened Jul,Aug and Sep periods. He immediately closed those periods and now the status of Jul,Aug,Sep is clo…
-
Eliminate intercompany control accountsSummary: How can we eliminate intercompany control accounts ? Content (required): We have intercompany receivable and payable GL accounts that are fed from the sub-ledge…Michael Brown 52 views 2 comments 0 points Most recent by Hemalata-Oracle General Ledger & Intercompany
-
How to manage General Ledger Essbase Cube in Oracle fusionSummary: Hi Team, Could you please suggest on how and from where can we manage Oracle Fusion General Ledger Balances Cube? Thanks, Palak Singh Content (required): Versio…Palak Singh 176 views 6 comments 0 points Most recent by CA Nirmal Choudhary General Ledger & Intercompany
-
How to remove Period Close privilege completely from GL Manager/Accountant roles?Summary: I followed Doc ID 2323035.1 and was able to remove the Period Close Infotile using custom role however there are 3 other ways to go to open/close. 1. 'Manage Ac…Chinmayee Pattanaik 326 views 1 comment 0 points Most recent by CA Nirmal Choudhary General Ledger & Intercompany
-
How to specify a rate for the currency type User during the revaluation process?Summary: Content (required): Our revaluation rule was created with the currency type of User. When generating the revaluation process, there is no field to enter the cur…Veronique Gagnon 73 views 4 comments 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany -
Can we update the Default Conversion Rate Type for reporting and secondary ledgerSummary: We have a requirement for update the Default Conversion Rate Type for Reporting and Secondary ledgers. Content (required): 1. We can see the rate type field is …Heena Jesani 114 views 2 comments 0 points Most recent by Heena Jesani General Ledger & Intercompany
-
Trial Balance - Translation Rate AdjustmentsSummary: Trial Balance - Translation. Content (required): Kindly let me know the Fusion equivalent for the Trial Balance - Translation, particularly one with the column …Afaq_Baig 52 views 4 comments 0 points Most recent by MariCostache-Oracle General Ledger & Intercompany
-
Data migration to secondary ledger defined with conversion level adjustmentSummary: How to do legacy data migration to secondary ledger defined with conversion level adjustment ? Content (required): How to do legacy data migration to secondary …User_UHDZM 54 views 1 comment 0 points Most recent by MariCostache-Oracle General Ledger & Intercompany