My Oracle Support Banner

After Upgrade To 12.2.11 There Are Several AMV Invalid Objects (Doc ID 2888011.1)

Last updated on APRIL 26, 2023

Applies to:

Oracle Marketing Encyclopedia System - Version 12.2.11 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.11 version, 


After upgrading to 12.2.11, there are several AMV invalid objects.  Need assistance in making these invalid object valid.



Error

OWNER NAME                         SEQUENCE                   TYPE TEXT
======================================================================
APPS AMV_AQ_UTILITY_PVT 1 PACKAGE PLS-00201: identifier 'AMV_AQ_MSG_OBJECT_TYPE' must be declared
APPS AMV_AQ_UTILITY_PVT 1 PACKAGE BODY PLS-00905: object APPS.AMV_AQ_UTILITY_PVT is invalid
APPS AMV_AQ_UTILITY_PVT 2 PACKAGE PL/SQL: Declaration ignored
APPS AMV_AQ_UTILITY_PVT 2 PACKAGE BODY PLS-00304: cannot compile body of 'AMV_AQ_UTILITY_PVT' without its specification
APPS AMV_AQ_UTILITY_PVT 3 PACKAGE BODY PL/SQL: Compilation unit analysis terminated
APPS AMV_AQ_UTILITY_PVT 3 PACKAGE PLS-00201: identifier 'AMV_AQ_MSG_OBJECT_TYPE' must be declared
APPS AMV_AQ_UTILITY_PVT 4 PACKAGE PL/SQL: Declaration ignored
APPS AMV_MATCH_PVT 1 PACKAGE BODY PLS-00201: identifier 'AMV_AQ_MSG_OBJECT_TYPE' must be declared
APPS AMV_MATCH_PVT 2 PACKAGE BODY PL/SQL: Item ignored
APPS AMV_MATCH_PVT 3 PACKAGE BODY PLS-00320: the declaration of the type of this expression is incomplete or malformed
APPS AMV_MATCH_PVT 4 PACKAGE BODY PL/SQL: Statement ignored
APPS AMV_MATCH_PVT 5 PACKAGE BODY PLS-00320: the declaration of the type of this expression is incomplete or malformed
APPS AMV_MATCH_PVT 6 PACKAGE BODY PL/SQL: Statement ignored
APPS AMV_MATCH_PVT 7 PACKAGE BODY PLS-00201: identifier 'AMV_AQ_MSG_OBJECT_TYPE' must be declared
APPS AMV_MATCH_PVT 8 PACKAGE BODY PL/SQL: Item ignored
APPS AMV_MATCH_PVT 9 PACKAGE BODY PLS-00320: the declaration of the type of this expression is incomplete or malformed
APPS AMV_MATCH_PVT 10 PACKAGE BODY PL/SQL: Statement ignored
APPS AMV_MATCH_PVT 11 PACKAGE BODY PLS-00320: the declaration of the type of this expression is incomplete or malformed
APPS AMV_MATCH_PVT 12 PACKAGE BODY PL/SQL: Statement ignored
APPS AMV_MATCH_PVT 13 PACKAGE BODY PLS-00201: identifier 'AMV_AQ_MSG_OBJECT_TYPE' must be declared
APPS AMV_MATCH_PVT 14 PACKAGE BODY PL/SQL:

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution


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