PERWSTEM: ORA-02292 and FRM-40735 Errors While Terminating an Employee Record

(Doc ID 2136352.1)

Last updated on OCTOBER 12, 2017

Applies to:

Oracle Payroll - Version 12.1.3 and later
Information in this document applies to any platform.


When attempting to terminate an employee record, the following error is received:

FRM-40735 ON-UPDATE trigger raised unhanded exception ORA-02292

Steps to Reproduce

The issue can be reproduced at will with the following steps:

1. Using an HRMS Responsibility

2. N: People > Enter and Maintain

3. Query the employee in question

4. Click on the Others button

5. Choose End employment

6. Enter relevant data

7. Receive the error


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