QP Price List Upload  Help

QP Price List Upload creates and updates Oracle Advanced Pricing standard price lists from Excel – the price-list header plus its lines (item or item-category list prices), price breaks, line pricing attributes, header qualifiers and secondary price list assignments – with selective deletion of individual sub-entities.

When to use it

• Load brand-new standard price lists with many item or item-category list prices in one pass.
• Mass-update prices on existing price lists.
• Add or maintain price breaks (quantity-based pricing tiers) across many lines.
• Attach header qualifiers in bulk, including copying a whole qualifier group onto a price list.
• Assign secondary price lists to many price lists at once.
• Replace prices effective a new date while auto-end-dating the superseded lines.

Before you start

• Blitz Report is installed and you are signed in to a responsibility with access to the price list’s operating unit.
• The inventory items (or item categories) exist before pricing them.
• Reference values used – currency, payment/freight terms, ship method, UOMs, qualifier groups, pricing attributes – exist and are valid.

Step 1 – Choose a mode, set the parameters and download

In Blitz Report, open QP Price List Upload, choose an Upload Mode (Create, Update – the default – downloads existing price-list data to edit; Create gives an empty template), and set the parameters:

Run the upload to download and open the Excel file. Each entity is automatically handled as a create or an update depending on whether it already exists.

Step 2 – Enter the price lists

One row can carry the header plus a line, a break, a pricing attribute, a qualifier and a secondary price list. On the header enter the Name, Currency and effective dates; on lines the Line Product Value (item), Line Product UOM and Line Value (the list price); add price-break columns for quantity tiers.

Step 3 – Delete sub-entities (optional)

Set the matching Delete column (Delete Line, Delete Price Break, Delete Pricing Attribute, Delete Qualifier, Delete Secondary Price List) to Yes to remove that sub-entity. The price list header itself is never deleted by this upload.

Step 4 – Validate and Save

Click Validate and Save. This checks for missing required values and runs the upload’s validation, then saves the file. Correct anything it flags before continuing.

Step 5 – Upload and view the result

Back in Blitz Report, click Upload and select your saved file. This submits the Blitz Upload request, which creates or updates the price list, lines and child records. When it finishes, a result report opens showing each row as success or error.

What’s produced

• Created and updated price lists with their lines, price breaks, pricing attributes, qualifiers and secondary price lists.
• A result report listing every row with a status (success or error) and a message.

Common questions

Does it create the price list header and the lines together?
Yes – one row can carry the header plus a line, break, pricing attribute, qualifier and secondary price list; the upload routes each part to the right operation.

Can I delete a whole price list with this upload?
No – it deletes only individual sub-entities via the Delete columns. The header itself is never deleted.

What is “Line No” for – does it go to Oracle?
No. It is only used by the upload to tell apart multiple lines that share the same product, UOM and start date but have different pricing attributes.

How does it know whether to create or update?
It looks each entity up; found = update, not found = create, unchanged = no operation.

How do I supersede prices on a date?
Set End Date Matching List Lines? = Yes; new lines end-date the matching active lines, and downloaded lines come down flagged as Create to use as a starting point.

Troubleshooting