My Oracle Support Banner

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.

Symptoms


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


ERROR
-----------------------
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



Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.