Unable To Query Price List Lines After running Bulk Import of Price Lists

(Doc ID 2384505.1)

Last updated on APRIL 10, 2018

Applies to:

Oracle Advanced Pricing - Version 12.1.3 and later
Information in this document applies to any platform.
bulk loader
QPXVBLK

Goal

How can one populate the qualification index for the price list lines that were created through bulk import?

Unable to query newly added price list lines after applying these patches: <Patch 25023643>, <Patch 25806980>,
<Patch 25826716>, <Patch 26099068>, <Patch 26180309>, <Patch 26263790> and <Patch 26533427>.
The new lines were added via bulk import. Only difference between working instance and non-working instance is qp_list_lines.qualifaction_ind is null in broken instance.
 

Solution

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms