GL - Setting Up General Ledger: Step-by-Step Guide in Oracle Fusion

GL - Setting Up General Ledger: Step-by-Step Guide in Oracle Fusion

CA Suhas Vaze

Overview

Setting up the General Ledger (GL) is a foundational activity in Oracle Fusion Financials. A properly configured GL ensures accurate accounting, reporting, and compliance. This guide walks through GL — Setting Up General Ledger step by step, from initial setup to posting the first journal.

For a comprehensive, hands-on walkthrough of General Ledger setup and the full Oracle Fusion Financials suite — including Accounts Payable, Fixed Assets, Cash Management, and more — check out our Oracle Fusion Financials Training. The course covers each of these topics in depth with live Oracle Cloud demonstrations.

For official Oracle documentation on General Ledger setup, accounting calendars, and Chart of Accounts configuration, refer to the Oracle Financials Cloud Documentation. You can also access the General Ledger specific documentation and the detailed General Ledger setup guide for comprehensive reference materials.

GL - General Ledger

A General Ledger (GL) is the central accounting record used to store and summarize all financial transactions of an organization. It captures transactions across assets, liabilities, revenues, expenses, and equity and serves as the foundation for preparing key financial reports such as the balance sheet, income statement, and cash flow statement.

In Oracle Fusion General Ledger, the General Ledger functions as the core of the financial system, where data from subledgers is posted, validated, and consolidated. A properly configured GL ensures accurate accounting, compliant financial reporting, and effective financial control, making it a critical part of setting up a general ledger in Oracle Fusion.

Step 1: Create an Implementation Project

The first step in GL Setting Up General Ledger is creating an implementation project.

This helps group and manage all financial setup tasks. A separate video explains this in detail — please refer to the link provided below: Creating Implementation Project

Blog Link: Creating Implementation Project Blog

Step 2: Create Chart of Accounts (CoA)

Next, define the Chart of Accounts, which structures how financial data is recorded and reported.

Calendars. This step is also covered in a separate video. Refer to the link below for a detailed walkthrough: GL Create Chart of Accounts

Blog Link: Oracle Fusion Chart of Accounts Blog

Step 3: Create Accounting Calendar

Go to the Tasks menu and search for Manage Accounting Calendars. Click on the Search icon, then select Manage Accounting Calendars from the results to open the setup page.

Navigate to Manage Accounting Calendars from the Tasks menu in Oracle Fusion General Ledger setup

Click Go to Task, then click Plus (+) to define a new calendar.

Click Go to Task and use the Plus icon to create a new accounting calendar in Oracle Fusion General Ledger

Enter the calendar details. The start date determines the first accounting period. Choose an existing adjusting period frequency.

Define the start date and select an adjusting period frequency while setting up an accounting calendar in Oracle Fusion General Ledger

Click Next.

Click Next to proceed with accounting calendar setup in Oracle Fusion General Ledger

Oracle automatically generates the calendar. Review the generated calendar. Click Add Year to add future years (for example, 2016).

Click Add Year to add future accounting years to the accounting calendar in Oracle Fusion General Ledger

Save the calendar.

Click Save to confirm and store the accounting calendar configuration in Oracle Fusion General Ledger

Once all required years are added, save and close, then click Done.

Save the accounting calendar during Oracle Fusion General Ledger setup

Click Done.

Click Done to complete the accounting calendar setup in Oracle Fusion General Ledger

Step 4: Enable Currency

Navigate to Manage Currencies.

Navigate to Manage Currencies in Oracle Fusion General Ledger setup

Search for the currency you intend to use.

Search for the required currency in Manage Currencies within Oracle Fusion General Ledger

If it is not enabled, select the Enabled checkbox. Save your changes.

Enable the currency by selecting the Enabled checkbox and saving changes in Oracle Fusion General Ledger

Step 5: Select Accounting Method

Accounting methods are seeded by Oracle. For standard implementations, use the Standard Accounting Method. You only need to create a new accounting method if you plan to customize accounting rules.

Go to Manage Legal Addresses.

Navigate to Manage Legal Addresses in Oracle Fusion setup

Click Plus (+) to create a new address.

Click the Plus icon to create a new legal address in Oracle Fusion

Enter the legal address details. Click OK, then Save.

Confirm the legal address by clicking OK and Save in Oracle Fusion

Save the address.

Save the legal address in Oracle Fusion setup

Navigate to Manage Legal Jurisdictions.

Navigate to Manage Legal Jurisdictions in Oracle Fusion setup

Search for an existing jurisdiction for your country.

Search for an existing legal jurisdiction for your country in Oracle Fusion

If an identifying jurisdiction already exists, no action is needed. If not, click Plus (+) to create one.

