My Oracle Support Banner

PV_OFFER_PUB Package Body Will Not Compile After DB Upgrade to 19C - PLS-00201 - Identifier Must Be Declared (Doc ID 3008079.1)

Last updated on APRIL 10, 2024

Applies to:

Oracle Partner Management - Version 12.2.7 and later
Information in this document applies to any platform.

Symptoms

After upgrading the database to version 19c the Oracle Partner Management, 'PV_OFFER_PUB' package body will not compile.

The following errors are received when compiling the package body:

 

PLS-00201: identifier 'OZF_OFFER_PUB.BUDGET_TBL_TYPE' must be declared
PL/SQL: Item ignored
PLS-00201: identifier 'OZF_OFFER_PUB.DISCOUNT_LINE_TBL_TYPE' must be declared
PL/SQL: Item ignored
PLS-00201: identifier 'OZF_OFFER_PUB.NA_QUALIFIER_TBL_TYPE' must be declared
PL/SQL: Item ignored
PLS-00201: identifier 'OZF_OFFER_PUB.MODIFIER_LINE_TBL_TYPE' must be declared
PL/SQL: Item ignored
PLS-00201: identifier 'OZF_OFFER_PUB.QUALIFIERS_TBL_TYPE' must be declared
PL/SQL: Item ignored
PLS-00201: identifier 'OZF_OFFER_PUB.ACT_PRODUCT_TBL_TYPE' must be declared
PL/SQL: Item ignored
PLS-00201: identifier 'OZF_OFFER_PUB.EXCL_REC_TBL_TYPE' must be declared
PL/SQL: Item ignored
PLS-00201: identifier 'OZF_OFFER_PUB.OFFER_TIER_TBL_TYPE' must be declared
PL/SQL: Item ignored
PLS-00201: identifier 'OZF_OFFER_PUB.PROD_REC_TBL_TYPE' must be declared
PL/SQL: Item ignored
PLS-00201: identifier 'OZF_OFFER_PUB.MODIFIER_LIST_REC_TYPE' must be declared
PL/SQL: Item ignored

 

Changes

 The issue is caused after upgrading the database to version 19c

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.