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.
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:
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 ?
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