AP_APPROVAL_PKG Will Not Compile Due To ORA-00904: "POD"."GLOBAL_ATTRIBUTE_CATEGORY": invalid,identifier

(Doc ID 1945752.1)

Last updated on JANUARY 16, 2018

Applies to:

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


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


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


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