Import Price Catalogs is Not Updating Expiration Date and Effective Date on Quotation When the Price is Updated
Last updated on JUNE 07, 2017
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.
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