In this article we will look into how to bulk load profile option values into Fusion HCM.
With every new quarterly release 20A, 20B etc. Oracle releases set of Profile Options that needs to be enabled for Responsive UI. It will be a time consuming task to open each profile option code and set the value to Y/N.
In order to address this issue, we can prepare an input file with the list of all profile option values that we intend to load in a specific format and then use the import option to load them. If a value already exists, it will update. If an option value doesn’t exist, it will create a new one.
Let’s get started on how to do it.
Navigate to Setup and Maintenance > Manage Administrator Profile Values task.
For example we will take the RUI Profile Option Code – PER_MY_TEAM_RESPONSIVE_ENABLED and Read Only Profile Option Code – FND_READ_ONLY_MODE.
We can make a user having administrator access to read only access with a simple setting. Check out How to make a User Read Only using Administrator Profile Value?
PER_MY_TEAM_RESPONSIVE_ENABLED Current Value:
We can see that the Profile Option Value is set to Y at site level.
Let’s look at the profile option FND_READ_ONLY_MODE
We can see that there are no profile option values for this profile option.
Now, we will prepare a file to load profile option values into read only mode and change the value of profile value for PER_MY_TEAM_RESPONSIVE_ENABLED profile option.
This is the header for the file. All fields should be separated by pipe delimiter(|).
- ProfileOptionCode – This is the profile option code value for which we want to load the values.
- LevelName – This is the level at which we want to load the values. SITE or USER. There should be one more level for PRODUCT but it’s mostly not used.
- UserName – The exact username of the user. It is Case Sensitive.
- ProfileOptionValue – Y/N. For some options it is Yes/No and others it is Enabled/Disabled. Check in the application first and then fill in data in the input file.
The sample file for these profile options upload will look like:
ProfileOptionCode|LevelName|UserName|ProfileOptionValue PER_MY_TEAM_RESPONSIVE_ENABLED|SITE||N FND_READ_ONLY_MODE|USER|TEST.USER|Enabled
We are changing the profile option value for PER_MY_TEAM_RESPONSIVE_ENABLED to N at site level and making the TEST.USER as Read only using the FND_READ_ONLY_MODE option.
Save the file name as ProfileOptions_load.txt (Any name is fine).
Now Navigate to Tools > File Import and Export and upload this file to UCM.
Browse the input file and select the Account as hcm\dataloader\import and click Save and Close. The file will get uploaded to UCM.
We can also use SOAP services to upload the file to UCM
Now Navigate to Setup and Maintenance > Manage Administrator Profile Values task.
Under the Profile Option: Profile Values task, click on the Actions button and select Import
Once you select the import a popup appears to select the Account and Profile Options File name.
Select the Account as hcm\dataloader\import and provide the Profile Values File as “ProfileOptions_load.txt“.. We need to provide the exact file name that we have uploaded including the file extension. Click Upload.
It will process for some time and provides a success message and a link to download the log file. It’s important to download the log file and check the summary of the processed counts and error messages if any.
We can clearly see that 1 new record has been created and 1 has been updated. The Read only profile value has been created as this user did not have any row earlier and the RUI profile option has been updated.
In this way we can load any number of profile option values. This process is handy when you have to make lot of users Read-only or if there are many profile option values that need to set.
We can quickly verify the values in the profile options values using a SQL Query.
SELECT pfob.profile_option_name ,fpov.LEVEL_NAME ,fpov.LEVEL_VALUE ,fpov.profile_option_value, decode(fpov.LEVEL_NAME,'USER', (select username from per_users where user_guid = fpov.LEVEL_VALUE),' ') Username FROM fnd_profile_option_values fpov ,fnd_profile_options_b pfob WHERE fpov.profile_option_id = pfob.profile_option_id --and pfob.profile_option_name in ('List of Values') ORDER BY pfob.profile_option_name ,fpov.profile_option_value
Output will look like:
If you have any questions, please feel free to reach out to me by posting in comments section.
If you are interested in learning all Fusion Technical tools go through this article.
If you liked the article, please share it with your friends/ colleagues/ teammates or anyone who might also benefit from it.
Top 10 Popular Posts from our Knowledgebase
- DataFusing FREE Cloud based SQL Developer like tool for Oracle Cloud
- Core HR Entity Relationship Diagram (ERD) for HCM Cloud
- Most Frequently used Document IDs from Oracle Support
- FREE Oracle Training & Accreditation with Oracle Learning Explorer
- How HDL Transformation Formula works with ElementEntry Sample
- FREE Oracle Fusion Demo Instance (VISION) Access
- Top 10 FREE useful tools for Fusion Consultants
- Learning Fusion HCM Technical Skillset
- Sample HCM Data Loader (HDL) files for all Business Objects
- Most frequently used Tables list in Fusion HCM