Create a Chart of Accounts Structure and Instance

In Oracle General Ledger, the chart of accounts model is framed around the concept of a chart of accounts structure, for which one or more chart of accounts structure instances can be created.

A chart of accounts structure defines the key attributes for your chart of accounts. These attributes include the number of segments, the segment sequences, the segment names, segment prompts, segment labels, for example natural account and primary balancing, and default value sets.

The chart of accounts instance is exposed in user interfaces and processes. By default, a chart of accounts instance inherits all of the attributes of the chart of accounts structure, meaning that all instances of the same structure share a common shape and have the same segments in the same order. However, at the chart of accounts instance level, you can override the default value set assignments for your segments and assign a unique account hierarchy that determines the parent and child relationships between the value set values. At the chart of accounts instance level, you can determine whether to generate new account combinations dynamically instead of creating them manually.

Chart of Accounts Structure

You are creating a chart of accounts structure as you set up a chart of accounts for your enterprise, InFusion America, Inc. Follow these steps:

  1. In the Setup and Maintenance work area, go to the following:

    • Offering: Financials

    • Functional Area: Financial Reporting Structures

    • Task: Manage Chart of Accounts Structures

  2. Select the General Ledger module and click Search.

  3. Click Manage Structures.

  4. On the Manage Key Flexfield Structures page, select the General Ledger row and click the Create icon.

  5. On the Create Key Flexfield Structure page, enter the unique structure code INFUSION_AM_COA_STRUCTURE and name InFusion America COA Structure. Provide an optional description of InFusion America Inc. chart of accounts structure.

  6. Select a delimiter to visually separate the segment values.

  7. Click Save.

  8. To create a segment, click the Create icon to open the Create Key Flexfield Segment page.

    1. Complete the fields, as shown in this table.

      Field

      Value

      Segment Code

      INFUSION_AM_CO

      Name

      InFusion America Company

      Description

      InFusion America Inc.

      Sequence Number

      1

      Prompt

      Company

      Short Prompt

      CO

      Display Width

      2

      Column Name

      Segment1

      Default Value Set Code

      INFUSION_AM_COMPANY

    2. Select a segment label, Primary Balancing Segment, to indicate its purpose within your chart of accounts.

      Note: Two segment labels are required: primary balancing segment and natural account segment. These labels aren't used with each other or with other labels in a specific segment.
    3. Click Save and Close.

    4. Click Done.

    5. Define additional segments following the same steps.

Chart of Account Instance

You are creating a chart of accounts instance as you set up your chart of accounts for your enterprise, InFusion America, Inc. Follow these steps:

  1. In the Setup and Maintenance work area, go to the following:

    • Offering: Financials

    • Functional Area: Financial Reporting Structures

    • Task: Manage Chart of Accounts Structure Instances

  2. On the Manage Chart of Accounts Structure Instances page, select the General Ledger module and click Search.

  3. Select the General Ledger row and click Manage Structure Instances.

  4. On the Manage Key Flexfield Structure Instances page, click the Create icon.

  5. On the Create Key Flexfield Structure Instance page, enter the unique structure instance code INFUSION_AM_COA_INSTANCE and name InFusion America COA Instance. Provide an optional description, InFusion America Inc. chart of accounts structure instance.

  6. Select the Dynamic combination creation allowed option to indicate that you want to dynamically generate account combinations.

  7. Associate your instance with the structure InFusion America Structure.

    Note: By default, an instance inherits the key attributes of the associated structure. Some attributes, such as the value set assigned to each the segment, can be modified.
  8. Click Save.

  9. To modify an instance segment, select the segment row and click Edit.

  10. Select the Required, Displayed, and BI enabled options.

    Note: Select the Required and Displayed options for all segments including those intended for future use. The recommended best practice is to define one segment for future use and set a default value. This ensures room for expansion in your chart of accounts and that the extra segment is populated in account combinations. Select the BI enabled option to use key flexfield segments in Oracle Fusion Transactional Business Intelligence. The business intelligence option is only valid when enabled on segments with segment labels. The second step is to populate the BI Object Name field for each of the segment labels on the Manage Segment Label page, which you open from the Manage Key Flexfields page.
  11. Click OK.

  12. Click Save and Close.

  13. Define additional instances following the same process.

    Note: Alternatively, proceed directly with creating your value set values by selecting the corresponding Value Set Code in the Segment Instances table.
  14. Click Done.

  15. Click Deploy Flexfield.

  16. Click OK.