My Oracle Support Banner

SSHR:How to avoid that FND_FLEX_PLSQL.VALIDATE() is not triggered when the same data is re-entered in a SIT? (Doc ID 2023950.1)

Last updated on MARCH 15, 2024

Applies to:

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


FND_FLEX_PLSQL.VALIDATE() function ONLY gets called if the combination is not found as an existing combination in the code combinations table.  
When one is trying to add a record that is the same as an existing record, then the apps do not, and WILL NOT, call the extra FND_FLEX_PLSQL.VALIDATE function.
This behavior is also described in the following note: Dependencies in KFF (SIT) (Doc ID 295208.1)

Steps to Reproduce:
The issue can be reproduced at will with the following steps:

  1.  Login using an HRMS responsibility
  2.  Navigate to Special Information
  3.  Enter three requests
  4. Login using Self-Service
  5. Navigate to Special Information
  6. Enter a fourth request
  7. Get the validation error message
  8. Retry to enter a fourth request
  9. Able to submit the request without 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.