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
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!