Loading

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

0 Responses to “QPXVBLK: QP: BULK IMPORT OF PRICE LIST in Oracle Apps R12”

Post a Comment

Disclaimer

The ideas, thoughts and concepts expressed here are my own. They, in no way reflect those of my employer or any other organization/client that I am associated. The articles presented doesn't imply to any particular organization or client and are meant only for knowledge Sharing purpose. The articles can't be reproduced or copied without the Owner's knowledge or permission.