Chart of accounts table in oracle fusion

Chart of accounts table in oracle fusion

In this post , we will be discuss about chart of accounts table in oracle fusion. Chart of Accounts is related to the Key Flex Fields structure in Oracle fusion. Chart of accounts is uses to create the Accounting Flex fields structure in oracle fusion. Chart of Accounts is the combination of many Segments in oracle and we attach the Value sets with these Chart of Accounts segments in oracle fusion. Here below I am sharing the Chart of accounts table list in oracle fusion.

6 Important Chart of accounts table in oracle fusion

1.FND_ID_FLEX_SEGMENTS

2.FND_ID_FLEX_SEGMENTS_TL

3.FND_ID_FLEX_STRUCTURES_VL 

4.GL_COA_MAPPINGS

5.GL_COA_MAP_ACCOUNT_RULES

6.GL_COA_MAP_SEGMENT_RULES

Detail SQL Query Using Chart of accounts table in oracle fusion

select
 b.FORM_LEFT_PROMPT "Chart Of Account Segment Name",
 b.description,
 a.segment_name "CCA_VALUSET",
 c.ID_FLEX_STRUCTURE_NAME "Chart Of Account Structure Name" ,
 b.application_column_name "Internal Segment"
 from
 apps.FND_ID_FLEX_SEGMENTS a,
 apps.FND_ID_FLEX_SEGMENTS_TL b,
 apps.FND_ID_FLEX_STRUCTURES_VL c
 where
 b.language = 'US'
and c.ID_FLEX_NUM = b.ID_FLEX_NUM
 and c.enabled_flag = 'Y'
and b.application_id = a.application_id
 and b.id_flex_num = a.id_flex_num
 and b.application_column_name = a.application_column_name
 and a.application_id = 101