Wednesday, May 26, 2010
QPXVBLK: QP: BULK IMPORT OF PRICE LIST in Oracle Apps R12
Report Description:
Bulk Import of Price List concurrent program imports price list information from interface tables. This will be very useful when you need to create/update the price list data. You can control the number of records to be processed by setting up the profile option QP: Batch size for Bulk upload.
Report Parameters:
Entity
Entity name
Process ID
Process Type
Process Parent
No. Of Threads
Turn Debug On
Enable Duplicate Line Check
Insert Script: Here
Queries Related: Here
Mandatory Columns
QP_ITERFACE_LIST_HEADERS
Column | Description |
ORIG_SYS_HEADER_REF | Unique identification of the price list in the external application from where the price list is imported |
LIST_TYPE_CODE | PRL for standard price list |
NAME | Price List Name |
DESCRIPTION | Currency Code. The currency of the price list |
CURRENCY_ | |
ACTIVE_FLAG | |
CURRENCY_HEADER_ID | Currency Header Id. Identifies Multi-Currency List associated with a Price List. Alternatively, populate CURRENCY_HEADER column with Multi-Currency List Name |
START_DATE_ACTIVE | |
END_DATE_ACTIVE | |
ROUNDING_FACTOR | |
SOURCE_LANG | |
LANGUAGE | |
INTERFACE_ACTION_CODE | Interface Action Code. The possible values are INSERT/UPDATE/DELETE |
PROCESS_FLAG | |
PROCESS_STATUS_FLAG |
QP_INTERFACE_LIST_LINES
ORIG_SYS_LINE_REF |
ORIG_SYS_HEADER_REF |
LIST_LINE_TYPE_CODE |
START_DATE_ACTIVE |
END_DATE_ACTIVE |
ARITHMETIC_OPERATOR |
OPERAND |
PRIMARY_UOM_FLAG |
PRODUCT_PRECEDENCE |
INTERFACE_ACTION_CODE |
PROCESS_FLAG |
PROCESS_STATUS_FLAG |
QP_INTERFACE_PRICING_ATTRIBS
ORIG_SYS_PRICING_ATTR_REF |
ORIG_SYS_LINE_REF |
ORIG_SYS_HEADER_REF |
EXCLUDER_FLAG |
PRODUCT_ATTRIBUTE_CONTEXT |
PRODUCT_ATTR_CODE |
PRODUCT_ATTR_VAL_DISP |
PRICING_ATTRIBUTE_CONTEXT |
PRICING_ATTR_CODE |
PRICING_ATTR_VALUE_FROM_DISP |
PRICING_ATTR_VALUE_TO_DISP |
COMPARISON_OPERATOR_CODE |
PROCESS_FLAG |
INTERFACE_ACTION_CODE |
PRODUCT_UOM_CODE |
PROCESS_STATUS_FLAG |
Do you think this Article is useful?
Subscribe to:
Post Comments (Atom)
0 Responses to “QPXVBLK: QP: BULK IMPORT OF PRICE LIST in Oracle Apps R12”
Post a Comment