• Poor performance when cancelling change requests from workpoint nodes.
• Poor load time when navigating back on a request form after requesting items that create pending accounts.
• Indirect relationship processing taking days to complete after making changes to a Multi-App Entitlement Data Collector.

• BEGIN Access_Request_Pkg.Delete_ChangeRequest(:1 ); END;
• DELETE FROM T_AV_EXPLODEDUSERENTITLEMENTS WHERE CRI_ID = :B1
• DELETE FROM T_AV_EXPLODEDUSERENTITLEMENTS WHERE COLLECTED_STATE_CODE = :B1 AND CRI_ID IN (SELECT ID FROM T_AV_CHANGE_REQUEST_DETAILS WHERE CHANGE_REQUESTS_ID IN (SELECT ID FROM GTT_IDS))
• MERGE /*+ Leading (r) Index (xue IXN_XUE_CE_EXPLODED_PATH) */ INTO T_AV_EXPLODEDUSERENTITLEMENTS XUE USING (SELECT CE_EXPLODED_PATH FROM GTT_CE_AFFECTED_PARENTS) R ON ( XUE.CE_EXPLODED_PATH LIKE ' ' || R.CE_EXPLODED_PATH || '%' ) WHEN MATCHED THEN UPDATE SET XUE.DELETION_DATE = SYSDATE WHERE XUE.DELETION_DATE IS NULL AND XUE.ENTITLED_TYPE = :B1

1. Login to SQL as AVUSER and check for column CRI_ID:

select owner, table_name, column_name 
from all_tab_columns 
where table_name='T_AV_EXPLODEDUSERENTITLEMENTS' and column_name='CRI_ID'

2. If this query returns a row, then check for an index on the column:

select * 
from all_ind_columns 
where index_name='IXN_XUE_CRI_ID';

3. If this column returns no results and you are on 7.0.2 P10+, 7.1.0 P03+ or 7.1.1, then you have confirmed you have this issue. 

• RSA Identity Governance & Lifecycle 7.0.2 P13
• RSA Identity Governance & Lifecycle 7.1.0 P07
• RSA Identity Governance & Lifecycle 7.1.1 P01