QP Modifier Upload  Help

QP Modifier Upload creates and updates Oracle Advanced Pricing modifier lists and their modifier lines from Excel – discounts, surcharges, price breaks, promotions and freight charges – together with each line’s qualifiers, pricing attributes, buy/get products, excluders and limits. Child records can also be deleted.

When to use it

• Mass-create new discount, surcharge, freight-charge or promotion modifier lists and lines.
• Bulk-update existing modifier line values, effective dates, application methods or attributes.
• Add or change qualifiers (who the modifier applies to) across many lists/lines at once.
• Add or maintain price breaks, buy/get products, pricing attributes, excluders or benefit/usage limits.
• Roll out new pricing by automatically end-dating the matching active modifier while creating its replacement.
• Maintain only list-level header data, qualifiers and limits without touching lines.

Before you start

• Blitz Report is installed and you are signed in to a responsibility with the relevant operating-unit access.
• Oracle Advanced Pricing is installed and set up.
• The target modifier lists (for updates), and any referenced items, item categories, formulas, price lists, qualifier contexts, UOMs and currencies already exist.

Choose a template

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

In Blitz Report, open QP Modifier Upload, choose your template, and set the parameters:

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

Step 2 – Enter the modifiers

Each modifier line and its child records are entered across rows that repeat the same List Number, List Version and Line No. On the header enter the List Type, List Name and List Currency; on lines the Line Modifier Type, Application Method and Value; add qualifier, price-break, buy/get, pricing-attribute, excluder or limit columns as needed.

Step 3 – Delete child records (optional)

Set the matching Delete column (Delete Price Break, Delete Pricing Attribute, Delete Qualifier, Delete Buy Item, Delete Limit, etc.) to Yes to remove that child record. The line and header are not deleted by these flags.

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 modifier lists, lines and child records. When it finishes, a result report opens showing each row as success or error.

What’s produced

• Created and updated modifier lists and lines with their qualifiers, price breaks, buy/get products, pricing attributes, excluders and limits.
• A result report listing every row with a status (success or error) and a message.

Common questions

Does this load price lists?
No – it loads modifiers (modifier lists/lines and their children). Price lists are a separate upload.

How does it know whether to create or update?
It matches on List Number + List Version (header) and + Modifier Line No (line). Found = update; not found = create. Children are matched the same way.

How do I get system-assigned line numbers vs keep my own?
Set Modifier Numbering = Automatic to let Oracle generate numbers, or keep the Line No from the spreadsheet.

How do I delete just a price break / qualifier / limit without removing the line?
Set the corresponding Delete column to Yes; only that child record is deleted.

Why don’t my modifier lines appear in the download?
The Modifier Lines Template downloads lines but not list-level qualifiers/limits; the List Header Template does the opposite. Confirm Upload Mode = Create, Update and the relevant Download … parameters are Yes.

Troubleshooting