Download and Upload Area of Responsibility Data

If you use Oracle Fusion HCM Analytics, then you can manage the area of responsibility (AOR) data in the Oracle Autonomous Data Warehouse associated with the Oracle Fusion Data Intelligence instance for security setups.

You can use the AOR-related data in custom security setups and for mass assignment. You can download the latest AOR data security assignment files to make changes to the existing data and upload it back. This enables you to avoid using other methods to get the AOR data into Oracle Autonomous Data Warehouse.

The downloaded AOR data security assignment file supports only the prebuilt security contexts. For custom contexts, you can utilize the AOR data available in the DW_ASG_RESPONSIBILITY_D table while configuring custom security. The format of the AOR file that you download is different from the data security assignment file that you can upload, hence you must copy the required columns from the AOR file to the security assignment file prior to uploading it as the AOR-related security assignment file. For example, the AOR file has additional columns like AOR TYPE, which is for your reference only.

When you run the data pipeline for the Area of Responsibility functional area after activating it, Oracle Fusion Data Intelligence loads the AOR-related data from the DW_ASG_RESPONSIBILITY_D view, transforms it, and uses this data to populate the AOR file. The data in the AOR-related downloadable file is formatted as per the current data security assignment .csv file and pertains to the prebuilt security contexts of business unit, country, legal entity, and organization.

After uploading the security assignments data to Oracle Autonomous Data Warehouse, if the AOR assignment ends, then you must download the AOR and data security assignment files, compare mismatches between the two files, and take necessary actions of adding or removing contexts from the data security context and upload the correct data as and when required. The AOR file has only the current effective records; hence any end-dated record won’t be available in this file.

Note:

Replace existing configuration settings deletes existing data security assignments.

Sign in to your service.
In Oracle Fusion Data Intelligence Console, click Uploads under Application Administration.
On the Uploads page, click Download File and select Area of Responsibility.
Unzip the DataSecurityAssignmentAOR_csv.zip file you downloaded and edit the csv file as required.
When you are done updating the file, save your changes.
On the Uploads page, click Upload File and select Data Security Assignments in File Type.
Select whether you want to Merge to the existing settings or Replace existing configuration settings.
Select the file you want to upload and click Upload File.
You can review the status of the upload on the Uploads tab.
Use Actions next to the file name to perform actions on a specific upload file:
- Click Properties to check the upload statistics.
- Click Download to download the file you just uploaded in the event you want to upload the file again.
- Click Delete if a file fails to process and you want to remove the file history.