Configuration File for BI Apps

Question

OBIEE 11.1.1.9.3
Oracle E-Business R12

I would like to populate the file_group_acct_codes_ora with the correct values for:

CHART OF ACCOUNTS ID
FROM ACCT
TO ACCT
GROUP_ACCT_NUM

Is there some SQL I can use to pull the correct values for the above fields so I can configure the GL Account Numbers in BI Apps.

CHART OF ACCOUNTS IDFROM ACCTTO ACCTGROUP_ACCT_NUM

User_ZZQJ0 · Answer

Thanks for the information.

Thomas Dodds · Answer

I've posted a starter SQL here:

Group Account Number Configuration

Then you take the ranges of accounts (with the help of a finance person) and you map them in the CSV file.  It's a domain file because you aren't sourcing the group mappings from your financial system -- you are 'making them up' to work with OBIA.  Those Group Account Nums are used throughout the ETL & RPD (in logical columns) to rollup individual account based data.