Oracle^® Business Intelligence Applications Installation and Configuration Guide > Configuring Oracle's Supply Chain Analytics family of products > Process of Configuring Supply Chain Analytics for Oracle 11i >

Configuring Quantity Types for Product Transactions

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

Oracle 11i categorize quantities into three different types:

• Goods Received quantities. Goods Received quantity refers to the number of goods received.
• Delivery quantities. Delivery quantity refers to the number of goods delivered.
• Base quantities. Base quantity refers to any transaction quantity.

The Oracle Business Analytics Warehouse extracts the transaction type and loads this value into the XACT_SRC_TYPE column. In this column, the value 1 denotes a Goods Received quantity, and 2 denotes a Delivery quantity.

All quantities extracted from the source system are always loaded into the Base quantity column (EXT_BASE_QTY). However, only the receipt quantity is loaded into the Goods Received quantity column (EXT_GR_QTY), and only delivered quantities are loaded into the Delivery quantity column (EXT_DELIVERY_QTY).

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.

To configure the Quantity type

1. In PowerCenter Designer, open the SDE_ORA115<Ver>_Adaptor.
2. Open the mplt_SA_ORA_ProductTransactionFact mapplet.
3. Double-click the Expression transformation to open the Edit Transformations dialog box, and click the Port tab to display the EXT_GR_QTY and EXT_DELIVERY_QTY port.
4. Edit the quantity types by substituting your desired condition for the prepackaged expression.
5. Click Apply.
6. Validate the mapplet, and save your changes to the repository.