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 >

Extracting Particular Purchase Order Records

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

This configuration also applies to the Spend functional area.

You may not want to extract particular types of records from purchase orders in your source system. In these cases, you can modify the filter condition in the Source Qualifier of the mapplet. By default, the filter condition is set to PLANNED, BLANKET, or STANDARD. However, you can change this value to some conditional statement that only allows particular types of records to be extracted.

To extract particular types of purchase order records

1. In PowerCenter Designer, open the SDE_ORA115<Ver>_Adaptor.
2. Open the MPLT_BC_ORA_PURCHASEORDERFACT mapplet.
3. Double-click the Source Qualifier to open the Edit Transformations box, and select the Properties tab to display the SQL Query.
4. Double-click the value in the SQL Query to open the SQL Editor box and edit the statement.
5. Replace the prepackaged filter condition with the new filter statement that reflects your business needs.
6. Edit the WHERE clause of the statement.
7. Click Apply to save the changes, and click OK to exit.
8. Validate the expression, and save your changes to the repository.
9. Repeat Step 2 to Step 8 for the MPLT_BC_ORA_PURCHASESCHEDULELINESFACT mapplet.