This program updates employee type supplier records if the corresponding employee record has been changed.
Employee information is entered in the People window by your Human Resources department if Oracle HRMS is installed at your site, and in the Enter Person window when you don't have HRMS installed. You can link a Payables supplier record to an employee record in the Suppliers window. For detailed information on this topic see: Employee Information.
When employee records are updated, the system does not automatically update the corresponding supplier record. For example, if your Human Resources department updates an employee's address, the employee's supplier record does not change.
When you submit the Employee Update Program, the system identifies any employee records that have changed since the last time you submitted the program. If any employee records have been updated, then the Employee Update Program updates only the Supplier name:
Supplier Name (updated from Employee Name)
The following two information are not updated automatically:
Home and Office supplier site addresses (updated from employee home address and office location)
Inactive Date field for supplier, and for Home and Office supplier sites (updated if an employment termination date has been entered)
If the program updates any records, it produces a report that lists each employee supplier record that was updated by the program. It lists the previous value and the new, updated value. The report is sorted by supplier name.
Suggestion: Note that although Expense Report Export updates Home and Office employee supplier addresses, the address could change between import and payment time. We suggest that you set up the Employee Update program to run nightly so payments to employees will have up-to-date name and address information.
Prerequisite
Employee records are entered in either the People window or the Enter Person window, and the supplier records are linked to the employee records.
Newly changed employee names must not match the names of existing unrelated suppliers. If the newly changed employee name is identical to an existing supplier name, then Payables will list it as an exception on the report because you cannot have duplicate supplier names. You can make the employee name unique by using a middle name or initial.
You submit this program from the Submit Request window. See: Submitting Standard Reports, Programs, and Listings.
This program has no parameters.
Supplier Name: The name of the supplier. If the program updated the supplier name, then the report shows the new supplier name.
Updated Value: The type of value that was updated by the program. Possible values are:
Name: The employee name was updated, and the program updated the supplier name.
Home Address: The employee home address was updated, and the program updated the Home supplier site address.
Office Address: The employee was assigned a different location or the address for the location changed, and the program updated the Office supplier site address.
Inactive Date: The employee was assigned an employment termination date, and the program updated the Inactive On value for the supplier.
Updated From: The value that existed before the program updated it, for example, the old address.
Updated To: The value that was updated during the program. For example, the new address.