My Oracle Support Banner

Import Price Catalogs is Not Updating Expiration Date and Effective Date on Quotation When the Price is Updated (Doc ID 261578.1)

Last updated on APRIL 19, 2023

Applies to:

Oracle Purchasing - Version 11.5.8 and later
Information in this document applies to any platform.


When trying to UPDATE fields QUANTIY and UNIT_PRICE on a Catalog Quotation using the PDOI, the interface is not updating the corresponding EXPIRATION_DATE and EFFECTIVE_DATE fields. Instead it is adding new Quotation Lines rather than updating the existing lines.

SQL queries show that new lines are being added to the quotations, rather than existing lines getting updated. User is attempting to also update EFFECTIVE_DATE and EXPIRATION_DATE while updating the price.


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.