My Oracle Support Banner

QP Bulk Import Erroring UPDATE Action For Invalid 'orig_sys_line_ref' (Doc ID 2402951.1)

Last updated on MAY 24, 2018

Applies to:

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

Symptoms


For mass price list updates, we are using the QP Bulk Import Program.
For every price list line update, we insert the QP interface tables for first updating the existing lines with an end-date 'X'
and then creating a new line for the new changes with end-date X+1.

In this problem case, QP Bulk Import program is rejecting the UPDATE action
with the error code 'Cannot perform update, as record with orig_sys_line_ref 698995 does not exist'.
We pass the existing list line ID of the line being updated as the orig_sys_line_ref and 698995 is a valid list line ID.
This same approach is working for other price lists and got this error message for the 1st time for this price list only.




ERROR
Cannot perform update, as record with orig_sys_line_ref 698995 does not exist


STEPS
The issue can be reproduced at will with the following steps:
1. Populate the QP interface tables
2. Run QP: Bulk Import of Price List

Changes

 

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!


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