Package Body OZF_ADJUSTMENT_EXT_PVT Is Invalid (Doc ID 2249484.1)

Last updated on JULY 25, 2017

Applies to:

Oracle Trade Management - Version 12.2.4 and later
Information in this document applies to any platform.

Symptoms

Package Body OZF_ADJUSTMENT_EXT_PVT Is not valid due to following error - 

ERROR
-----------------------
Errors for PACKAGE BODY OZF_ADJUSTMENT_EXT_PVT

PL/SQL: ORA-00904: "TEMP"."OFFER_ADJUSTMENT_ID": invalid identifier
PL/SQL: SQL Statement ignored
PL/SQL: ORA-00904: "TEMP"."OFFER_ADJUSTMENT_ID": invalid identifier
PL/SQL: SQL Statement ignored
PL/SQL: ORA-00904: "TEMP"."OFFER_ADJUSTMENT_ID": invalid identifier
PL/SQL: SQL Statement ignored
PL/SQL: ORA-00904: "TEMP"."OFFER_ADJUSTMENT_ID": invalid identifier
PL/SQL: SQL Statement ignored
PL/SQL: ORA-00904: "TEMP"."OFFER_ADJUSTMENT_ID": invalid identifier
PL/SQL: SQL Statement ignored
PLS-00341: declaration of cursor 'C_ENDDATED_PRODUCTS' is incomplete or malformed
PL/SQL: Item ignored
PLS-00320: the declaration of the type of this expression is incomplete or malformed
PL/SQL: SQL Statement ignored
PLS-00320: the declaration of the type of this expression is incomplete or malformed
PL/SQL: SQL Statement ignored
PLS-00320: the declaration of the type of this expression is incomplete or malformed
PL/SQL: SQL Statement ignored
PLS-00320: the declaration of the type of this expression is incomplete or malformed
PL/SQL: Statement ignored




Changes

 

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