My Oracle Support Banner

Offer Code Quick Search Is Not Returning Any Offers (Doc ID 1900459.1)

Last updated on AUGUST 27, 2020

Applies to:

Oracle Trade Management - Version 12.1.3 and later
Information in this document applies to any platform.


Offer Code quick search is not working in R12.1.1

Issue is with ams_offers synonym since it was pointing to ams_offers table. Updated this synonym to point to ozf_offers table (same is done by upgrade script ozftmsyn.sql).
DROP SYNONYM ams_offers;
CREATE SYNONYM ams_offers FOR ozf_offers;
Now, this view returns a number records for offers but still it’s not reflecting on the Offer Code search. You have bounced and cleared the cache.




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.