A chart of accounts mapping is a set of instructions for mapping accounts or entire account segments from one chart of accounts to another chart of accounts. You can use chart of accounts mapping for consolidation purposes and for secondary ledgers.
A chart of accounts mapping can be assigned to a consolidation definition that is used to transfer consolidation data from your subsidiary ledger to your parent ledger.
The number of mappings that you need depends on the number of different charts of accounts used by each ledger or subsidiary. If all of your ledgers or subsidiaries share the same chart of accounts, you only need to create one chart of accounts mapping for consolidation purposes.
A chart of accounts mapping is required for secondary ledgers that use a different chart of accounts from their respective primary ledgers. If you do not assign a chart of accounts mapping when your primary and secondary ledgers use different charts of accounts, it will cause errors with Oracle Subledger Accounting and General Ledger Posting, depending on the data conversion level for your secondary ledger.
Note: To assign the chart of accounts mapping, use the Primary to Secondary Ledger Mapping page in Accounting Setup Manager.
If your primary and secondary ledgers use the same chart of accounts, you can optionally assign a chart of accounts mapping to the Journal level and Balance level secondary ledgers. This allows you more flexibility to use different rollup rules when transferring journals or balances from the primary ledger to the secondary ledger. For example, you can maintain more detailed information in your primary ledger but maintain more summarized information in your secondary ledger, depending on the rollup rules you define for your chart of accounts mapping.
For more information, see Secondary Ledger.
If you want to secure use, view, or modify access to your chart of accounts mapping, you can secure your mapping using definition access sets. For example, you can prevent a mapping from being used in consolidations, viewed online or in reports, or modified by other users.
Prerequisites
Define your charts of accounts.
Navigate to the Chart of Accounts Mappings window.
Enter a Mapping name and Description.
In the Chart of Accounts region, choose the Target chart of accounts and the Source chart of accounts.
Select Mapping Rules to map segment rules and/or account rules from your source and target charts of accounts. See: Select Mapping Rules.
(Optional) Select the Enable Security checkbox to apply definition access set security to your chart of accounts mapping.
Definition access sets are an optional security feature that allows you to control access to your General Ledger definitions. For example, you can prevent certain users from viewing, making changes, or using your chart of accounts mapping for consolidation definitions.
If you do not enable security, all users will be able to use, view, modify, and delete your chart of accounts mapping.
If the Assign Access function is available for your responsibility, the Assign Access button is enabled once you select the Enable Security check box. Choose the Assign Access button to assign the definition to one or more definition access sets with the desired privileges.
For more information, see Definition Access Sets.
Save your chart of accounts mapping.