My Oracle Support Banner

PCG Database Has Invalid Objects (Doc ID 2651211.1)

Last updated on APRIL 29, 2020

Applies to:

Oracle Preventive Controls Governor - Version 7.3 and later
Information in this document applies to any platform.

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
References


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