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 laterInformation in this document applies to any platform.
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:
- Login using an HRMS responsibility
- Navigate to Special Information
- Enter three requests
- Login using Self-Service
- Navigate to Special Information
- Enter a fourth request
- Get the validation error message
- Retry to enter a fourth request
- Able to submit the request without error
Solution
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
Goal |
Solution |
References |