Price List Bulk Loader Example Scripts

Please apply Patch#4900462 and find the following example scripts under QP_TOP/patch/11.5/sql directory.

QPBLKEX1.sql – Script populates interface tables to insert price list header and price list line.

QPBLKEX2.sql – Script populates interface tables to insert price list header and price list line and pricing attributes.

QPBLKEX3.sql – Script populates interface tables to insert price list header and price break line.

QPBLKEX4.sql – Script populates interface tables to update price list header with qualifiers.

QPBLKEX5.sql – Script populates interface tables to attach secondary price lists to the primary price list.

Advertisements

One thought on “Price List Bulk Loader Example Scripts

  1. Hi,

    I am working with Oracle Advanced Pricing,
    I don’t know, link between Price list and Qualifiers , I need to attach the qualifiers to the Price list .
    can you Please send me the sample script for this.
    Please Help me .

    Thanks & Regards
    Baji Babu Aluri

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s