Oracle Analytics and AI

User_7AIAG

In a production to test environment refresh process if a user's id does not exist in production instance, how will the user would be able to login to FDI post refresh who was earlier a service administrator.

will the access need to recreated in lower ERP instance or we can primarily mitigate this issue by following some other approach.

RVohra

@User_7AIAG , this is a very good question and there are few options to mitigate this situation.

Option 1: Recreate the user and roles in the lower environment

After the refresh, you manually re-create the user in the test environment and assign them the Service Administrator role again. This is usually the standard approach for non-production-only users.

Option 2: Pre-refresh preparation

• Export a list of test-only users and their roles before the refresh and after the refresh, re-import or recreate these users with their roles.

• Option 3: Use an identity federation / SSO

If FDI is integrated with SSO (e.g., OCI Identity, IDCS), the user can exist in the identity provider, even if they are not in production. You would still need to assign FDI roles after refresh, but login can work if the ID exists in IDCS.

Hope it helps!