Oracle® Business Intelligence Applications Installation and Configuration Guide > Checklist for Configuring Oracle Business Analytics Warehouse Applications > Checklist for Configuring Supply Chain Analytics >

Checklist for Configuring Supply Chain Analytics for Oracle 11i


This section contains the Supply Chain Analytics configuration points that are specific to Oracle11i.

The following section contains mandatory Supply Chain Analytics configuration points:

  • Deploying stored procedures. Compile the Compute_Bounds_Ora11i.sql stored procedure in the target data warehouse. For more information on deploying stored procedures, see Deploying Stored Procedures.
  • Configuring the Bill of Materials Explosion for Oracle 11.5.9 and above version. This configuration is required to if your Oracle 11i application is version 11.5.9 and above. It's used by the Informatica Server to extract data from the BOM_EXPLOSION_TEMP table. See Configuring the Bill of Materials Explosion Options.

The following section contains optional Supply Chain Analytics configuration points:

  • Configuring the Bill of Materials (BOM) explosion option. This configuration allows you to choose an explosion option to load a BOM structure into the W_BOM_ITEMS table. For more information on configuring the BOM explosion option, see Configuring the Bill of Materials Explosion Options.
  • Configuring the left bound and right bound calculation. This configuration allows you to turn on or off the calculation of the left bound and right bound in the W_BOM_ITEMS table. For more information on configuring the left bound and right bound calculation, see Configuring the Left Bound and Right Bound Calculation Option.
  • Configuring the Quantity types for product transactions. If your definition of goods received or delivery quantity is different from the prepackaged condition, then you can edit the condition to suit your business needs. For more information on configuring the Quantity type for product transactions, see Configuring Quantity Types for Product Transactions.
  • Configuring the Country and State Region Name. This configuration allows you to load specific Region Names into the W_CODE_D table. For more information on configuring the Region Name, see Configuring the Country Region and State Region Name.
  • Configuring the State Name. This configuration allows you to load specific State Names into the W_CODE_D table. For more information on configuring the State Name, see Configuring the State Name.
  • Configuring the Country Name. This configuration allows you to load specific Country Names into the W_CODE_D table. For more information on configuring the Country Name, see Configuring the Country Name.
  • Configuring the Make-Buy Indicator. Your organization may require different indicator codes. If so, you can modify the indicator logic by reconfiguring the condition in the MPLT_SAI_PRODUCTS mapplet. For more information on configuring the Make-Buy Indicator, see Configuring the Make-Buy Indicator.
  • Extracting particular purchase order records. By default, the filter condition is set to BLANKET or STANDARD. However, you can change this value to some conditional statement that only allows particular types of records to be extracted. For more information on extracting particular purchase order records, see Extracting Particular Purchase Order Records.
  • Configuring the DAC parameter for Purchase Cycle Line. To load the purchase cycle line table (W_PURCH_CYCLE_LINE_F), the ETL tasks needs to distinguish data coming from Oracle 11i applications from data from other applications such as PeopleSoft. See About Configuring the Purchase Cycle Lines Aggregate Table.
Oracle® Business Intelligence Applications Installation and Configuration Guide Copyright © 2007, Oracle. All rights reserved.