Showing posts with label QP. Show all posts
Showing posts with label QP. Show all posts

Wednesday, January 12, 2022

Pricing Data Bulk Loader in Oracle APPS

The pricing data bulk loader imports data from the following interface tables:

  • QP_INTERFACE_LIST_HEADERS
  • QP_INTERFACE_LIST_LINES
  • QP_INTERFACE_QUALIFIERS 
  • QP_INTERFACE_PRICING_ATTRIBS 
  • QP_INTERFACE_ERRORS
QP_INTERFACE_LIST_HEADERS: This table captures the Price List header data.
QP_INTERFACE_LIST_LINES: Price list line data is captured in this interface table.
QP_INTERFACE_QUALIFIERS: This table contains the header qualifiers associated with the price lists to be imported. 
QP_INTERFACE_PRICING_ATTRIBS: The product and pricing attributes data is captured in this table. 

APEX$TASK_PK

  APEX$TASK_PK is a substitution string holding the primary key value of the system of records