QP GSA Pricing Upload  Help

QP GSA Pricing Upload creates and updates GSA (government) pricing in Oracle Advanced Pricing from Excel: GSA lists, their price lines (item, unit of measure and GSA price) and the list qualifiers that control who receives the GSA price. Existing qualifiers can also be deleted. Download existing GSA lists to change prices and dates, or add new lists and lines.

When to use it

• Mass-load new GSA price lines (item and government price) into a GSA list.
• Bulk-update GSA prices, effective dates or units of measure on existing GSA list lines.
• Replace current GSA prices with new prices from a future date, with the current lines end dated automatically.
• Create a new GSA list together with its lines and qualifiers in one spreadsheet.
• Add, change or delete the qualifiers of a GSA list.

Before you start

• Access to the upload in Blitz Report, from a responsibility with update access to the GSA lists under pricing security.
• Run the upload from a responsibility where the profiles QP: Pricing Transaction Entity and QP: Source System Code resolve to the pricing transaction entity and source system of your GSA lists, usually Order Fulfillment and Oracle Pricing, for example an Order Management responsibility. The upload takes both from these profiles. Responsibilities of other applications, such as Inventory or Purchasing, often have other values set at application level, and a user-level value overrides them all; if the profiles do not match the GSA lists, or the source system is not valid for the pricing transaction entity, the download returns no rows.
• The items you price exist in the pricing item validation organization.

Step 1 – Set the parameters

Open QP GSA Pricing Upload in Blitz Report and set the parameters:

Only active GSA lists are downloaded.

Step 2 – Run to download the Excel file

Click Run. The Excel file downloads and opens with the list qualifiers and the list lines of each GSA list in separate rows, or an empty sheet in Create mode.

Step 3 – Enter or change the GSA pricing

Every row carries the list columns List Number, List Version, List Name, List Currency, Global List and, for a list that is not global, Operating Unit. A list is identified by its List Number and List Version. On a list line, change the Value (the GSA price), Line Product Uom, Line Effective From / Line Effective To or Line Allow Override. To add a line, enter a row with the list columns, a Line No, the item in Line Product Value, the Line Product Uom and the Value. New lines are created as automatic line-level lines with application method New Price. A new row for an item, unit of measure and start date that already exist on the list updates that line instead of creating a duplicate.

Qualifiers are entered at list level with Qualifier Grouping Number, Qualifier Context, Qualifier Attribute, Qualifier Operator and Qualifier Value From (and Qualifier Value To for a range). A qualifier can be entered on the same row as a list line. To remove a qualifier, set Delete Qualifier to Yes on its downloaded row.

In the example, the GSA price of item AS18947 is lowered to 1850 and a new line is added for item AS54888 at 1519.05.

Step 4 – Validate and Save

Click Validate and Save. This checks for missing required values and runs the upload’s list validation (for example the Operating Unit against Global List), then saves the file. Correct any rows it flags before uploading.

Step 5 – Upload the file

In Blitz Report click Upload and select the saved file. This submits the upload request, which creates or updates the GSA lists, lines and qualifiers through the Oracle Pricing modifier API.

Step 6 – Review the result report

When the request completes, a result report opens listing every uploaded row with its status and message. With Automatic numbering, a new line shows its system-generated Line No.

What’s produced

• GSA lists, list lines and list qualifiers created or updated, and qualifiers deleted.
• With End Date Matching Modifiers?, new GSA lines plus the end dated lines they replace.
• A result report listing every row with a status (success or error) and a message.

Common questions

How does the upload decide whether to create or update a line?
By List Number, List Version and Line No. If the line exists, it is updated, otherwise a new line is created. A new row whose item, unit of measure and start date match an existing line of the list updates that line.

Which column holds the GSA price?
Value. It is the new price of the item; the application method is always New Price.

How do I load a price change from a future date?
Set End Date Matching Modifiers? to Yes, download the list, enter the new Value and the new Line Effective From on the rows you want to change and delete the other rows. The upload creates the new lines and end dates the current lines on the day before. The new start date must be later than the start date of the current line.

Why does the download not show the GSA customer qualifier?
The GSA list’s standard qualifier Customer GSA = Yes is not downloaded, so only your own qualifiers appear.

Can I delete a GSA line or list?
No. Only qualifiers can be deleted. To stop a line, set its Line Effective To; to stop a list, set its List Effective To.

Why is my download empty?
Check that Upload Mode is Create, Update, that the list is active and has lines active on the Effective Date, and that your QP: Pricing Transaction Entity and QP: Source System Code profiles match the GSA lists.

Troubleshooting