Technology Stack - EBS (MOSC)

MOSC Banner

Error when attaching value set to Extra information type in HR

edited Aug 20, 2021 11:34AM in Technology Stack - EBS (MOSC) 1 commentAnswered ✓

Hi,

We created a new value set with a special validation rule containing the following Validate event, containing the following code:

FND PLSQL "declare

l_value varchar2( 20 ) := :!value ;

l_valid NUMBER := 0 ;

BEGIN

select INSTR(l_value ,'@')

into l_valid

from dual;

IF (l_valid=0) THEN

fnd_message.raise_error ;

END IF ;

END;

"

When attached to the flexfield and save the record we receive the fllowing error:

Error message is : APP-FND-00952: The flexfield on this field contains a value set ([]) that uses special or pair user-exit validation. This prohibits operation in the mode that optimizes performance over a wide area network.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center