AP_APPROVAL_PKG Will Not Compile Due To ORA-00904: "POD"."GLOBAL_ATTRIBUTE_CATEGORY": invalid,identifier (Doc ID 1945752.1)

Last updated on MARCH 08, 2017

Applies to:

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

Symptoms


After having applied some patches,
the AP_APPROVAL_PKG package body is invalid.
The following errors are shown when trying to compile the object.

ERRORS
-----------------------
Errors for PACKAGE BODY AP_APPROVAL_PKG:

LINE/COL,ERROR
--------,-----------------------------------------------------------------
12358/11,PLS-00341: declaration of cursor 'DIST_CUR' is incomplete or,malformed
12359/4 ,PL/SQL: SQL Statement ignored
12361/89,PL/SQL: ORA-00904: "POD"."GLOBAL_ATTRIBUTE_CATEGORY": invalid,identifier
12368/4 ,PL/SQL: Item ignored
12385/4 ,PL/SQL: SQL Statement ignored
12385/37,PLS-00597: expression 'DIST' in the INTO list is of wrong type
12391/5 ,PL/SQL: Statement ignored
12391/10,PLS-00487: Invalid reference to variable 'DIST_CUR%ROWTYPE'
12394/4 ,PL/SQL: Statement ignored
12394/20,PLS-00487: Invalid reference to variable 'DIST_CUR%ROWTYPE'
12497/64,PLS-00382: expression is of wrong type
12497/64,PLS-00487: Invalid reference to variable 'DIST_CUR%ROWTYPE'
12497/90,PLS-00382: expression is of wrong type
12497/90,PLS-00487: Invalid reference to variable 'DIST_CUR%ROWTYPE'
12499/29,PLS-00382: expression is of wrong type
12499/29,PLS-00487: Invalid reference to variable 'DIST_CUR%ROWTYPE'
12500/35,PLS-00382: expression is of wrong type
12500/35,PLS-00487: Invalid reference to variable 'DIST_CUR%ROWTYPE'
12501/39,PLS-00382: expression is of wrong type




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