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 JUNE 07, 2017

Applies to:

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

Symptoms

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.

Changes

 

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