“APPS SSO LOCAL LOGIN” type was changed to LOCAL at SITE Level using the below script,
Likewise any other system profile can be modified using this apps.fnd_profile package.
And to get the list of all the profile option names you can select from fnd_profiles table.
set serveroutput on
Declare
Result Boolean;
BEGIN
Result:= fnd_profile.SAVE ('APPS_SSO_LOCAL_LOGIN', 'LOCAL', 'SITE');
IF Result
THEN
DBMS_OUTPUT.put_line ('Profile Updated');
ELSE
DBMS_OUTPUT.put_line ('Profile Not Updated');
END IF;
COMMIT;
END;
/
