COA (Chart of Accounts)

COA (Chart of Accounts):

COA Structure will contain the Segments , Flex Field Qualifier and Value Sets.

Define COA:

Nav: GL Super User--Setup--Financials--Flex Field -- Key-- Segments

Press F11

Enter the Application =General% Ledger%

Flex field Title=Account%

Press CTRL F11

you can see all existing Accounting flex field structures. instead of creating existing accounting flex field structure you can create your own Accounting Flex field structure.

Place cursor on any one of the accounting structure and click on the New + Button. It will allow entering one record.

Enter the Account structure Name “XYZ Accounting Structure”

Click on Segments and define segments which are required for Business.

Note : Total segments are available in oracle is 30 . minimum segments we will use is 2. those are Company and Account.

Define Value sets for all Segments as per the requirement.

And Define Flex Field qualifiers as below

Click On Flex Field Qualifier Button and Select Balancing segment as a Qualifier.

Balancing Segment : This Flex Field Qualifier is used for Company Segment. where balance has been maintained.

For Department Segment  Select Cost Center Segment 

Cost Center Segment generally we used for Fixed Assets and Project Modules , for these modules it is mandatory to select.

For Account Segment  Select Natural Account Segment.with this system will understand this is account segment based on that category will be displayed at account values level.

The other segments related flex fields qualifiers will assign based on requirement.

Save and Come to below screens and Enable "Freeze Flex Field Definition"  and "Allow Dynamic Inserts" (when ever you want update Accounting Flex field structure we have to Disable and we have to to modification) click on Compile Button.

Add your values to the Value sets you defined for your Segments.

Especially For Account segment you have to choose Segment Qualifiers Like Below

Above Information will stores under below tables.

FND_ID_FLEXS

FND_ID_FLEX_STRUCTURES_VL

FND_ID_FLEX_SEGMENTS_VL

FND_SEGMENT_ATTRIBUTE_VALUES

FND_FLEX_VALUE_SETS

FND_FLEX_VALUE_SET_VALUES

Notes: Balancing Segment Flex Field Qualifier is Mandatory.

Flex field Qualifier:

Flex filed qualifier identifies segment in a flex field.

There are 6 types of Flex filed qualifiers.

1. Cost Center Segment: This attribute is used to identify the cost center segment.
2. Natural Account Segment: This attribute is used to identify the natural account segment.
3. Balancing Segment: This attribute is used to identify the balancing segment. This is typically the company segment.
4. Inter company Segment: This attribute is used to identify the inter company segment
5. Management Segment: This attribute is used to identify the management segment.
6. Secondary Tracking Segment: This attribute is used to identify the secondary tracking segment to process income statement closing, translation and revaluation.

Can a flex field qualifier be changed after it has been created?

No.

Once a segment qualifier has been designated for a specific segment and has been saved, it will permanently have the attributes with that qualifier.

For example, you accidentally designate the cost center segment as the natural account segment. Even though you do not compile this, the system saves the changes. And once it has been saved, it will have all the attributes designated for the natural account qualifier, even after it has been changed back, re saved with the correct qualifier and compiled. This is the inherent functionality of the software.Unfortunately, there is no real easy solution for this issue. The only option is to create a new chart of accounts and attach a new set of books.

Segment Qualifier:

Identifies value in a segment

1. Allow Budgeting 
2. Allow Posting
3. Account Type
4. Third Party Control Account 
5. Reconcile  

Account Types are :