Click the Plus icon to create a new legal jurisdiction in Oracle Fusion

Enter details and set Identifying = Yes. Save the jurisdiction.

Save the legal jurisdiction in Oracle Fusion setup

Go to Manage Legal Entities.

Navigate to Manage Legal Entities in Oracle Fusion setup

Select Create New and click Apply and Go to Task.

Select Create New and click Apply and Go to Task in Manage Legal Entities

Click Plus (+) to create a legal entity.

Click the Plus icon to create a new legal entity in Oracle Fusion

Enter entity details. Select the legal address created earlier. Save the legal entity.

Save the legal entity in Oracle Fusion setup

Go to Manage Legal Entity Registrations.

Navigate to Manage Legal Entity Registrations in Oracle Fusion setup

Choose Select an Option and click Apply.

Select an option and click Apply in Legal Entity Registrations

Search for your legal entity.

Search for the legal entity in Manage Legal Entity Registrations

Click Save and Close, then Done.

Save and close the legal entity registration and click Done in Oracle Fusion

Click Done.

Click Done to exit Legal Entity Registration setup in Oracle Fusion

Step 10: Define Primary Ledger

Navigate to Manage Primary Ledger.

Navigate to Manage Primary Ledger in Oracle Fusion General Ledger setup

Click Plus (+) to create a new ledger.

Click the Plus icon to create a new primary ledger in Oracle Fusion General Ledger

Enter the ledger name. Select the four Cs: Chart of Accounts, Accounting Calendar, Currency, and Accounting Method. Save the ledger.

Enter the ledger name while defining the primary ledger in Oracle Fusion

Go to Assign Legal Entities.

Navigate to Assign Legal Entities in Oracle Fusion General Ledger setup

Choose Select and Add, then click Apply.

Select Select and Add and click Apply in Assign Legal Entities

Select your ledger and click Save and Close.

Select the ledger and click Save and Close in Assign Legal Entities

Click Plus (+) to add a legal entity.

Click the Plus icon to add a legal entity to the ledger in Oracle Fusion

Search and assign the legal entity to the ledger.

Search and assign a legal entity to the ledger in Oracle Fusion General Ledger

Search the legal entity and assign it to the ledger. Click Apply.

Search the legal entity, assign it to the ledger, and click Apply

Save and close.

Save and close legal entity assignment in Oracle Fusion General Ledger

Step 12: Specify Ledger Options

Go to Specify Ledger Options.

Navigate to Specify Ledger Options in Oracle Fusion General Ledger setup

Set the first accounting period to be opened. Select the reporting language. Enter:

  • Retained earnings account

Enter retained earnings and cumulative translation adjustment accounts in ledger options

  • Cumulative translation adjustment account

Select the corporate conversion rate. Specify other accounts such as suspense and rounding.

Enable suspense for General Ledger and subledger accounting

Enable suspense for:

  • General Ledger
  • Subledger Accounting

Save ledger options.

Save ledger options in Oracle Fusion General Ledger

Step 13: Review and Submit Accounting Configuration

Go to Review and Submit Accounting Configuration.

Navigate to Review and Submit Accounting Configuration in Oracle Fusion General Ledger

Confirm that your ledger and legal entity are displayed. Click Submit.

Click Submit to submit the accounting configuration in Oracle Fusion

Click OK.

Click OK to confirm submission of accounting configuration

Navigate to Scheduled Processes.

Navigate to Scheduled Processes in Oracle Fusion

Ensure that the process is completed successfully.

Verify successful completion of the accounting configuration process

Step 14: Assign Roles to Users

Open Security Console. Go to the User Accounts tab. Search for the required user. Click the username.

Search for the required user and open the user profile in Oracle Fusion

Edit.

Edit the user account to assign roles in Oracle Fusion

Add roles.

Add roles to the user account in Oracle Fusion

Assign the following roles:

General Accountant

Assign the General Accountant role to the user

Job

Assign Controller role to the user in Oracle Fusion

Controller

Financial Analyst

Assign Financial Analyst role to the user in Oracle Fusion

Chief Financial Officer

Click Done. Save and close.

Save and close the user role assignment

Step 15: Assign Data Access

Go to Manage Data Access for Users.

Navigate to Manage Data Access for Users in Oracle Fusion

Click Plus (+).

Click the Plus icon to add a new data access assignment in Oracle Fusion

Enter the username.

Enter the username while assigning data access in Oracle Fusion

Select the appropriate Data Access Set. Save the assignment. Repeat for other roles such as Controller, Financial Analyst, and CFO.

Repeat data access assignment for Controller, Financial Analyst, and CFO roles

Click Done.

