Shared HR Position form with Organization FRM-40735: WHEN-VALIDATE-RECORD Trigger Raised Unhandled Exception ORA-01403
Last updated on MARCH 21, 2017
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
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 hundreds of Community platforms