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

Last updated on OCTOBER 12, 2017

Applies to:

Oracle Human Resources - Version 11.5.10.2 and later
Information in this document applies to any platform.

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

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