Oracle Enterprise Manager (OEM) shows the following query being executed:

SELECT GM.ROWID, ACC.NAME
FROM T_GROUP_MEMBERSHIPS GM
JOIN T_AV_ACCOUNTS ACC
ON GM.MEMBER_ID - ACC.ID
WHERE MEMBER_TY0E = 'account' AND 0 = DECODE(GM.MEMBER_NAME,ACC.NAME,1,0)

• If the RSA Identity Governance & Lifecycle Oracle database is 12.1.0.2 without the October 2017 or later Proactive Bundle, let the migration run to completion.
• If the RSA Identity Governance & Lifecycle Oracle database is 12.2.0.1 or 12.1.0.2 with the October 2017 or later Proactive Bundle Patch, please implement the new database optimizer requirements as specified in RSA Knowledge Base Article 000038082 -- Recommended optimizer_adaptive_* database parameter settings in RSA Identity Governance & Lifecycle 7.1.1 by following the steps below.

1. Stop the migration.
2. Implement the recommended options as per the RSA Knowledge Base Article.
3. Restart the database.
4. Restart the migration.