My Oracle Support Banner

R12: AP: AP_PAYMENT_EVENT_WF_PK Invalid After Upgrading From 11.5.10.2 To 12.1.1 (Doc ID 1355023.1)

Last updated on JULY 10, 2020

Applies to:

Oracle Payables - Version 12.1.1 and later
Information in this document applies to any platform.
$AP_TOP/patch/115/sql/appewfps.pls 120.2.12010000.2
$AP_TOP/patch/115/sql/appewfpb.pls 120.4.12010000.2


Symptoms

The AP_PAYMENT_EVENT_WF_PKG is invalid after upgrading from 11i to R12.1.3.

1. Manually compile the package.
Alter package APPS.AP_PAYMENT_EVENT_WF_PKG compile;
Alter package APPS.AP_PAYMENT_EVENT_WF_PKG compile body;

2. Check the error messages:

Select name, text from dba_errors where name in (select object_name from dba_objects where status='INVALID' and owner = 'APPS' and object_name like 'AP_PAYMENT_EVENT_WF_PKG');

ERROR
-----------------------
AP_PAYMENT_EVENT_WF_PKG
PL/SQL: Compilation unit analysis terminated

AP_PAYMENT_EVENT_WF_PKG
PLS-00304: cannot compile body of 'AP_PAYMENT_EVENT_WF_PKG' without its specific
ation

AP_PAYMENT_EVENT_WF_PKG
PLS-00201: identifier 'AP_PAYMENT_EVENT_WF_PKG' must be declared


3. Check the Database package versions
SELECT NAME, text
FROM all_source
WHERE NAME IN
('AP_PAYMENT_EVENT_WF_PKG')
AND line = 2
ORDER BY 1;

AP_PAYMENT_EVENT_WF_PKG
/* $Header: appewfpb.pls 120.4.12010000.2 2008/12/23 12:53:53 */

Changes

Upgraded from 11i to R12.1.3

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!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.