Not Able To See Error Message From " FND_FLEX_PLSQL.validate" FUNCTION In SIT Self Service Page.

(Doc ID 2006221.1)

Last updated on MAY 02, 2017

Applies to:

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


On : 12.2.3 version, EIT and SIT.

When the code FND_FLEX_PLSQL.validate function is used to throw a validation error while creating an SIT record, Only the page errors out, but no error message is displayed.

A validation has been written in the VALIDATE function (FND_FLEX_PLSQL) and the OUT parameter error_message has been assigned with an error message.
However, on validation failure, the error message is not displayed on the Self Service page.

It is expected that the error message assigned to the OUT parameter FND_FLEX_PLSQL.validate be displayed on the Self Service page.

The issue can be reproduced at will with the following steps:
1. Modify the code FND_FLEX_PLSQL.validate to return FALSE (boolean value) based on validation for an SIT structure and set an error message to OUT parameter error_message.
2. Create an SIT record such the validation in the code fails.
3. The SSHR page shows the error page as expected, however, no error message is shown.


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