My Oracle Support Banner

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

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