My Oracle Support Banner

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

Last updated on APRIL 23, 2018

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.


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

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.