This chapter covers the following topics:
Create Price list header and a Price list line by populating mandatory values in the following bulk loader interface tables.
QP_INTERFACE_LIST_HEADERS QP_INTERFACE_LIST_LINES QP_INTERFACE_PRICING_ATTRIBS
This flow uses single data for the creation of price list line.
Open Interface
Bulk_Import_OI
The following are the prerequisites for executing the flows:
Vision Operations Org
The following profile options must be set:
| Profile | Value |
|---|---|
| QP_PRICING_TRANSACTION_ENTITY | ORDFUL |
| QP_SOURCE_SYSTEM_CODE | QP |
| QP_ORGANIZATION_ID | 204 |
The following predefined data must be used:
| Entity | Field Name | Field Value |
|---|---|---|
| User | User Name | Operations |
| Responsibility | Responsibility | Oracle Pricing Manager |
The following data must be set up:
| Interface | Field Name | Field Value |
|---|---|---|
| QP_INTERFACE_LIST_HEADERS | ORIG_SYS_HEADER_REF | SAMPLE_HEADER |
| LIST_TYPE_CODE | PRL | |
| START_DATE_ACTIVE | #SYSDATE(0,yyyy/mm/dd) | |
| SOURCE_LANG | US | |
| NAME | Sample_BLK_PL | |
| DESCRIPTION | Sample Bulk Loaded Price List | |
| CURRENCY_CODE | USD | |
| ROUNDING_FACTOR | -2 | |
| ACTIVE_FLAG | Y | |
| LANGUAGE | US | |
| INTERFACE_ACTION_CODE | INSERT | |
| PROCESS_FLAG | Y | |
| PROCESS_STATUS_FLAG | P |
| Interface | Field Name | Field Value |
|---|---|---|
| QP_INTERFACE_LIST_LINES | LIST_LINE_TYPE_CODE | PLL |
| START_DATE_ACTIVE | #SYSDATE(0) | |
| PRIMARY_UOM_FLAG | Y | |
| ARITHMETIC_OPERATOR | UNIT_PRICE | |
| OPERAND | 150 | |
| INTERFACE_ACTION_CODE | INSERT | |
| PROCESS_FLAG | Y | |
| PROCESS_STATUS_FLAG | P | |
| PRODUCT_PRECEDENCE | 230 | |
| ORIG_SYS_LINE_REF | SAMPLE_LINE | |
| ORIG_SYS_HEADER_REF | ISAMPLE_HEADER |
| Interface | Field Name | Field Value |
|---|---|---|
| QP_INTERFACE_PRICING_ATTRIBS | PRODUCT_ATTRIBUTE_CONTEXT | ITEM |
| PRODUCT_UOM_CODE | Ea | |
| INTERFACE_ACTION_CODE | INSERT | |
| PROCESS_FLAG | Y | |
| PROCESS_STATUS_FLAG | P | |
| PRODUCT_ATTR_CODE | INVENTORY_ITEM_ID | |
| PRODUCT_ATTR_VAL_DISP | CM13139 | |
| ORIG_SYS_LINE_REF | SAMPLE_LINE | |
| ORIG_SYS_PRICING_ATTR_REF | SAMPLE_PATTR | |
| ORIG_SYS_HEADER_REF | SAMPLE_HEADER |
Following are the details of the scenarios in the flow:
| Scenario | Objective | Artifact Method | Component Set | Main Component |
|---|---|---|---|---|
| Bulk_Import | This scenario creates a Sales Price list with price list line | QP_Bulk_Import_of_Price_list_QPXVBLK | QP_Bulk_Import_of_Price_List_QPXVBLK | QP_Bulk_Import_of_Price_List_QPXVBLK |
| Verification | - | VERIFICATION_COMPONENT | ||
| Select_Price_List | - | SELECT |