1. Implementing Applications
  2. Configure Chart of Account Segments for Business Intelligence

Configure Chart of Account Segments for Business Intelligence

To map the Oracle General Ledger accounting flexfield in the Oracle Transactional Business Intelligence Repository (RPD file) for Oracle Financials, populate values in the Manage Key Flexfields user interface.

These values enable the chart of accounts segments for Oracle Transactional Business Intelligence. The values also provide the mapping with Business Intelligence object names that are used as dimensions for each of the chart of accounts segments.

Follow these steps to select the BI enabled option for all chart of account segments that you intend to map in the RPD file.

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

    • Offering: Financials

    • Functional Area: Financial Reporting Structures

    • Task: Manage Chart of Accounts Structures

  2. Enter GL# in the Key Flexfield Code field.

  3. Click Search.

  4. Click Manage Structure Instances.

  5. Click Search.

  6. Click the specific chart of accounts and click the Edit icon.

  7. Click the specific segment and click the Edit icon.

  8. Select the BI enabled option.

  9. Click Save. This should be done for all segments in every chart of accounts structure instance that you intend to be mapped in the RPD.

  10. Click Save and Close.

  11. Click Done.

Follow these steps to specify a BI object name for each segment label. This name is the logical table name in the RPD that's used as the dimension for the corresponding segment.

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

    • Offering: Financials

    • Functional Area: Financial Reporting Structures

    • Task: Manage Chart of Accounts Structures

  2. Enter GL# in the Key Flexfield Code field.

  3. Click Search.

  4. Select the Actions menu and click Manage Segment Labels.

  5. Populate the BI Object Name field for all of the segment labels that must be mapped in the RPD file. Complete the fields, as shown in this table.

    Segment Label Code

    BI Object Name

    FA_COST_CTR

    Dim - Cost Center

    GL_BALANCING

    Dim - Balancing Segment

    GL_ACCOUNT

    Dim - Natural Account Segment

  6. Click Save.

Note: For all the nonqualified segment labels, populate the BI Object Name with one of the following values:

  • Dim - GL Segment1

  • Dim - GL Segment2

  • Dim - GL Segment3

  • Dim - GL Segment4

  • Dim - GL Segment5

  • Dim - GL Segment6

  • Dim - GL Segment7

  • Dim - GL Segment8

  • Dim - GL Segment9

  • Dim - GL Segment10

Deploy the flexfield using the Deploy Flexfield button on the Manage Key Flexfields page.

Related Topics