Oracle Communities

Oracle Analytics and AI

Child Item

FDI: HCM data security Issue

We came across an issue where we have to restrict data on the standard workbooks on a business unit basis. Let us say the client has two business units (Business unit1, business unit2) and the end users(User1, User2) are separate for each business unit. Here User1 should only see the data of Business Unit1 and user2 should only see the data of Business Unit2. Kindly let us know how to achieve this scenario.

Thanks in advance

Find more posts tagged with

HCM Analytics Content

FDI

OAC

Fusion HCM Analytics

Accepted answers

Ashish-Oracle

@Nalsoft Pvt Ltd You can go to FDI Console->Security->Users->Search for User->Security Assignment
Select HCM Business Units in Security Context and click on Grant Assignment.

Another way to do this would be to use the upload feature, download the file, use Table 6-1 Security Object Codes
For example:
HCM Business Units OA4F_SEC_HCM_BUSINESSUNIT_LIST
Upload and Download Data Security Assignments

https://docs.oracle.com/en/cloud/saas/analytics/24r2/fawag/manage-uploads-and-downloads.html#GUID-E49313C5-5499-4581-983F-945058BA68CB

Ashish-Oracle

@Nalsoft Pvt Ltd You will need to assign 'HCM Business Unit Data Security' Application Role to leverage the HCM Business Units Security context.

Ashish-Oracle

@Nalsoft Pvt Ltd Glad to know that your issue is resolved :) Kindly mark the post as answered so that it helps other members in the community as well.

Thanks and Regards

Ashish

All comments

Ashish-Oracle

@Nalsoft Pvt Ltd Please refer the below documents which can help you with your requirement
https://blogs.oracle.com/analytics/post/configuring-custom-data-security-in-fusion-analytics-warehouse-in-nine-steps

https://docs.oracle.com/en/cloud/saas/analytics/24r2/fawag/manage-data-access-security-assignments.html#GUID-51A54067-F83F-475E-9F28-A3AB62758451

https://blogs.oracle.com/analytics/post/faw-hcm-data-security-using-dept-hier-aor-attribute

Nalsoft Pvt Ltd

Manage Data Access through Security Assignments won't work for HCM

We tried doing with Configuring Custom Data Security in Fusion Data Intelligence in Nine Steps. It ended in error. I will attach error logs in visualization, execution log, and steps followed. Kindly go through the attached and suggest further.

Query Error Details.txt

Execution Log.txt

Steps followed to create custom data role.docx

Orange

Hi,

For us, manage data access through Security Assignments works fine for HCM, leveraging security context 'HCM Business Units'.

Nalsoft Pvt Ltd

Hi orange,

Can you please share the steps you followed.

Thank you

Ashish-Oracle

Nalsoft Pvt Ltd

@ashish.f.singh-Oracle

In New Security Assignment, under Select Security Assignments, select a security context, and then search for a security value or select from the displayed list. Move the selected security assignments to the column on the right.
Under Select Users, search for a user and select the user and move the user to the column on the right. Users are filtered based on the role associated with that context

these steps are mentioned in the document. I have selected the security context as HCM business units, selected security value as one of the business unit. But no users fetched.

In steps it is mentioned that Users are filtered based on the role associated with that context what role should be user has to be assigned.

Ashish-Oracle

@Nalsoft Pvt Ltd You will need to assign 'HCM Business Unit Data Security' Application Role to leverage the HCM Business Units Security context.

Nalsoft Pvt Ltd

@ashish.f.singh-Oracle thank you very much. Issue is resolved.

Ashish-Oracle

@Nalsoft Pvt Ltd Glad to know that your issue is resolved :) Kindly mark the post as answered so that it helps other members in the community as well.

Thanks and Regards

Ashish