Missing Vendor Information from Item Vendor Relationships after Upgrading to 12.2.4

(Doc ID 1962534.1)

Last updated on SEPTEMBER 06, 2016

Applies to:

Oracle Complex Maintenance, Repair & Overhaul - Version 12.2.4 and later
Information in this document applies to any platform.

Symptoms

After upgrading to R12.2.4 .. noticed that Vendors were not being displayed when searching for vendors.  Further observed from the backend, it appeared that the object AHL_VENDOR_CERTIFICATIONS_V does not return any results.  This view joins AHL_VENDOR_CERTIFICATIONS on the vendor_site_id to PO_VENDOR_SITES_ALL and after upgrade, the AHL_VENDOR_CERTIFICATIONS (on the vendor_site_id) has null value.


STEPS
1. CMRO -> Administration -> Vendor Sourcing: Vendors:
2. Search for a known valid vendor that had been setup previously.... .no (vendor) details returned.


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