Map Oracle GL Account Numbers to Group Account Numbers

This section explains how to map Oracle General Ledger Account Numbers to Group Account Numbers.

Note:

If you add new Group Account Numbers to the file_group_acct_codes_<source system type>.csv file, you must also add metrics to the BI metadata repository (that is, the RPD file).

To map Oracle GL account numbers to group account numbers:

1. Edit the file_group_acct_codes_ora.csv file.
   
   Note:

   The configuration file or files for this task are provided on installation of Oracle BI Applications at one of the following locations:
   Source-independent files: <Oracle Home for BI>\biapps\etl\data_files\src_files\.
   Source-specific files: <Oracle Home for BI>\biapps\etl\data_files\src_files\<source adaptor>.
   Your system administrator will have copied these files to another location and configured ODI connections to read from this location. Work with your system administrator to obtain the files. When configuration is complete, your system administrator will need to copy the configured files to the location from which ODI reads these files.
   
2. For each Oracle GL account number that you want to map, create a new row in the file containing the following fields:
   

   Field Name	Description
   CHART OF ACCOUNTS ID	The ID of the GL chart of account.
   FROM ACCT	The lower limit of the natural account range. This is based on the natural account segment of your GL accounts.
   TO ACCT	The higher limit of the natural account range. This is based on the natural account segment of your GL accounts.
   GROUP_ACCT_NUM	This field denotes the group account number of the Oracle General Ledger account, as specified in the warehouse domain Group Account in Oracle BI Applications Configuration Manager. For example, 'AP' for Accounts Payables, 'CASH' for cash account, 'GEN PAYROLL' for payroll account, and so on.

   For example:
   

   101, 1110, 1110, CASH
   101, 1210, 1210, AR
   101, 1220, 1220, AR
   

   Note:

   You can optionally remove the unused rows from the CSV file.
   
3. Ensure that the values that you specify in the file_group_acct_codes_ora.csv file are consistent with the values that are specified in Oracle BI Applications Configuration Manager for Group Accounts.
   
4. Save and close the CSV file.