My Oracle Support Banner

OBIA 11g Can You Use the Natural Account Range instead of Defining an Individual Account In the File_group_acct_codes_ora.csv For Financial Analytics? (Doc ID 1956750.1)

Last updated on MARCH 17, 2021

Applies to:

Business Intelligence Applications Consumer - Version and later
Information in this document applies to any platform.


  1. While configuring file_group_acct_codes_ora.csv file can you use the Natural Account Range instead of defining an individual account?
    In the Documentation table B-3 talks about range but an example further down talks about individual account.
    Oracle® Business Intelligence Applications Configuration Guide 11g Release 1 ( E51480-01
    B.2.18.1 Overview of Mapping Oracle GL Accounts to Group Account Numbers
    Table B-3 Example Configuration of file_group_acct_codes_ora.csv File

      2. What values should be added for the GROUP_ACCT_NUM field when you have multiple sub-accounts in the EBS system for A/R?
          Do you set up the Parent account name (i.e. A/R with the range 01000 to 01499), or do you set up individual sub-accounts
          (i.e. A/R Trade, A/R Employees, and A/R Taxes) and leave out the Parent (A/R) altogether?

          All Parent and Child Accounts have ranges.

For example, in EBS:

Parent/Child Description Low Account # High Account #
P0100 A/R 01000 01499
P0110 A/R Trade 01000 01212
P0120 A/R Employees 01214 01299
P0130 A/R Taxes 01302 01499





To set up Financial Analytics (file_group_acct_codes_ora file) do you:

A) Set up ONLY the PARENT account ranges
B) Set up ONLY the CHILD account ranges
C) Set up BOTH PARENT and CHILD ranges




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.