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 laterInformation 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
-----------------------
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! |