How To Recreate Missing WHO Triggers For Oracle Human Resources Tables ?
(Doc ID 1447822.1)
Last updated on JUNE 21, 2023
Applies to:Oracle Human Resources - Version 184.108.40.206 and later
Information in this document applies to any platform.
It has been found that after running one of the HRMS*.sql scripts that WHO triggers are missing for some or all of the Oracle Human Resources tables.
Section 'CHECK FOR STATUS OF WHO TRIGGERS for the following HR owned tables' within the HRMS*.sql script output file has been examined and not all of the listed tables are displaying output.
Is there a script or scripts which Oracle Human Resources provides which can be run to re-create the WHO triggers ?
To examine your Oracle Human Resources table data for missing WHO triggers please run the appropriate HRMS*.sql script for your environment and then search the output file for section
'CHECK FOR STATUS OF WHO TRIGGERS for the following HR owned tables'.
The HRMS11i.sql script for 11i customers can be found within <Note: 418274.1>
The HRMS120.sql script for R12.0+ customers can be found within <Note: 453632.1>
The HRMS121.sql script for R12.1+ customers can be found within <Note: 453632.1>
The HRMS122.sql script for R12.2+ customers can be found within <Note: 453632.1>
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