Who Triggers Missing from Some HRMS Tables (Doc ID 299740.1)

Last updated on JANUARY 13, 2017

Applies to:

Oracle Human Resources - Version 11.5.9 and later
Information in this document applies to any platform.
***Checked for relevance on 28-MAR-2013***


Symptoms

"WHO" triggers missing from various tables which results in "WHO" columns (created_by, creation_date, last_updated_by, last_update_date, creation_date) not getting updated or populated during Data Manipulation Language (DML).

BEN_BENEFIT_CLASSIFICATIONS
BEN_BENEFIT_CONTRIBUTIONS_F
BEN_OPT_F
BEN_OIPL_F
BEN_PRTT_ENRT_RSLT_F
BEN_PRTT_RT_VAL
HR_ALL_ORGANIZATION_UNITS
HR_LOCATIONS_ALL
PAY_ACCRUAL_PLANS
PAY_COST_ALLOCATIONS_F
PAY_ELEMENT_ENTRIES_F
PAY_ELEMENT_LINKS_F
PAY_ELEMENT_TYPES_F
PAY_GRADE_RULES_F
PAY_JOB_WC_CODE_USAGES
PAY_PEOPLE_GROUPS
PAY_PERSONAL_PAYMENT_METHODS_F
PAY_US_EMP_CITY_TAX_RULES_F
PAY_US_EMP_FED_TAX_RULES_F
PAY_US_EMP_STATE_TAX_RULES_F
PER_ADDRESSES
PER_ALL_ASSIGNMENTS_F
PER_ALL_PEOPLE_F
PER_ANALYSIS_CRITERIA
PER_ASS_STATUS_TYPE_AMENDS
PER_ASSIGNMENT_STATUS_TYPES
PER_CONTACT_RELATIONSHIPS
PER_JOBS
PER_PAY_PROPOSALS
PER_PERIODS_OF_SERVICE
PER_PERSON_ANALYSES
PER_PERSON_TYPES
PER_PHONES
PER_TIME_PERIOD_TYPES

Cause

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