Shared HR Position form with Organization FRM-40735: WHEN-VALIDATE-RECORD Trigger Raised Unhandled Exception ORA-01403
(Doc ID 2245672.1)
Last updated on FEBRUARY 20, 2019
Applies to:Oracle Human Resources - Version 12.1.3 and later
Information in this document applies to any platform.
On 12.1.3 version of the Application, In the Position form of Shared HR Instance.
When attempting to do a Blind query of all the positions, with a security profile based on Restriction on Organizations and View ALL for Positions, the following error occurs.
'FRM-40735: WHEN-VALIDATE-RECORD Trigger raised unhandled exception ORA-01403'
The issue can be reproduced at will with the following steps:
1 . Login to 'PO Setup User' Responsibility, which is attached to a security profile, based on Restriction on Organizations and View ALL for Positions
2. Navigate to Setup --> Personnel --> Positions.
3. In the opened Position form, try to do a blind query of all the Positions and got the above mentioned 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!
In this Document