Technology Stack - EBS (MOSC)

MOSC Banner

How to validate profile value against fnd_profile_options.sql_validation programmatically

edited Apr 22, 2020 9:06AM in Technology Stack - EBS (MOSC) 3 commentsAnswered ✓

Hello, we would know if it is posible to create a plsql function that before set a profile user value check if this value is valid against sql_validation in fnd_profile_options table

for example  how to use this text:

SQL="SELECT MEANING \"Log Enabled\", LOOKUP_CODE

into :visible_option_value,

:profile_option_value

from fnd_lookups

where lookup_type = 'YES_NO'"

COLUMN="\"Log Enabled\"(30)"

in plsql code to check if a value pass it, it was an example of the sql_validation field for a profile we would like to use in gral for any profile defined

thank you

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