QP Qualifier Group Upload  Help

QP Qualifier Group Upload creates and updates reusable qualifier groups in Oracle Advanced Pricing from Excel – the named group and its member qualifiers – and can delete individual member qualifiers. A qualifier group is a reusable set of eligibility conditions that can be attached to price lists and modifiers.

When to use it

• Create new reusable qualifier groups in bulk instead of one at a time in the Pricing setup form.
• Add member qualifiers to existing groups to extend eligibility conditions.
• Mass-update qualifier values, precedence, operators or effectivity dates on existing groups.
• Maintain qualifier-group or qualifier descriptive flexfield attributes in bulk.
• Remove specific qualifier lines from groups without deleting the group.
• Migrate qualifier groups between environments.

Before you start

• Blitz Report is installed and you are signed in to a responsibility that can maintain pricing qualifier groups.
• Oracle Advanced Pricing is installed and set up.
• The qualifier contexts and attributes used are already defined/enabled, and any table-validated values exist.

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

In Blitz Report, open QP Qualifier Group Upload, choose an Upload Mode (Create, Update – the default – downloads existing groups to edit; Create gives an empty template), and optionally set the Qualifier Group and Qualifier Effective Date filters. Run the upload to download and open the Excel file. Each group and qualifier is automatically handled as a create or an update depending on whether it already exists.

Step 2 – Enter the qualifier groups

Use the same Rule Name on multiple rows to put several qualifiers in one group. On each row supply one qualifier: the Qualifier Grouping Number, Qualifier Context, Qualifier Attribute, Qualifier Operator and Qualifier Value From (and Value To for the BETWEEN operator).

Step 3 – Delete qualifiers (optional)

Set Delete Qualifier to Yes to remove that one qualifier line. The group itself is never deleted by this flag.

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 each group and qualifier. When it finishes, a result report opens showing each row as success or error.

What’s produced

• Created and updated qualifier groups with their member qualifiers; deleted qualifier lines where flagged.
• A result report listing every row with a status (success or error) and a message.

Common questions

Does this delete a whole qualifier group?
No – Delete Qualifier = Yes removes only the individual qualifier line, never the group itself.

How do I put several qualifiers in one group?
Use the same Rule Name on multiple rows; each row supplies one qualifier with its own grouping number, context, attribute, operator and value.

What’s the difference between Grouping Number and Precedence?
Grouping Number bundles qualifiers that must all hold together (and separates alternative sets); Precedence is the evaluation precedence of the attribute (defaults from the attribute if left blank on create).

When do I fill Qualifier Value To?
Only with the BETWEEN operator – it’s rejected for any other operator.

It says the qualifier “is not unique” – why?
The group already contains more than one qualifier with the same grouping number, context, attribute and operator, so the upload can’t decide which to update. Make the key unique or supply the value description.

Troubleshooting