My requirement is to assign HR : Query Only mode profile to a user programmatically. I am using JAVA as programming language. Here are some details based on my investigation-
1. Information about the profiles is stored in the FND_PROFILE_OPTIONS table
and the association of a profile with a user is stored in the
2. The FND_PROFILE package contains function("Save") for assigning a profile
to a user.
3. The "Save" function does not seem to work for profile
"PER_QUERY_ONLY_MODE" i.e the Query Only mode profile.
Save function however, works fine for profiles like ENABLE_SECURITY_GROUPS and few others. I am still unable to figure out why is the behaviour this way?
When the "HR : Query Only Mode" Profile is added from the UI, an entry
appears in the FND_PROFILE_OPTION_VALUES table. But the Save function of the FND_PROFILE package does not allow to add this entry!
Please help. Here is the code that is being used for the purpose-
FND_GLOBAL.APPS_INITIALIZE(0, 20420, 1);
//Initialize the flobal parameters : set the environment
b := FND_PROFILE.SAVE('per_query_only_mode', 'Y' , 'USER',1008682);
//Save profile inf
if b = TRUE then
dbms_output.put_line('some error occured');