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

Sample 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

Enter a valid business unit.(AP-810247) Oracle Fusion AP Invoice Spreadsheet upload issue

Issue has been fixed, After Excel's Macros Setting has not been enabled "Enable all macros". Due to this Business Unit field value on line 1 is not copied to Business Unit field value on line2 automatically

 

Also Follow below steps to update Business Unit in Spreadsheet.

• Re-open Excel and Select Business Unit field value on line 1.
• Changed the header identifier on line 2 to "1"
• Business Unit field value on line 1 is copied to Business Unit field value on line2 automatically and we can enter Distribution Combinations value without error.