My Oracle Support Banner

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 to [Release 11.5]
Information in this document applies to any platform.
EXECUTABLE:QPXVBLK - Pricelist Bulk Loader


-- Problem Statement:
On 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

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