Ledger Sets

A ledger set is a group of ledgers that share the same chart of accounts and calendar/period type combination. Ledger sets allow you to run processes and reports for multiple ledgers simultaneously.

For example, you can open/close periods for multiple ledgers at once, run recurring journals that update balances for multiple ledgers, or run consolidated financial reports that summarize balances across multiple ledgers in a ledger set.

1. You can group all types of ledgers in a ledger set, such as primary ledger, secondary ledgers, and reporting currencies (journal and subledger levels), as long as they share the same chart of accounts and calendar/period type combination. The same ledger can belong to multiple ledger sets, and ledger sets can contain other ledger sets.

2. Oracle General Ledger automatically creates a data access set when the following occurs:

• A ledger is created
• A ledger set is defined

The system-generated data access set for a ledger uses the same name as the ledger. This data access set uses the Full Ledger access set type that provides full read and write access to the ledgers. The system-generated data access set for ledger sets uses the same name as the ledger set. This data access set uses the Full Ledger access set type that provides full read and  write access to all of the ledgers assigned to the ledger set.

If the level of access provided by the system–generated data access set is sufficient for your needs, you do not need to manually create a data access set; just use the one created by the system. You only need to create your own data access sets when you want to further limit read and write access to ledgers, ledger sets, or specific balancing segment values or
management segment values for a ledger or ledger set.

Data Access Sets
Data access sets control which ledgers can be accessed by different responsibilities. Data access sets can also limit a user from accessing certain balancing segment values or management segment values or grant read–only or read and write access to data in a ledger.

General Ledger automatically creates a data access set when you define a ledger or ledger set. This system-generated data access set provides full read and write access to ledgers. You can also provide more limited access to your ledgers and ledger sets by defining your own data access sets. Your System Administrator must assign the data access set that you want to use to the profile option GL: Data Access Set for each responsibility.

You can define three types of data access sets:

• Full Ledger: Grants access to all the data in a ledger. For example, in a data access set with two ledgers, A and B, you can grant read-only privileges to all the data in Ledger A and grant read and write privileges to all the data in Ledger B.
• Balancing Segment Value: Grants access to all or specific ledger/balancing segment value (BSV) combinations. For example, you can have a data access set with Ledger A, and grant read-only privileges to balancing segment value 01, grant read and write privileges to balancing segment value 02, and grant no access to balancing segment value 03 in the same ledger. This is useful for companies that use a small number of ledgers with a high number of balancing segment values to represent multiple companies or legal entities.
• Management Segment Value: Grants access to all or specific ledger/management segment value (MSV) combinations. For example, you can have a data access set with ledger A and grant read only privileges to management segment value 100, grant read and write privileges to management segment value 200, and grant no access to management segment value 300. This can only be used if you have specified a management segment in your chart of accounts

Note: The Full Ledger access set type provides better system performance than the Balancing Segment Value or Management Segment Value access set type.
Note: When you assign specific balancing segment values/management segment values, you can specify all values,
parent values that include their child values, or child valuesindividually.

You must specify one of the three types for each data access set. Once defined, you cannot alter the type. You can only add or delete ledgers/ledger sets and segment values specified in the data access set.