My Oracle Support Banner

Denormalized Data Not Updated Automatically While Running QP: Bulk Import of Price List Program After Upgrading To 12.2.9 (Doc ID 2796402.1)

Last updated on JULY 01, 2022

Applies to:

Oracle Advanced Pricing - Version 12.2.9 and later
Information in this document applies to any platform.

Goal

Following behaviour was noticed for "QP: Bulk Import of Price List" after upgrading from 12.1.3 to 12.2.9

In 12.1.3 instance:
After the request "QP: Bulk Import of Price List" ran, the denormalized data were automatically updated without manually running request "QP: Maintains the denormalized data in QP Qualifiers".
The debug file of "QP: Bulk Import of Price List" shows at the end:

Completed Update Denormalized columns

The QUALIFICATION_IND is set to 4 after denormalized columns were updated.

In 12.2.9 instance
The denormalized data were NOT automatically updated after running request "QP: Bulk Import of Price List"
In this case the QUALIFICATION_IND is set NULL and the data are not available in UI.
To have the data displayed you have to manually run "QP: Maintains the denormalized data in QP Qualifiers" to update QUALIFICATION_IND.

Why in 12.1.3 the denormalized columns were automatically updated after request "QP: Bulk Import of Price List" ran?
Also, why the same is not happening in 12.2.9 ?


 

Solution

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
Goal
Solution
References


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