Custom Oracle Analytics Security

Aubrey_K

We have custom ERP roles that successfully mapped to Oracle Analytics. We have also gone through and added the mapping to the custom roles that were created in Oracle Analytics. We have confirmed that our custom roles in Oracle Analytics have the appropriate data duty security roles mapped. However, zero of the Business units are being mapped from ERP to Oracle Analytics even though the Business units are defined on the custom ERP roles. We do have the nightly sync job running and we have confirmed there are zero error showing up on the log from the sync job.

Can someone please tell me is this expected functionality or is there some configuration we are missing in ERP or possible a specific policy/privilege's that need to be added to our custom roles in ERP.

Sumanth V -Oracle

@Aubrey_K - Welcome to Oracle Analytics Community!

If users are not assigned to standard/seeded roles (e.g., 'Accounts Payable Manager'). Instead, they are assigned to a custom role in FA (e.g., 'XX AP Manager Custom'). As a result, security assignments (Data Access Sets for users) will not flow automatically to FAW. These security assignments need to be manually added on the FAW side.

Please try and explore the Option 2 in the below document if you are looking to load them automatically.
FDI: Update Security Assignments Automatically using CUSTOMER_FAW_CONTENT_AUTOSYNC_ASSIGNMENT - KB155316

Reference:

https://docs.oracle.com/en/cloud/saas/analytics/25r1/fawag/manage-data-access-security-assignments.html#GUID-A0B2D948-3E55-4C17-8FDD-C810EECEB376

Thanks for opting Oracle Analytics Community.

User_1H7AY

https://community.oracle.com/products/oracleanalytics/discussion/comment/65655#Comment_65655

I have completed the creation of the CUSTOMER_FAW_CONTENT_AUTOSYNC_ASSIGNMENT table. I'm not sure I understand what to do after that.

" 2. In the CUSTOMER_FAW_CONTENT_AUTOSYNC_ASSIGNMENT table, specify the actual values for "USERNAME", "SEC_OBJ_CODE", "SEC_OBJ_MEMBER_VAL", "OPERATION_TYPE", and "CREATION_DATE". For "OPERATION_TYPE", enter "ADD" and enter the timestamp in "CREATION_DATE" in "2024-02-21 12:34:56.789" format."

Is this step something I need to do? or does this happen automatically during the upload process?

User_1H7AY

I am still getting a Failed result in Uploads after completing the instructions. Is there a step afterwards?

Screenshot 2025-04-22 090823.png

PRATHEEK

any suggestions or ideas would be greatly appreciated- Can someone please tell me is this expected functionality or is there some configuration we are missing in ERP or possible a specific policies or privilege's that need to be added to our custom roles in ERP.