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:

Goal

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

Solution

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