My Oracle Support Banner

Missing Vendor Information from Item Vendor Relationships after Upgrading to 12.2.4 (Doc ID 1962534.1)

Last updated on JANUARY 29, 2018

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

To view full details, 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 a vibrant support community of peers and Oracle experts.