Scribd
Upload
18 views1 page

To Do Group Account Correction

To correct group account mappings in a CSV file: 1. Open and edit the file_group_acct_codes_ora.csv file located in the odidatafiles directory to change the mapping of general ledger accounts to group accounts. 2. Start the Oracle BI Applications Configuration Manager and navigate to the Administer ELT Parameters page to set the LOAD_CALCULATE_GL_BALANCE parameter value. 3. This will update the group account mappings in the CSV file and trigger a reload of the group account balances.

Uploaded by

mvenkatchary
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
18 views1 page

To Do Group Account Correction

To correct group account mappings in a CSV file: 1. Open and edit the file_group_acct_codes_ora.csv file located in the odidatafiles directory to change the mapping of general ledger accounts to group accounts. 2. Start the Oracle BI Applications Configuration Manager and navigate to the Administer ELT Parameters page to set the LOAD_CALCULATE_GL_BALANCE parameter value. 3. This will update the group account mappings in the CSV file and trigger a reload of the group account balances.

Uploaded by

mvenkatchary
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 1

To do Group Account correction:

1. Open the file file_group_acct_codes_ora.csv with a text editor in the


$ODI_HOME\biapps_odi\odifiles\odidatafiles\srcfiles directory.
2. Change the mapping of the GL Natural account to the group account in the CSV file.

For example, before the change, the CSV file might have the following values:

CHART OF ACCOUNTS ID = 101

FROM ACCT = 1110

TO ACCT = 1110

GROUP_ACCT_NUM = CASH

After the change, if the account '1210' originally belonged to the 'AP' Group Acct
Num and after correcting the GL Natural account to the group account, the CSV file
would have the following values:

CHART OF ACCOUNTS ID = 101

FROM ACCT = 1210

TO ACCT = 1210

GROUP_ACCT_UM = AR

3. Start Oracle BI Applications Configuration Manager (for more information, see


Section 4.5.8.9, "How to Login to Oracle BI Applications Configuration Manager
Using A Connection").
4. Select the Administer ELT Parameters link.
5. Display the Global tab.
6. Locate the following parameters and use the Parameter Value field to set the value:
o LOAD_CALCULATE_GL_BALANCE

You might also like