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 |