PERWSHRG | APP-DT-34605: Oracle Error ORA-0904 Occurred Writing to PER_ALL_PEOPLE_F | FRM-40735 On-Insert Trigger ORA-00932 (Doc ID 2253568.1)

Last updated on APRIL 10, 2017

Applies to:

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

Symptoms

Post upgrade to EBS or new HR RUP getting errors when using People > Enter and Maintain (PERWSHRG) form.

We have recompiled the form via adadmin (regenerated all forms and plls) as well as recompiled all flexfields, checked triggers. No errors are seen when compiling the files.

 

When entering a new employee:

FRM-40735 ON-INSERT trigger raised unhandled exception ORA-00932

When updating an existing employee using the date track option, "Update":

APP-DT-34605: Oracle error ORA-0904 occurred writing to PER_ALL_PEOPLE_F attempt to copy a row in the table.

 Upon performing an event trace we see the following:

ORA-00932: inconsistent datatypes: expected - got -

ORA-00904: "REHIRE_AUTHORIZOR#1": invalid identifier

per_people11_pkg.insert_row1 45
HRG: ON-ROLLBACK 10
Inside event procedure
Parameters passed are
form_name : PERWSHRG
event_name : WHEN-NEW-ITEM-INSTANCE

*** 2017-02-27 09:59:37.072
Inside event procedure
Parameters passed are
form_name : PERWSHRG
event_name : SPECIAL4



Steps to Reproduce:
The issue can be reproduced at will with the following steps:
Responsibility: XX HRMS Manager
1. Navigate: People Enter and Maintain
2. Enter a new person or update an existing person
3. Click Save

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