My Oracle Support Banner

OBIA 7964: AGGREGATION LINE IN File_glacct_segment_config_ora.csv (Doc ID 1603840.1)

Last updated on FEBRUARY 22, 2019

Applies to:

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


Implementing Oracle Financial Analyzer (OFA). Source system is Oracle EBS R12.1.3.

To have hierarchy for Chart of Accounts (COA) based on value set in Oracle EBS. Hence values have been put in the file file_glacct_segment_config_ora.csv as part of the configuration.

It is understood that this file needs an AGGREGATE LINE where CHART_OF_ACCOUNT_ID = AGGREGATION.

By default the value is set as Y from segment1 to segment 6 like "AGGREGATION, Y, , Y, , Y, , Y, , Y, , Y".

  1. What is the significance of the aggregation line?
  2. What will happen if I choose to put Y on all segment or just on segment 2 and segment 8. (We have 10 segments in our COA)?


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.