PCG Database Has Invalid Objects (Doc ID 2651211.1)

Last updated on OCTOBER 10, 2023

Applies to:

Goal

The following invalids were found in the environment and they were deleted.After they were deleted and there are more invalid objects in the environment and we need to provide a script to remove the invalid objects.
LAA_SIM_USER_CONFLICTS_PKG
LAA_APPS_ACCESS_PKG

After the above action, all the below invalids were in DB
LAA_ALL_USER_CONFLT_V
LAA_CONFLICT_ENTITIES_BO
LAA_CONFLICT_ENTITIES_STATUS_V
LAA_CONFLICT_ENTITIES_V
LAA_ENFORCEMENTS_V
LAA_MASS_UPDATE_USER_CONFLT_V
LAA_SIM_RESP_RESULTS
LAA_SIM_USER_RESULTS
LAA_USER_CONFLICT_ENTITIES_VEW
LAA_ALL_USER_CONFLT_V
LAA_APPS_ACCESS_GEN_PKG
LAA_APPS_LOAD_PKG
LAA_CONFLICT_ENTITIES_BO
LAA_CONFLICT_ENTITIES_STATUS_V
LAA_CONFLICT_ENTITIES_V
LAA_ENFORCEMENTS_V
LAA_LOAD_GROUPS_RULES
LAA_MASS_UPDATE_USER_CONFLT_V
LAA_SIM_RESP_RESULTS
LAA_SIM_USER_RESULTS
LAA_USER_CONFLICT_ACTION_MU
LAA_USER_CONFLICT_ENTITIES_VEW
LA_IDM_SOD_ANALYSIS

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Removed invalids
LAA_SIM_USER_CONFLICTS_PKG
LAA_APPS_ACCESS_PKG
2. There are more invalids in the database

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot remove the invalids.

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.