QPXVBLK: Bulk Import Of Price List Is Very Slow
(Doc ID 552002.1)
Last updated on SEPTEMBER 05, 2019
Applies to:Oracle Advanced Pricing - Version 188.8.131.52 to 184.108.40.206 [Release 11.5]
Information in this document applies to any platform.
EXECUTABLE:QPXVBLK - Pricelist Bulk Loader
On 220.127.116.11 in Production:
Find QPXVBLK is very very slow: it took more than 5 hours to load 1 header with 100,000 lines.
Since we have about 24 price lists to load, 120 hours are needed.
Expect the Bulk Load Price Lists performs faster.
-- Steps To Reproduce:
The issue can be reproduced at will with the following steps:
1. Load the QP Price LIst Header and Line Interface tables.
2. Run the QPXVBLK program and it takes 5 hrs to complete.
-- Business Impact:
The issue has the following business impact:
Due to this issue, users cannot load all the 24 price list in the short window available for this
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