General Ledger
Discussion List
-
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 102 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 82 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 58 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 63 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 143 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 71 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 102 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 785 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 51 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 51 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 191 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 53 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 191 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 358 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 72 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 113 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 51 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 51 views 1 comment 0 points Most recent by MariCostache-Oracle General Ledger & Intercompany -
Secondary to Primary Ledger TransferHi all, Thank you in advance for your help. Kindly note the below: If a primary ledger created in 2020 contains journals from 2020-2023, and a new secondary ledger creat…Faysal Boughanem 93 views 1 comment 0 points Most recent by MariCostache-Oracle General Ledger & Intercompany
-
How many GL accounts we can able to assign at primary ledger level?Summary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):
-
Table gl_je_batches not up to date in BIP?Hi Guys I have an issue today when accessing table gl_je_batches via BIP, I am not seeing the very latest batches in there which I know have been created because I can s…
-
Translate General Ledger Account BalancesSummary: Hello, When running the 'Translate General Ledger Account Balances' the system isn't giving me any values in Target Currency LOV. Is there something that I need…Ayub 32 views 1 comment 0 points Most recent by Hussian Sharief M-Oracle General Ledger & Intercompany
-
Change financial calender mid yearSummary: Content (required): Client requirement to change financial calender without implementation. For example financial calender in the general ledger is Jan - Dec. R… -
How to avoid disabled segment values coming up in a findSummary: Hello, 1) we have disabled and end dated a large amount of values in our entity segment. Even though these values are disabled, they still appear in 'Inquire on…James Coles 155 views 7 comments 0 points Most recent by CA Nirmal Choudhary General Ledger & Intercompany