R12: AP: AP_PAYMENT_EVENT_WF_PK Invalid After Upgrading From 11.5.10.2 To 12.1.1

Last updated on JANUARY 16, 2018

Applies to:

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 dcshanmu ship $ */

Changes

Upgraded from 11i to R12.1.3

Cause