Siebel Customer-Centric Enterprise Warehouse Installation and Configuration Guide > Configuring Siebel Financial Analytics > Process of Configuring Siebel Financial Analytics for Oracle 11i >

Extracting Data Posted at the Detail-Level for Oracle 11i

This task is a step in the Process of Configuring Siebel Financial Analytics for Oracle 11i.

By default, the Siebel Customer-Centric Enterprise Warehouse assumes that the posting from your journal to your Oracle General Ledger is done at the summary level, and that references are maintained in Oracle General Ledger for AP and AR subledgers. If import references are not maintained in Oracle General Ledger and the posting from AP and AR is at the detail-level, then modify the filter condition in M_I_GL_XACTS_JOURNALS_EXTRACT and disable the S_M_I_XACTS_IMP_GLRF_EXTRACT session so that only the session S_M_I_GL_XACTS_JOURNALS_EXTRACT loads into the common table TI_STAGE_GLRF_DERV.

To modify the filter condition for posting at the detail level

1. In the PowerCenter Designer, open the Configuration for Oracle Applications v11i folder.
2. Open the M_I_GL_XACTS_JOURNALS_EXTRACT mapping.
3. Select the FIL_GL_XACTS_JOURNAL filter, and click the Properties tab to edit the filter condition.

   To load postings at the detail level, replace the 1=2 condition with 1=1.

4. Validate and save your changes to the repository.

To disable the session for Siebel General Ledger Analytics extract

1. In PowerCenter Workflow Manager, open the Configuration for Oracle Applications v11i folder.
2. Expand the Oracle 11i Strategic Sourcing Application workflow.
3. Expand the O_FACTS_EXTRACT worklet and the O_Facts_Extract_Finance_Common_AP_AR_GL worklet
4. Double-click the S_M_I_XACTS_IMP_GLRF_EXTRACT session to open the Edit Tasks window.
5. Click Disable this task, and click OK.
6. Repeat Step 2 to Step 5 for the Oracle 11i Siebel Enterprise Sales Analytics application and the Oracle 11i Finance application workflows.

NOTE:  As a best practice, you must move unused sessions to another folder to avoid error messages and preserve it for future use.