R12 E-Business Suite Invalid Database Objects Exist With Naming Conventions Like '_AIP', '_AUP', and '_ADP' Which Do Not Recompile Via Adadmin Or Uutlrp.sql (Doc ID 2257674.1)

Last updated on MAY 03, 2017

Applies to:

Oracle Application Object Library - Version 12.1.3 and later
Oracle Applications DBA - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

E-Business Suite R12 Applications DBA, Issues with the Functionality of AD Utilities and Invalid Object issues

 

 

Reviewing the invalid database objects on an E-Business Suite database, many invalid objects exist which do not recompile using either adadmin or utlrp.sql.

Some of the invalid objects in question include the following Application Object Library auditing procedures:

FND_AUDIT_COLUMNS_AIP PROCEDURE
FND_AUDIT_TABLES_AIP PROCEDURE
FND_AUDIT_GROUPS_AIP PROCEDURE
FND_AUDIT_SCHEMAS_AIP PROCEDURE

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms