My Oracle Support Banner

After 12.2.4 Upgrade, AP_APPROVAL_PKG PACKAGE BODY Is Invalid (Doc ID 2001866.1)

Last updated on JANUARY 16, 2018

Applies to:

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

Symptoms


After 12.2.4 upgrade, AP_APPROVAL_PKG PACKAGE BODY is invalid.


These are the compilation errors:

7080 10 PL/SQL: ORA-00904: "VALIDATION_REQUEST_ID": invalid identifier
7071 3 PL/SQL: SQL Statement ignored
7235 19 PL/SQL: ORA-00904: "VALIDATION_REQUEST_ID": invalid identifier
7220 3 PL/SQL: SQL Statement ignored
9575 11 PL/SQL: ORA-00904: "AHA"."VALIDATION_REQUEST_ID": invalid identifier
9573 5 PL/SQL: SQL Statement ignored
10553 28 PL/SQL: ORA-00904: "AHA"."VALIDATION_REQUEST_ID": invalid identifier
10541 6 PL/SQL: SQL Statement ignored
10568 12 PL/SQL: ORA-00904: "AHA"."VALIDATION_REQUEST_ID": invalid identifier
10565 7 PL/SQL: SQL Statement ignored
12582 10 PL/SQL: ORA-00904: "VALIDATION_REQUEST_ID": invalid identifier
12581 5 PL/SQL: SQL Statement ignored
13129 12 PL/SQL: ORA-00904: "VALIDATION_REQUEST_ID": invalid identifier
13128 8 PL/SQL: SQL Statement ignored

 

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
Cause
Solution


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.