My Oracle Support Banner

Upgrade Issue: AR_CUSTOMER_PROFILE_CLASSES_V Is Invalid After 12.1.1 Upgrade (Doc ID 946246.1)

Last updated on JULY 12, 2017

Applies to:

Oracle Receivables - Version 12.1.1 and later
Information in this document applies to any platform.
This problem can occur on any platform.


After upgrade of applications from to 12.1.1, the object
APPS.AR_CUSTOMER_PROFILE_CLASSES_V is invalid (causing other object to be invalid).

When recompiling the pakage manually, the following error is received:

SQL > show errors package body ARH_CPC_PKG;

-------- -----------------------------------------------------------------
514/5 PL/SQL: SQL Statement ignored
617/8 PL/SQL: ORA-00904: "AUTOMATCH_SET_ID": invalid identifier
1060/5 PL/SQL: Statement ignored
1325/22 PLS-00302: component 'AUTOMATCH_SET_ID' must be declared
1659/5 PL/SQL: SQL Statement ignored
1761/4 PL/SQL: ORA-00904: "AUTOMATCH_SET_ID": invalid identifier


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

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