QPXVBLK: Using QP: Bulk Import Of Price List To Update List Lines Examples and One Error Explained (Doc ID 399174.1)

Last updated on JULY 07, 2017

Applies to:

Oracle Advanced Pricing - Version 11.5.10 and later
Information in this document applies to any platform.
EXECUTABLE:QPXVBLK - Pricelist Bulk Loader


Symptoms

On 11.5.10.2 in Production:
When attempting to use QP Bulk Import of Price List,
to update the header and update list lines,
the following error occurs:

"UNEXPECTED ERROR IN QP_BULK_UTIL.UPDATE_LINE"
"UNEXPECTED ERROR IN PROCESS_LINE:User-Defined Exception"


ERROR
"UNEXPECTED ERROR IN QP_BULK_UTIL.UPDATE_LINE"
"UNEXPECTED ERROR IN PROCESS_LINE:User-Defined Exception"

STEPS
The issue can be reproduced at will with the following steps:
Run the concurrent request to import a Price list, 'QP: Bulk Import of Price
List'. The parent concurrent program completes successfully but the child concurrent program
errors out with:

BUSINESS IMPACT
The issue has the following business impact:
Due to this issue, customer cannot make necessary changes to price list


Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms