QP Price List Copy and Adjust Upload – Oracle EBS SQL Report

Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.

Overview

Copies price lists and adjusts their prices, one row per price list, as the Copy Price List and Adjust Price List windows of Advanced Pricing do.

Upload Mode Create, Update downloads the selected price lists; Create gives an empty sheet to paste rows into.

Enter a New Price List to copy the row’s price list with its qualifiers and the lines active today. Adjust By and Adjust Value then change the prices of the new list, or of the row’s own list when no New Price List is entered.

Standard and agreement price lists can be copied, and the copy keeps the type of its source. A copied agreement price list gets no qualifiers and is not attached to an agreement. Prices can be adjusted on standard price lists only, as in the Adjust Price Lists window.

Change Effective To to end-date the row’s price list, for example the day before the new list starts. Only a price list without an end date can be end-dated: an existing end date cannot be changed or removed, and a blank Effective To leaves the price list unchanged.

Item From, Item To and Category limit both the copy and the adjustment; Adjust Item Status and Adjust Creation Date limit the adjustment only. With any of these filters only lines priced by item number are copied or adjusted; lines priced by item category or all items are left out.

The copy and the adjustment are saved as soon as they run. A row that fails afterwards keeps the new price list and its message says so: adjust the new list in a separate row instead of uploading the row again.

Run this report in Excel in seconds: download Blitz Report™ free (your first 30 reports are free) or try it in the online demo.

Report Parameters

Upload Mode, Price List, Price List like, Price List From, Price List To, Effective Date

Oracle EBS Tables Used

qp_secu_list_headers_vl, hr_operating_units, xxen_report_org_access

Report Categories

Enginatics, R12 only, Upload

QP Customer Pricing Engine Request, AR Customer Upload, ONT Order Upload, QP Price List Upload, QP GSA Pricing Upload, QP Modifier Upload, ONT Blanket Sales Agreements, ONT Orders and Lines, ONT Price Adjustments and Charges

Running This SQL Without Blitz Report

The SQL source can be run in any SQL client. Some Oracle EBS SQL reports in this library use functions from the utility package xxen_util – install it first. Blitz Report™ adds parameters, Excel output with pivots, scheduling and security on top.

Download & Import Options

Resource Link
Excel Example Output Example
Blitz Report™ XML Import QP_Price_List_Copy_and_Adjust_Upload.xml
SQL Source QP Price List Copy and Adjust Upload.sql
Full Report on Enginatics www.enginatics.com/reports/qp-price-list-copy-and-adjust-upload/

© Enginatics GmbH