How to End-date a Price List Line so One Can Create a New Price List Line With a New Price Via an API? (Doc ID 1060790.1)

Last updated on MARCH 11, 2023

Applies to:

Goal

Received the following error when trying to use a custom program to update a price list line:
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.

Need to end-date a price list line so one can create a new price list line with a new price.

Example:
Currently, XXX book has unit selling price of 10.
Four days from now, the new unit selling price will be 25.

Additional information needed to run API:
   item = XXX book 
   item_id = 164743 
   price list, list_line_id =  444444
   price list, list_header_id =  222222

Still Have Questions?
To discuss this information further with Oracle experts and industry peers, we encourage you to review, join or start a discussion in the My Oracle Advanced Pricing Community.

Solution

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