My Oracle Support Banner

Error When Updating Price Lists with Bulk Loader (duplicate ORIG_SYS_HEADER_REF) (Doc ID 1644273.1)

Last updated on MARCH 12, 2019

Applies to:

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


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


"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.


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


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.