Oracle Apps 11i Free Training : Setting up Chart Of Accounts (COA)

In this tutorial you will learn how to create a Chart Of Accounts (COA), create a new value set, General Ledger - List Types, Security Types, Format Types, Validation Types, Oracle GL Segments and Create the Accounting Flexfield Structure.

Setting up Chart Of Accounts

Document Summary

This document is a step-by-step guide to understanding and setting up Chart of Accounts and Accounting Flex Fields in Oracle Applications.

To setup General Ledger for your organization, step through the following points:

Creating a Chart Of Accounts (COA)

A Chart Of Accounts defines what segments each account for the organization consists of. The COA consists of things like defining the accounting structure (the accounting structure is a framework or model that you will use to maintain your accounts), Account code combinations etc.

The steps involved in setting up the COA are:

1.1. Create a new Value Set.

Value Sets act as validations for the values entered by users. When the users enter the values in any of the fields (on any form), if there is a value set attached to this field, the values entered by user are validated against the value set. To create a new value set:

Log on to General Ledger – Vision Operations (USA)/GL Team Lead responsibility.

-- Navigate to N> Setup> Financials> Flexfields> Validation> Sets.

-- In the ‘Value Sets’ window, enter the new value set name and a description for the value set.

-- In the ‘List Type’ drop down box, select the kind of list you require based on the following criteria:

• Use ‘List of Values’ when the expected number of values is between 10 and 200. If you choose ‘List of Values’ then your value set will not provide the LongList feature in Oracle Forms applications and users will not see a poplist in Oracle Self-Service applications.
  .
• Use ‘Long List of Values’ when the expected number of values is more than 200. The LongList feature requires a user to enter a partial segment value before the list of values retrieves all available values. If you choose ‘Long List of Values’ then your value set will provide the LongList feature in Oracle Forms applications and users will not see a poplist in Oracle Self-Service applications. You may not enable LongList for a value set that has a validation type of ‘None’.
  .
• Use ‘Poplist’ when the expected number of values is fewer than 10. If you choose ‘Poplist’ then your value set will not provide the LongList feature in Oracle Forms applications but users will see a poplist in Oracle Self-Service applications.

-- In the ‘Security Type’ drop down box, select the security you want Oracle Applications to use with this value set. The possible security types are:

• No Security - All security is disabled for this value set.
  .
• Hierarchical Security - Hierarchical security is enabled. With hierarchical security, the features of value security and value hierarchies are combined. With this feature any security rule that applies to a parent value also applies to its child values. Within a hierarchical tree of values, a value is subject to a security rule if any parent above it is subject to that security rule.
  .
• Non-Hierarchical Security - Security is enabled, but the rules of hierarchical security do not apply. That is, a security rule that applies to a parent value does not "cascade down" to its child values.

* The parent values and child values in a particular Key flexfield are defined in the ‘Segment Values’ window, discussed later in this document.

-- Enter the ‘Format Type’, ‘Maximum Size’ and ‘Precision’ for your value set.

-- You can also specify the ‘Min Value’ and the ‘Max Value’ that this value set permits.

-- The first 2 check boxes on the screen define which values (‘Numbers only’, ‘Uppercase only’) the value set permits. Whereas if the third check box is checked, the values that are entered in the fields will be Right justified and zero filled automatically.

-- The ‘Validation Type’ can be any one of the following:

• None: You use a None type value set when you want to allow users to enter any value so long as that value meets the value set formatting rules. Because a None value set is not validated, a segment that uses this value set does not provide a list of values for your users. A segment that uses this value set (that is, a non-validated segment) cannot use flexfield value security rules to restrict the values a user can enter.
  .
• Independent: This value set provides a pre-defined list for valid values. These values are entered using the ‘Segment Values’ window (Fig 10).
  .
• Dependent: A dependent value set is similar to an independent value set, except that the available values in the list and the meaning of a given value depend on which independent value was selected in a prior segment of the flexfield structure. You can think of a dependent value set as a collection of little value sets, with one little set for each independent value in the corresponding independent value set. You must define your independent value set before you define the dependent value set that depends on it. You enter the values for dependent values in the Segment Values window (fig 10). E.g. you have selected an independent value set ‘vs1’ for segment1 and a value set ‘vs2’ that is dependent (on ‘vs1’) for segment2. Let us assume that vs1 has two valid values: ‘Computer’ and ‘Furniture’. Then vs2 will have two sets of valid values pertaining to each value in vs1, i.e. if ‘Computer’ is entered for the segment1 then there may be a set of valid values for segment2, say, ‘mouse’, ‘keyboard’ etc. If ‘Furniture’ is entered for segment1, then there may be a set of valid values for segment2, say, ‘table’, ‘chair’ etc.
  .
• Special and Pair: Special and pair value sets provide a mechanism to allow a "flexfield-within-a-flexfield". These value sets are primarily used for Standard Request Submission parameters. You do not generally use these value sets for normal flexfield segments. Special and Pair value sets use special validation routines you define. For example, you can define validation routines to provide another flexfield as a value set for a single segment or to provide a range flexfield as a value set for a pair of segments.

Fig 2: Value sets window.

1.2. Create the Accounting Flexfield Structure.

The accounting flexfield structure defines all the segments that makeup any account in the organization. In any organization, the accounts typically consist of codes like company_id, department_id, asset_number etc.

E.g. a typical account may have the first 2 digits representing the company, next 3 digits representing the department, next 4 digits representing the location and the last 4 digits representing the asset number.

(A typical account may look like 01.111.0011.0001)

Each of these segments are defined in the accounting flexfield structure. Follow below steps to create an accounting flex field structure:

-- Logon to N> Setup > Financials > Flexfields > Key > Segments

-- Query for the Flexfield Title ‘Accounting Flexfield’. This should give a screen that looks like below:

Fig 3 Key flexfields segments window