Oracle Application's Blog: How to create secondary ledger in oracle fusion

Saturday 4 July 2020

How to create secondary ledger in oracle fusion

Hi Friends, We are going to discuss the secondary ledger in oracle fusion. We will share the steps to create the secondary ledger in oracle fusion. A secondary ledger is an optional ledger linked to a primary ledger for the purpose of tracking alternative accounting. A secondary ledger can differ from its primary ledger by using a different accounting method, chart of accounts, accounting calendar, currency, or processing options. Here below is the more detail about how to create secondary ledger in oracle fusion

Journal Conversion Performed between Primary and Secondary ledger in Oracle Fusion (SL)?

Secondary ledgers have the following four conversion levels:

* Subledger Journals level:

This level maintains subledger journals, general ledger journal entries, and balances in the additional accounting representation.

SLA creates the information directly into the SL for sources/categories that use For other sources/categories that do not use SLA, the GL Posting program creates the information in the SL.

* Journal level:

This level maintains primary ledger journal entries and balances in an additional accounting representation.

Every time a journal is posted in the Primary ledger, it gets created in the Secondary
Posting in the Secondary ledger happens in a separate step.

It can be determined which journal sources/categories will be replicated when posting takes

This is done in ASM in the Journal Conversion Rules.

* Balances level:

This level maintains primary ledger balances in another accounting representation.

It uses the Consolidation program to transfer balances from the PL to the SL.

* Adjustment only level:

This type of ledger only provides an incomplete accounting representation holding only adjustments.

The chart of accounts, accounting calendar, and currency must be the same as the primary ledger.

Step by Step to create secondary ledger in oracle fusion

In our Case we are creating the Secondary Ledger, because our Calendar is different from the Primary ledger. In Primary Ledger , Our Accounting Year starts from Apr to Mar(IN) but in Secondary Ledger , Our Accounting period starts from Oct to Sep(US)

Go to Implementation project and follow this below navigation to access the task ‘Define Secondary Ledgers’ to create Secondary Ledger.

Financials

Define Common Applications Configuration for Financials

Define Ledgers

Define Accounting Configurations

Define Secondary Ledgers