My Oracle Support Banner

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

Last updated on JUNE 16, 2022

Applies to:

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


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:

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

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.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

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