Click Done to complete data access assignment in Oracle Fusion

Step 16: Run Retrieve Latest LDAP Changes

Go to Scheduled Processes.

Navigate to Scheduled Processes in Oracle Fusion

Schedule a new process.

Schedule a new process in Scheduled Processes

Retrieve Latest LDAP Changes.

Select Retrieve Latest LDAP Changes process in Oracle Fusion

Click Submit.

Click Submit to run the Retrieve Latest LDAP Changes process

Wait until the process completes successfully.

Verify successful completion of Retrieve Latest LDAP Changes process

Step 17: Open Accounting Periods

Log in as the newly assigned user.

Log in as the newly assigned user in Oracle Fusion

Navigate to General Accounting, then Period Close.

Navigate to General Accounting and Period Close in Oracle Fusion

Select the Data Access Set as your ledger name.

Select the data access set using the ledger name

Open General Ledger.

Open General Ledger from Period Close in Oracle Fusion

Click OK to open the first period.

Click OK to open the first accounting period

Click OK.

Click Yes to confirm opening the accounting period

Click Yes.

Click Yes to confirm opening the accounting period

Monitor the submitted process until it is complete.

Monitor the submitted process

It will be shown as Succeeded.

Verify the process status shows Succeeded

Refresh periods. Use Actions, then Open Target Period.

Use Actions menu to open the target accounting period

Open all periods up to the current period.

Open all accounting periods up to the current period

The process will be submitted; click OK.

Confirm submission of the open period process

Step 18: Enter and Post a Journal

Go to the Journals work area.

Navigate to the Journals work area in Oracle Fusion General Ledger

Open the right-side menu and click Create Journal. Enter journal header details.

Enter journal header details in Oracle Fusion General Ledger

Define Category.

Enter journal lines in Oracle Fusion General Ledger

Enter journal lines.

Save the journal in Oracle Fusion General Ledger

Save the journal.

Enter journal lines in Oracle Fusion General Ledger

Complete the journal.

Complete the journal in Oracle Fusion General Ledger

Post a journal.

Post the journal in Oracle Fusion General Ledger

The process has been submitted.

View submitted journal posting process in Oracle Fusion

Verify successful posting from Manage Journals.

Verify successful journal posting from Manage Journals

Step 19: Verify Posting Status

Navigate to Manage Journals.

Navigate to Manage Journals in Oracle Fusion General Ledger

Search for the journal.

Search for the journal in Manage Journals

See that the journal is posted and click Done.

Verify the journal is posted and click Done in Oracle Fusion General Ledger

Conclusion

With journals successfully posted, your setup is complete. Your ledger is now fully operational, and GL — Setting Up General Ledger in Oracle Fusion has been completed end to end. This configuration forms the backbone for accurate accounting, reporting, and financial control across your organization.

Frequently Asked Questions

Common errors when uploading the Chart of Accounts spreadsheet in Oracle Fusion

Errors during Chart of Accounts upload in Oracle Fusion General Ledger are usually caused by invalid segment values, duplicate entries, incorrect value set types, or disabled segments. Using an outdated template or incorrect parent-child hierarchies can also cause upload failures.

How to create and deploy flex field segments for GL in Oracle Fusion

To create flex field segments for GL, define the accounting flex field under Manage Chart of Accounts, assign value sets to each segment, and deploy the flex field. Deployment is required before the segments can be used in ledgers or journal entries in Oracle Fusion General Ledger.

Steps to open the first GL period after setup in Oracle Fusion

After completing GL setup, navigate to General Accounting, then Period Close, select the ledger data access set, and open the first accounting period. Monitor the submitted process until it completes successfully, then refresh and open periods up to the current period.

How to assign General Ledger roles to user profiles in Oracle Fusion

General Ledger roles are assigned through the Security Console. Edit the user account, add roles such as General Accountant, Controller, or Financial Analyst, save the changes, and run Retrieve Latest LDAP Changes to activate the roles in Oracle Fusion.

Each legal entity in Fusion GL should represent a statutory reporting unit and be correctly linked to ledgers and business units. Use consistent naming, assign legal addresses and jurisdictions early, and align entities properly to support accurate reporting and compliance.

Feedback

How would you rate your experience on OracleErpGuide.com?

Poor Amazing
Feedback (optional)

Request a Callback

Get 30% off on All
EBS Installations !

Get Oracle EBS R12 Remotely
Installed on your Device at 30% Off

Thanksgiving Discount !

Offer Valid till 30th Nov 2021

Coupon OEGEBSINST30

Valid on:

  • R12.1.3
  • R12.2.3
  • R12.2.6
  • R12.2.9
  • R12.2.10 [New!]