Shared HR Position form with Organization FRM-40735: WHEN-VALIDATE-RECORD Trigger Raised Unhandled Exception ORA-01403

(Doc ID 2245672.1)

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