Error When Updating Price Lists with Bulk Loader (duplicte ORIG_SYS_HEADER_REF)

(Doc ID 1644273.1)

Last updated on MAY 19, 2017

Applies to:

Oracle Advanced Pricing - Version 11.5.10.2 to 12.1.3 [Release 11.5 to 12.1]
Information in this document applies to any platform.

Symptoms

When attempting to update price lists using QP: Bulk Import of Price List,
the following error occurs.

ERROR
-----------------------
"57687608/PRL/QP_INTERFACE_LIST_LINES/75976/13079236 One or more lines are
duplicates of each other. Please change the effectivity dates or the product
or the pricing attributes to make these lines unique."

The issues happens every time that a Price List is copied, the field ORIG_SYS_HEADER_REF is being duplicated to all new price lists. This causes problems when trying to execute the "Bulk Loader" program.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Responsibility: Order Management Super User
View -> Request -> Submit a new request -> QP: Bulk Import of 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