1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

R12- Ledgers and Ledger Sets- FAQ-1

Discussion in 'Oracle Financials' started by Ramji, Feb 8, 2012.

  1. Ramji

    Ramji Forum Guru

    Likes Received:
    Trophy Points:
    Setting up and Giving Access to Ledgers with different COA- How TO

    All ledgers in a Ledger Set must share the same chart of accounts and accounting calendar/period type combination. So a Ledger Set can not be used in this case, where the charts of accounts are different.
    Instead, separate responsibilities must be used for access to each ledger.

    The steps are as follows:

    1. Define the Ledgers and complete the Accounting setup:
    - Define a chart of accounts mapping to map the primary COA to the secondary COA.
    - Define your Primary Ledger in the accounting setup.
    - In the same accounting setup, define a Secondary Ledger. Since your Secondary Ledger uses a
    different chart of accounts, specify a chart of accounts mapping.

    When the accounting setup is Complete, the General Ledger Accounting Setup Program is launched.
    This program automatically creates a data access set for each ledger and reporting currency
    (journal level or subledger level) assigned to that accounting setup.
    The system-generated data access sets created for each ledger and reporting currency provide full
    read and write access to the ledger and all of its balancing segment values and management segment
    values. If more restrictive data access sets are needed, those can be created manually.

    2. To associate a data access set to a responsibility, you must assign a data access set to the GL:
    Data Access Set profile option.

    Set the profile GL:Data Access Set:
    - At the Responsibility level for the responsibility that will access the Primary Ledger, set this to the Data Access set for the Primary Ledger
    - At the Responsibility level for the responsibility that will access the Secondary Ledger, set this to the Data Access Set for the Secondary Ledger

    The responsibility for the Secondary Ledger would be used for things such as Open Period, Account Inquiry, etc. The propagation of the data to the Secondary Ledger from the Primary is handled by the application, depending on the type of secondary subledger you have. So for the most part, as you're processing your transactions in the primary ledger, they're sent to the secondary (similar to how MRC worked in earlier releases).

    See the Oracle Financials Implementation Guide for more details on these 4 types of Secondary Ledgers:

    • Subledger Level Secondary Ledgers - maintained using both Subledger Accounting and the General
    Ledger Posting program.
    • Journal Level Secondary Ledgers - maintained using the General Ledger Posting Program
    only.Every time you post a journal in the primary ledger, the same journal is automatically
    replicated and maintained in the secondary ledger, depending on the journal
    conversion rules specified for the secondary ledger.
    • Balance Level Secondary Ledgers - the GL Consolidation is used to transfer the balances from
    the primary to the secondary.
    • Adjustments Only Secondary Ledger - adjustments can be manually entered into the secondary
    ledger, or automated using Subledger Accounting
    agungterminanto likes this.