R12: AP: Employee ID Missing in AP_SUPPLIERS Table
Last updated on APRIL 20, 2017
Applies to:Oracle Payables - Version 12.0.0 to 12.1.3 [Release 12.0 to 12.1]
Information in this document applies to any platform.
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"
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