.

.

.

-- Navigate to the structure lines and click on the ‘New’ button on the tool bar.

-- Enter the ‘Code’, ‘Title’ and ‘Description’ for your accounting structure.

The controls on this form are discussed in explanation for fig 6, 7 and 8.

-- Check the Cross-Validate Segments checkbox and the Allow Dynamic Inserts checkbox.

Fig 4

-- Click on the ‘Segments’ button. Enter the segments that you intend to be in your account structure. E.g. Company_id, Department_id etc.

-- Enter the (Serial) Number, (Segment) Name, Window prompt, Column (this is the column in the table GL.GL_CODE_COMBINATIONS to which this segment is mapped) and Value Set (for validation).

-- Also select the Displayed and Enabled check boxes for these segments. The form may look like this:

Fig 5

-- Navigate to each segment and for each segment, click the Flexfield qualifiers button.

-- The flexfield qualifiers window displays 4 qualifiers that can be attached to the segment. Click any one of the segment qualifiers and to attach it to the selected segment, check the enabled check box. Of these Oracle GL requires the following 3 segments identified:

• Balancing Segment: This attribute is used to identify the balancing segment. Normally, the company segment is selected as the balancing segment. This means that for a company, oracle applications will try to make the debits and credits equal.
  .
  
• Cost Center Segment: This is only used in the Oracle Assets module.
  .
  
• The Natural Account Segment qualifier specifies which segment contains the account type for an account combination. (Account types can be Assets, Liability, Expense, Revenue, or Ownership/Stockholder’s Equity.)
  

Apart for these the 4th segment is:

• Intercompany Segment: This segment is used while passing intercompany entries.

See the figure below:

Fig 6

-- Once you have specified the Flexfield qualifiers for each of the segments, close the Flexfield qualifiers and the segment summary windows.

-- Selecting the ‘Enabled’ check box enables the flexfield on the form.

-- Selecting the ‘Cross-Validate Segments’ check box enables the cross validation rules to be applied to this flexfield.

-- Selecting the ‘Allow Dynamic Inserts’ check box eliminates the need to enter the valid account combinations before using them. The effect is that you don’t have to use the ‘GL Accounts’ form (see *1 at the end).

-- On the Key Flexfield Segments window, check the ‘Freeze Flexfield Definition’ check box. A message will appear warning that you must be done with making changes to your flexfield definition before freezing. Click OK. Selecting this check box makes the flexfield definition non updateable (unless you uncheck it again).

Next Page: Oracle Apps 11i: Setting up Chart Of Accounts (COA) - Page 3