Configure Impersonate User for the Use Active User's Credentials Option

You can configure "impersonate user" to enable the active user's credentials option when you use the Oracle Applications connection type.

You can implement "impersonate user" for connections to Oracle Fusion Cloud Applications Suite with Oracle Transactional Business Intelligence, and Oracle BI EE. When you use "impersonate user", users can access data allowed for the active user's permissions, privileges, and role assignments. Users aren’t prompted to enter their user name and password.

Tips on setting up impersonation

• Provision one administrator user in the Oracle Fusion Cloud Enterprise Performance Management (EPM) identity domain with the necessary roles and permissions to impersonate other users.
• Specify the credentials for this EPM administrator user when you import the metadata using the Model Administration Tool. The credentials are stored in the connection pool of the RPD data model created by the Model Administration Tool.
• In addition, the SSO checkbox must be checked on the Planning server connection pool in the RPD.
• With this setup, only one native user needs to be provisioned in the EPM identity domain. Other end users log into Oracle Analytics using their SSO credentials, and Oracle Analytics passes the SSO username to Planning and Budgeting Cloud Service when connecting, along with the credentials of the native EPM administrator user that has impersonation permissions.
• Note: Logging into EPM using SSO credentials isn't supported by the REST API or the Planning ADM driver.