Import Oracle Fusion Human Capital Management (HCM) Security Roles into Oracle Analytics Cloud (OAC)

Russ Kevin Salvador

Organization Name

Arcadis

Description

We are trying to import the Security Roles from Oracle Fusion Human Capital Management (HCM) into Oracle Analytics Cloud (OAC) but we are encountering difficulties since we are not able to get the correct tables from Fusion HCM.

We already create an Oracle SR and the feedback that we got is 

"As of right now, Fusion HCM uses a different model structure from BI APPS which is preventing us from recreating."
 

Use Case and Business Need

If we are able to extract the Security Roles from Oracle Fusion Human Capital Management (HCM) it will provide us a robust security for Oracle Analytics Cloud (OAC).

More details

We already create an Oracle SR and the feedback that we got is 

"As of right now, Fusion HCM uses a different model structure from BI APPS which is preventing us from recreating."

Reference: SR 3-21177295381 : Spin off from SR 3-20995287591: Need HCM tables to implement data security on HCM Subject Area

Original Idea Number: 570fcd73bb

Barbara Oliveira

This is a very helpful report to have online basis.

Matt Van Asten

Hi, it is possible to get HR security tables into DBCS or ADW and mimic row level security in OACS. You can contact me directly if you want at matt.van.asten@pwc.com