R12: AP: Employee ID Missing in AP_SUPPLIERS Table
(Doc ID 1071779.1)
Last updated on APRIL 27, 2023
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.
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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Goal |
Solution |
Cause Details |
Solution |
References |