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

Last updated on JUNE 13, 2017

Applies to:

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

Symptoms

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.

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