Consolidation of Balances

How to consolidate the balances by transfer in Oracle Fusion

Welcome to the guide for Consolidation of Balances. Follow these precise instructions to consolidate the balances in the G.L module.

Click on the Navigator button and go to the Tools menu.

Click here

Access the Tools menu.

Click 'Tools'

Open the Scheduled Processes tab.

Click 'Scheduled Processes'

Initiate a new schedule process.

Click 'Schedule New Process'

Enter the process name as Transfer Ledger Balances to transfer balances to the consolidation ledger.

Click 'OK'

Click on Ok.

Click 'OK'

Select a Source Ledger.

Click here

Select a Target Ledger.

Click 'Target Ledger'

Select the Chart of Mapping as required.

Fill 'AAGL ConsolidationAAGL Consolidation - DistributionAAGL Consolidation - Retail'

Select an Amount Type.

Fill 'PJTD Project to date balance type.PTD Period to date balance type.QTD Quarter to date balance type.YTD Year to date balance type.'

Select a Source and a Target Ledger Period.

Fill '...'

Ensure that checkboxes for Run Journals Import and Create Summary Journals are ticked.

Click here

Select a Company.

Click 'Company'

Click on the Submit button to proceed.

Click 'Submit'

Click on Ok.

Click 'OK'

You can review that the process is successful.

Click 'ViewFlat ListHierarchy'

Navigate to the General Accounting menu.

Click here

Go to the Task Pane to see the available tasks.

Click here

Select Manage Journals task.

Click 'Manage Journals'

Navigate to the Data Access Set to change the access to Consolidation Ledger.

Click 'Change'

Search the journals with any of the available parameters.

Click 'Journal Batch'

Click on the Search button.

Click 'Search'

Click on a Journal Name to open a journal.

Click '30-04-24 AAGL Consolidation Balance Transfer'

View and verify the Header Level details of a Journal.

Click 'Jan-24  PJTD  balances transferred from ActewAGL Ledger'

Verify the journals created by the system to consolidate the balances.

Click here

This guide covers the process of Consolidating the Balances in GL in Oracle Cloud. These instructions provide a comprehensive overview for successful consolidation of Balances.

Thank you for reviewing and using our guide; we hope you have found it helpful. If you have any questions on the content included in this guide, please contact our Training & Learning team at learn@camptratech.com

Scroll to Top