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.