Configuration File for BI Apps — Oracle Analytics

Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Configuration File for BI Apps

Received Response
1
Views
2
Comments
User_ZZQJ0
User_ZZQJ0 Rank 4 - Community Specialist
edited Aug 13, 2024 6:09PM in Oracle Analytics Cloud and Server

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 ID
FROM ACCT
TO ACCT
GROUP_ACCT_NUM

Answers

  • Thomas Dodds
    Thomas Dodds Rank 8 - Analytics Strategist

    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.

  • User_ZZQJ0
    User_ZZQJ0 Rank 4 - Community Specialist

    Thanks for the information.