EBS Customizations (MOSC)

MOSC Banner

FND_PROFILE_OPTION_VALUE SET

Hi,

I'm trying to execute the below procedure, but I get wrong number or type of arguments.

DECLARE
l_user_id NUMBER := 489372;

BEGIN
FND_PROFILE.SAVE(
profileName => 'APPS_SSO_LOCAL_LOGIN',

profileValue => 'LOCAL',

levelName => 'USER',

levelValue => l_user_id,

levelValueAppId => NULL,
levelValue => NULL
);
COMMIT;

DBMS_OUTPUT.PUT_LINE('Profile option saved successfully.');

EXCEPTION
WHEN OTHERS THEN
DBMS_OUTPUT.PUT_LINE('Error saving profile option: ' || SQLERRM);
ROLLBACK; -- Important: Rollback on error

END;


I see the Procedure definition given in oracle document, <https://etrm.live/etrm-12.2.2/etrm.oracle.com/pls/trm1222/etrm_pnav73ba-8.html?c_name=FND_PROFILE&c_owner=APPS&c_type=PACKAGE&c_detail_type=source> I do same but still no luck.. Any suggestion would really help.

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