My Oracle Support Banner

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 15, 2024

Applies to:

Oracle Advanced Pricing - Version 11.5.9 and later
Information in this document applies to any platform.


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.

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.


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.