Multiple HZ Packages File to Compile in R12 (Doc ID 2097320.1)

Last updated on AUGUST 24, 2016

Applies to:

Oracle Receivables - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

You have upgraded from 11.5.10.2 to R12 and receive the following error, when attempting to compile HZ_MERGE_PKG.

The following error occurs due to missing APPS schema and the APPS schema is referenced in the package code.

'APPS.HZ_PARTY_USG_ASSIGNMENT_PVT'

ERROR
-----------------------
[Error] PLS-00201 (4910: 31): PLS-00201: identifier
'APPS.HZ_PARTY_USG_ASSIGNMENT_PVT' must be declared
[Error] PLS-00320 (4941: 17): PLS-00320: the declaration of the type of this expression is incomplete or malformed
[Error] PLS-00320 (4973: 18): PLS-00320: the declaration of the type of this expression is incomplete or malformed
[Error] ORA-00904 (5001: 14): PL/SQL: ORA-00904: : invalid identifier
[Error] PLS-00320 (5005: 33): PLS-00320: the declaration of the type of this expression is incomplete or malformed

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