Oracle® Business Intelligence Applications Installation and Configuration Guide > Configuring Oracle Financial Analytics > Process of Configuring Oracle 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 Oracle Financial Analytics for Oracle 11i.

By default, the Oracle Business Analytics 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 SDE_ORA_GLJournals and disable the SDE_ORA_GLJournals_ImportReference_Extract session so that only the session S_SDE_ORA_GLJournals loads into the common table W_ORA_GLRF_DERV_F_TMP.

To modify the filter condition for posting at the detail level

  1. In the PowerCenter Designer, open the appropriate Oracle Applications 11i folder (for example, SDE_ORA11510_Adaptor). For more information, see About the Name of the Oracle 11i Folder in Informatica.
  2. Open the SDE_ORA_GLJournals 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 appropriate Oracle Applications 11i folder (for example, SDE_ORA11510_Adaptor). For more information, see About the Name of the Oracle 11i Folder in Informatica.
  2. Open the SDE_ORA_GLJournals_ImportReference_Extract workflow.
  3. Double-click the SDE_ORA_GLJournals_ImportReference_Extract session to open the Edit Tasks window.
  4. Click Disable this task, and click OK.

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

Oracle® Business Intelligence Applications Installation and Configuration Guide Copyright © 2007, Oracle. All rights reserved.