How To Recreate Missing WHO Triggers For Oracle Human Resources Tables ? (Doc ID 1447822.1)

Last updated on JUNE 21, 2023

Applies to:

Goal

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>

Solution

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