Missing Vendor Information from Item Vendor Relationships after Upgrading to 12.2.4
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.
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.
1. CMRO -> Administration -> Vendor Sourcing: Vendors:
2. Search for a known valid vendor that had been setup previously.... .no (vendor) details returned.
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