PERWSHRG - Receiving FRM-40735 On-Update Unhandled Exception ORA-02292 (Doc ID 1451785.1)

Last updated on OCTOBER 12, 2021

Applies to:

Symptoms

On :  12.1.3 version, Person / Assignment Issues in Production

After the upgrade to 12.1.3, when attempting to cancel application, when selecting the update button,
the application toolbar displays an error:

ERROR
-----------------------
FRM-40735 ON-UPDATE Trigger unhandled exception ORA-02292.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1.  US HRMS Manager responsibility
2.  Open the Person/Assignment form (PERWSHRG).
   > Find an employee who is an Employee Applicant.
   > Change the Action to Cancel Application (The cancel application profile option must be set.)
   > Save the form
3.  A window with an UPDATE button appears; click on the Update button.
   The error displays at the bottom of the screen FRM-40735 ON-UPDATE Trigger unhandled exception ORA-02292.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.