R12: AP: AP_PAYMENT_EVENT_WF_PK Invalid After Upgrading From 220.127.116.11 To 12.1.1
Last updated on JANUARY 16, 2018
Applies to:Oracle Payables - Version 12.1.1 and later
Information in this document applies to any platform.
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');
PL/SQL: Compilation unit analysis terminated
PLS-00304: cannot compile body of 'AP_PAYMENT_EVENT_WF_PKG' without its specific
PLS-00201: identifier 'AP_PAYMENT_EVENT_WF_PKG' must be declared
3. Check the Database package versions
SELECT NAME, text
WHERE NAME IN
AND line = 2
ORDER BY 1;
/* $Header: appewfpb.pls 120.4.12010000.2 2008/12/23 12:53:53 dcshanmu ship $ */
Upgraded from 11i to R12.1.3
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms