After Upgrade To R12.1.1 AP Packages are Invalid AP_AUTOMATIC_PROPAGATION_PKG AP_FUNDS_CONTROL_PKG AP_ACCOUNTING_EVENTS_PKG (Doc ID 1168214.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Payables - Version: 12.1.1 and later   [Release: 12.1 and later ]
Information in this document applies to any platform.

Symptoms

After upgrading to 12.1 from 12.0.6, found some packages as invalid and unable to compile them. The compilation errors are as follows:

ERROR
-----------------------
1. Errors for PACKAGE BODY AP_ACCOUNTING_EVENTS_PKG

LINE/COL ERROR
-------- -----------------------------------------------------------------
18/11 PLS-00323: subprogram or cursor 'DELETE_INVOICE_EVENT' is
declared in a package specification and must be defined in the
package body

2. Errors for PACKAGE BODY AP_AUTOMATIC_PROPAGATION_PKG:

LINE/COL ERROR
-------- -----------------------------------------------------------------
142/5 PL/SQL: Statement ignored
142/33 PLS-00302: component 'INITIALIZE' must be declared
165/4 PL/SQL: Statement ignored
165/32 PLS-00302: component 'GET_DEFAULT_BANK_ACCT' must be declared
239/4 PL/SQL: Statement ignored

3. Errors for PACKAGE BODY AP_FUNDS_CONTROL_PKG:

LINE/COL ERROR
-------- -----------------------------------------------------------------
49/11 PLS-00323: subprogram or cursor 'ENCUM_UNPROCESSED_EVENTS_DEL'
is declared in a package specification and must be defined in
the package body

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot compile the invalids and unable to access Invoice workbench form. Due to this issue, can't use Payables application fully.

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