R12: AP: Employee ID Missing in AP_SUPPLIERS Table (Doc ID 1071779.1)

Last updated on APRIL 27, 2023

Applies to:

Goal

Understand and fix the corruption that is caused when Employee-Supplier records that are missing an Employee_ID in the 11i PO_VENDORS table are upgraded. 

This corruption can lead to the following symptoms:

• Addresses for some upgraded employee-type suppliers do not show on their printed expense report checks.

• When attempting to inactivate an employee-type supplier, the following error message is returned: "Employee Info is invalid VENDOR_TYPE_LOOKUP_CODE and EMPLOYEE_ID do not match Supplier Type is inconsistent"
• When attempting to update an employee-type supplier, the following error message is returned: "This employee name is already assigned to another supplier. Re-enter"

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.