QP Modifier Copy Upload copies Oracle Advanced Pricing modifier lists from Excel, one row per modifier list, as the Copy Modifier List window (Modifiers > Copy) does. A row copies a modifier list with its qualifiers and lines to a new modifier list and can end-date the source list, so preparing next year’s discounts, promotions, surcharges and freight charges across many modifier lists becomes one upload.

When to use it

  • Prepare next year’s modifier lists: copy each list to a new list that starts on a later date.
  • End-date the old modifier lists the day before the new ones start.
  • Copy a modifier list to another operating unit, or to a global list.
  • End-date modifier lists without copying them.

Before you start

  • Access to Blitz Report from a responsibility with the Copy window of Modifiers in Advanced Pricing.
  • The numbers of the new modifier lists must not exist yet in the version of the source list.
  • A modifier list can be end-dated when your pricing security allows you to update it.

Choose a template

The default template is Default.

TemplateUse it for
DefaultCopy modifier lists and end-date the source modifier lists.
End Date OnlyEnd-date modifier lists without copying them. It downloads the selected modifier lists and shows only their own columns.

Step 1 – Set the parameters

Open QP Modifier Copy Upload in Blitz Report, choose the template and set the parameters. The modifier lists offered are the discount lists, deals, freight and special charge lists, promotions and surcharge lists you can view.

ParameterMeaning
Upload ModeCreate (the default) opens an empty sheet to paste modifier lists into. Create, Update downloads the modifier lists selected by the other parameters.
List TypeOne or more list types. The list number parameters then offer only modifier lists of these types.
List NumberOne or more modifier list numbers. Tick Multiple Values to enter several, separated by semicolons.
List Number LikeA number pattern, for example SUMMER%.
List Number From / List Number ToThe modifier lists whose numbers are from List Number From to List Number To, compared as text.
Effective DateThe modifier lists effective on this date.

In the example, Upload Mode is Create, Update, List Type is Discount List and the list numbers are Gold List #1 and Silver List #1.

Blitz Report run window for QP Modifier Copy Upload with Upload Mode, List Type and List Number set

Step 2 – Run to download the Excel file

Click Run. The Excel file opens with one row per modifier list and the Blitz Report tab. List Type, List Version, List Name, List Currency and the effective dates show the modifier list; New Global List and New Operating Unit default from it. List Number is required (yellow), and the columns describing the modifier list are read-only (grey), except List Effective To.

Excel file of QP Modifier Copy Upload with one row per modifier list

Step 3 – Enter the changes

Fill in what each modifier list should get. The add-in marks each changed row Update and each new row Create.

  • Copy: enter a New Modifier Number and a New Modifier Name to copy the row’s modifier list with its qualifiers and its lines that have not ended. The copy keeps the list type and version of its source. New Effective From and New Effective To set the new list’s dates, and New Global List or New Operating Unit its scope. Retain Effective Dates keeps the effective dates of the copied lines.
  • End-date: enter List Effective To to end-date the source modifier list, for example the day before the new list starts. This works for a modifier list without an end date.
  • Versions: a list number can exist in several versions. List Version then selects the modifier list, and a row without it is rejected.
  • New rows: type or paste a list number in List Number on an empty row; the other source columns fill in from it, List Version when the number has a single version.

In the example, Gold List #1 and Silver List #1 are copied to Gold List 2027 and Silver List 2027, starting 1-Jan-2027, and both source lists end on 31-Dec-2026.

New modifier numbers, names, start dates and List Effective To entered in the Excel file

Step 4 – Validate and Save

Click Validate and Save on the Blitz Report tab. It checks for missing required values and values that are not in their lists, marks the rows Valid and saves the file. Correct any rows it flags before uploading.

Rows marked Valid after Validate and Save

Step 5 – Upload

Click Upload on the Blitz Report tab. The add-in sends the valid rows to Oracle and submits the upload request, and a progress window shows it running. Each row first copies the modifier list, then end-dates the source modifier list.

Upload button on the Blitz Report tab and the upload progress window

Step 6 – Review the result

When the request completes, the add-in writes the result to the sheet: every row with its status and a message saying what was done, for example Modifier list Gold List 2027 created. List Effective To updated.

Upload result with Success status and messages for both modifier lists

What’s produced

  • New modifier lists with the number, name, dates and scope you entered, the type, version and qualifiers of the source list, and its lines that have not ended, with their pricing attributes.
  • Source modifier lists end-dated on the List Effective To you entered.
  • The result in the Excel file: every row with a status (success or error) and a message.

Common questions

Which modifier lists can be copied?
Discount lists, deals, freight and special charge lists, promotions and surcharge lists. A copy keeps the list type of its source.

Are the qualifiers copied?
Yes. The qualifiers of the list and of its lines are copied as they are.

Can I change or remove the end date of a modifier list?
No. List Effective To only end-dates a modifier list that has no end date. A blank List Effective To leaves the modifier list unchanged, so rows pasted without it never reactivate a list. Change an existing end date in the Modifier Setup window.

What if a row fails after the modifier list was copied?
The copy is saved as soon as it runs. If end-dating the source fails afterwards, the new modifier list stays and the message says so: end-date the source in a separate row instead of uploading the row again.

Troubleshooting

MessageCauseWhat to do
Please enter the Name of the modifier list to copy from.No modifier list of the copied list types has this List Number, or none with the List Version entered.Correct List Number or List Version.
Modifier list … exists in several versions. Enter the List Version to copy or end-date.The list number exists in more than one version and List Version is blank.Enter the List Version.
Please enter the name of a new Modifier list to copy to.New Modifier Name, the new dates or Retain Effective Dates are entered without a New Modifier Number.Enter the New Modifier Number, or clear the copy columns.
Missing values for required field/s: New Modifier NameA New Modifier Number is entered without a name.Enter the New Modifier Name.
You cannot copy to a Modifier list that already exists. …A modifier list with the New Modifier Number exists in the version of the source list.Enter a unique number.
Missing values for required field/s: New Operating UnitNew Global List is blank and no New Operating Unit is entered.Set New Global List to Yes, or enter the operating unit.
Start Date must start before End Date.New Effective From is after New Effective To, or List Effective To is before the start date of the source modifier list.Correct the dates.
The source modifier list already ends on …, so its List Effective To cannot be changed.The source modifier list already has an end date.Clear List Effective To or leave the downloaded date, and change the end date in the Modifier Setup window.
You do not have privileges to update this Modifier List.Your pricing security does not allow you to update the source modifier list.Ask for update access to the list, or leave List Effective To blank.