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

Symptoms

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



EXPECTED BEHAVIOR
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
upgrade.

Cause

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
Symptoms
Cause
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.