Configure the General Ledger Segments for Reporting in OTBI

Before you generate the Auxiliary Report for Mexico, you need to configure and enable the general ledger segments for reporting in OTBI.

Perform the following tasks to configure and enable general ledger segments for reporting:

1. Enable the chart of accounts segments for BI reporting.

2. Map the accounting segments with the corresponding BI Object Name.

3. Deploy flexfields.

4. Run the Import Oracle Fusion Data Extensions for Transactional Business Intelligence process.

Note: Ensure that you configured the chart of accounts. For details about how to configure the chart of accounts, see How You Configure Chart of Accounts for Mexico Report topic.

Enable the Chart of Accounts Segments

You must enable your accounting segments for OTBI reporting before using them. Perform the following steps to use the accounting segments in OTBI:

1. Navigate to Setup and Maintenance work area.

2. Select an implementation project.

3. In the Task Lists and Tasks section, select Financials > Define Common Applications Configurations for Financials > Define Common Reference Objects for Financials > Manage Key Flexfields .

   The Manage Key Flexfields page appears.

4. Enter GL# in the Key Flexfield Code field and click Search.

5. Click Manage Structure Instances.

   The Manage Key Flexfield Structure Instances page appears.

6. Use the search fields to search for your key flexfield structure instances.

7. Select your key flexfield structure instances from the Search Results.

8. Click the Actions menu and then click Edit.

   The Edit Key Flexfield Structure Instance page appears.

9. Select the segment instance that you want to use in OTBI from the Segment Instances table.

10. Click the Actions menu and then click Edit.

    The Edit Key Flexfield Segment Instance dialog box appears.

11. Select the BI enabled check box and click the OK\ button.

12. Click Save.

13. Repeat the steps for all the segment instances that you want to use in OTBI.

Map the Accounting Segments and BI Object Name

Populate the BI Object Name for each of the Segment Labels that want to use in OTBI for reporting and analysis. The BI metadata has ten predefined BI Objects for the different GL segments. These BI Objects are used as dimensions in OTBI for the selected GL segments.

Perform the following steps to map the different chart of account segments to the predefined BI objects:

1. Navigate to Setup and Maintenance work area.

2. Select an implementation project.

3. In the Task Lists and Tasks section, select Financials > Define Common Applications Configurations for Financials > Define Common Reference Objects for Financials > Manage Key Flexfields .

   The Manage Key Flexfields page appears.

4. Enter GL# in the Key Flexfield Code field and click Search.

5. Click the Actions menu and then click the Manage Segment Labels option.

   The Manage Segment Labels page appears.

6. Update the BI Object Name for all the segment labels that are required. For the following three segment label codes, specify the BI Object name as specified in the table. Do not modify the BI object name; use the BI object name as mentioned in the following table.

   Segment Label Code	BI Object Name
   FA_COST_CTR	Dim - Cost Center
   GL_BALANCING	Dim - Balancing Segment
   GL_ACCOUNT	Dim - Natural Account Segment

7. For the other non-qualified segment labels that you want to use in OTBI, use any BI object names from Dim - GL Segment1 to Dim - GL Segment10.

   For the Auxiliary report for Mexico, map the segment label MX_SUBACCOUNT to Dim - GL Segment9.

Deploy Flexfields

Perform the following steps to deploy the flexfields:

1. Navigate to Setup and Maintenance work area.

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

   • Offering: Financials

   • Functional Area: Financial Reporting Structures

   • Task: Manage Chart of Accounts Structure

3. On the Manage Chart of Accounts Structure page, enter GL# in the Key Flexfield Code field and click Search.

4. Click Deploy Flexfield.

   The GL#: Processing dialog box appears indicating the deployment progress.

5. Click the OK button after the deployment completes.

Run the Import Oracle Fusion Data Extensions for Transactional Business Intelligence Process

Perform the following steps to run the Import Oracle Fusion Data Extensions for Transactional Business Intelligence process:

1. Navigate to the Scheduled Processes work area.

2. Click the Schedule New Process button.

   The Schedule New Process dialog box appears.

3. Click Name.

4. Click Search.

   The Search and Select dialog box appears.

5. Enter Import Oracle Fusion Data Extensions for Transactional Business Intelligence in the Name field.

6. Click Search.

7. Select the process name from the Search Results area and click the OK button.

8. Click the OK button on the Schedule New Process dialog box.

   The Process Details dialog box appears.

9. Update the details and click the Submit button.

10. Note the Process ID and click OK to acknowledge that your process was submitted.

11. Note the status of your process:

    • If the status of the process is Succeeded, the process executed successfully. Proceed and generate the Auxiliary Report for Mexico.

    • If the status of the process is failed, check the log file, make corrections, and submit the process again.