how to Create ledger set in oracle r12

How to create ledger set in oracle r12

Hi Friends, We are going to discuss about Ledger Set in Oracle r12. As its name saying , Ledger set is related to GL ledger in Oracle r12. We do create the Ledger set for the GL ledgers. Ledger steps helps to put the control on multiple GL ledgers with very ease ans well it also helps the Ledger maintenance work very time saving. A ledger set is the combination of multiple ledgers in oracle r12 but in once ledger set we can combine only those ledgers which are sharing the same Chart of Account structure as well as they also have the same calendar. Under these conditions , we can create the ledger set in oracle apps r12. We will show the detail setup steps to create the ledger set in oracle apps. Please find below the more detail about how to create ledger set in oracle r12.

Features of ledger set in oracle r12

We can group multiple ledger which are sharing the same Chart of Account and same GL calendar. Using this feature , We can run Open & close Period for All Ledgers at once. We can run accounting program for multiple ledgers at once. Ledger sets allow you to run processes and reports for multiple ledgers simultaneously.

Step by Step to create ledger set in oracle r12

Step1:- We need to go the General Ledger Responsibility as below

Navigation: General Ledger --> Setup --> Financials --> Ledger sets.

Step2:- Enter a name for the Ledger Set.

Enter a Short Name for the ledger set.

Enter a Description for the ledger set.
Select the Chart of Accounts.
Select the  Calendar and Period Type for the Ledger set.

how to create ledger set in oracle r12

(Optional) Select the Enable Security checkbox to secure the Ledger Set definition. If you do not enable security, all users who have access to this definition will be able to use, view, and modify the ledger set definition. If the Assign Access function is available for your responsibility, the Assign Access
button will be enabled once you select the Enable Security checkbox. Choose the Assign Access button to assign the definition to one or more Definition Access Sets with the desired privileges.

Step3:- In the Ledger/Ledger Set column, choose the ledgers and/or ledger sets to be included in the ledger set. Only those ledgers and ledger sets that share the same chart of accounts, calendar, and period type specified for the ledger set definition will be available.

If you use reporting currencies (Journal or Sub Ledger Level), you can choose reporting currencies to be included in the ledger set. Only those reporting currencies that share the same chart of accounts, calendar, and period type specified for the ledger set definition will be available

Step 4:- Need to save the work. The General Ledger Accounting Setup Program will be submitted.

Step 5 :- Once the General Ledger Accounting Setup Program will be completed successfully , Then system automatically create the Data Access Set for the Ledger Set with the same name in oracle apps r12. 

Step 6:- To see the Data Access set in oracle apps r12 which is created automatically from the ledger set need to this below navigation.

Navigation: General Ledger --> Setup --> Financials -->Data Access Set

Step 7:- After the Data Access set has been created. Now we need to assign this Data Set for that Oracle responsibility which will have the access for all Ledgers and run all programs for all ledgers in oracle apps r12. 

Step 8:- To attach the data set with responsibility , we need to go the Profiles Option as below.

Navigation: System administrator --> Profiles --> Systems.

how to create ledger set in oracle r12

Here below , We have attached the Data Access set created from GL Ledger set in oracle apps r12. 

how to create ledger set in oracle r12

so now , this responsibility have the access to open and close or control the multiple ledgers at once. It really help to ease the operating and reduce the work timings.