Oracle^® Business Intelligence Applications Installation and Configuration Guide > Configuring Oracle Financial Analytics > Process of Configuring Oracle Financial Analytics for Oracle 11i >

Mapping Oracle General Ledger and Profitability Analytics Account Numbers to Group Account Numbers

This task is a step in the Process of Configuring Oracle Financial Analytics for Oracle 11i.

NOTE:  It is critical that the General Ledger Account Numbers are mapped to the Group Account Numbers (or domain values) as the metrics in the General Ledger reporting layer uses these values. For a list of domain values for General Ledger Account Numbers, see Oracle Business Analytics Warehouse Data Model Reference.

You can categorize your Oracle General Ledger accounts into specific group account numbers. You may use this information during data extraction as well as front-end reporting. The GROUP_ACCT_NUM field denotes the nature of the Siebel General Ledger Analytics accounts. For example, Cash account, Payroll account, and so on. Refer to the master_code column in the file_group_acct_names_ora11i.csv file for values you can use. For a list of the Group Account Number domain values, see Oracle Business Analytics Warehouse Data Model Reference.The mappings to General Ledger Accounts Numbers are important for both Profitability Analysis (Income Statement) and General Ledger accounts.

The logic for assigning the accounts is located in the file_group_acct_codes_ora11i.csv file. Table 60 shows the layout of the file_group_acct_codes_ora11i.csv file.

In Table 60, in the first row, all accounts within the account number range from 101010 to 101099 containing a Set of Books (SOB) ID equal to 1 are assigned to Current Asset. Each row maps all accounts within the specified account number range and with the given Set of Books ID.

If you need to create a new group of account numbers, you can create new rows in the file_group_acct_names_ora11i.csv file. You can then assign GL accounts to the new group of account numbers in the file_group_acct_codes_ora11i.csv file.

NOTE:  When you specify the Group Account Number, you must capitalize the letters and use the values in the master_code column of the file_group_acct_names_ora11i.csv file.

To map Oracle General Ledger and Profitability Analytics Accounts to Group Account Numbers

1. Open the file_group_acct_codes_ora11i.csv file with Microsoft WordPad or Notepad in the $pmserver\srcfiles folder.
2. Edit the fields in the following table:

   Field Name	Description
   SOB ID	The set of books ID for the Siebel General Ledger Analytics accounts.
   FROM ACCT and TO ACCT	The From Account and To Account specify the range of Oracle General Ledger and Profitability Analytics accounts for the mapping. The value you specify comes from the value of the natural account segment of the Siebel General Ledger Analytics account.
   GROUP_ACCT_NUM	This field denotes the nature of the Siebel General Ledger Analytics accounts. For example, Cash account, Payroll account, and so on. Refer to the file_group_acct_names_ora11i.csv file for values you can use.

   NOTE:  It is important that you do not edit any other fields in the CSV files.

3. Save and close the CSV file.