Offer Code Quick Search Is Not Returning Any Offers
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.
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms