Price List Query Is Not Showing Previously Added Items on Price List Lines (Doc ID 1666268.1)

Last updated on FEBRUARY 02, 2022

Applies to:

Symptoms

On : 12.1.3 version, Price List

ACTUAL BEHAVIOR
---------------
Find that when one queries a price list that price list lines are not shown.

EXPECTED BEHAVIOR
-----------------------
Price List lines to be returned by the query


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Responsibility: Oracle Pricing Manager
2. Navigate to: Price List > Price List Setup
3. Query a price list
Note that the price list has 20+ items defined which are not being retrieved.

WHAT DOES WORK
-------------------------

1. Navigate to Price List form
2. Stretch & expand the form manually
3. Query for required price list
4. Open the price list
Note that the same price list now shows items previously defined.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot query price list lines.

Changes

 Recently applied <patch 18249133>:R12.QP.B.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.