My Oracle Support Banner

Using Qpplxmp1.Sql for QP_PRICE_LIST_PUB.Process_Price_List Lines Are Not Populated in QP_PRICING_ATTRIBUTES (Doc ID 444975.1)

Last updated on AUGUST 10, 2018

Applies to:

Oracle Advanced Pricing - Version 11.5.10 to 11.5.10.2 [Release 11.5]
Information in this document applies to any platform.
QP_PRICE_LIST_PUB.Process_Price_List
QPXPPRLS.pls


Symptoms

-- Problem Statement:
On 11.5.10 in Production:
Find using QPPLXMP1.sql and trying to create price list with 3 price lines that it only creates
the header.
The lines will not display.
The records are present in qp_list_lines when reviewed via SQL.
The records are not present in qp_pricing_attributes when reviewed via SQL.
Tried running QP: Maintains the denormalized data in QP Qualifiers, but that did not help.

When the application is used to enter the price list lines, they are correctly displayed.

QPPLXMP1.sql is a samples script to use with QP_PRICE_LIST_PUB.Process_Price_List API.


EXPECTED BEHAVIOR
Expect header, lines and attributes to be displayed in the price list form after running this
script.

-- Steps To Reproduce:
1. Update QPPLXMP1.sql with price list name and inventory items
2. Run via sqlplus as username = apps.

-- Business Impact:
The issue has the following business impact:
Due to this issue, users cannot use QPPLXMP1.sql to import price lists.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.