REL11i AP: Several AP objects Are Invalid After Patching

(Doc ID 1392051.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Payables - Version 11.5.10.2 and later
Information in this document applies to any platform.
***Checked for relevance on 10-Dec-2015***

Symptoms


On : 11.5.10.2 version,

After applying several patches, there are AP invalid objects.
The objects cannot be compiled due to the following errors:

COMPILATION ERRORS

APPS.AP_CREDIT_CARD_INVOICE_PKG
PLS-00905 object APPS.AP_WEB_DB_EXPLINE_PKG is invalid
APPS.AP_WEB_AUDIT_PROCESS
PLS-00905 object APPS.AP_WEB_DB_EXPLINE_PKG is invalid
APPS.AP_WEB_DISC_PKG
PLS-00905 object APPS.AP_WEB_DB_EXPLINE_PKG is invalid
APPS.AP_WEB_OA_DETAIL_PKG
PLS-00905 object APPS.AP_WEB_DB_EXPLINE_PKG is invalid
APPS.AP_WEB_DB_EXPDIST_PKG
PLS-00905 object APPS.AP_WEB_DB_EXPLINE_PKG is invalid
APPS.AP_WEB_CREDIT_CARD_WF
PLS-00905 object APPS.AP_WEB_EXPENSE_WF is invalid
APPS.AP_WEB_CUST_AME_PKG
PLS-00905 object APPS.AP_WEB_EXPENSE_WF is invalid
APPS.AP_WEB_EXPENSE_CUST_WF
PLS-00905 object APPS.AP_WEB_EXPENSE_WF is invalid
APPS.AP_WEB_OA_MAINFLOW_PKG
PLS-00905 object APPS.AP_WEB_EXPENSE_WF is invalid
PLS-00905 object APPS.AP_WEB_DB_EXPLINE_PKG is invalid
APPS.AP_WEB_WRAPPER_PKG
PLS-00905 object APPS.AP_WEB_EXPENSE_WF is invalid
APPS.AP_WEB_INFRASTRUCTURE_PKG
PLS-00905 object APPS.AP_WEB_EXPENSE_WF is invalid
APPS.AP_WEB_EXPENSE_WF
PLS-00304 cannot compile body of 'AP_WEB_EXPENSE_WF' without its specification
PLS-00905 object APPS.AP_WEB_EXPENSE_WF is invalid
APPS.AP_WEB_DB_EXPLINE_PKG
PLS-00304 cannot compile body of 'AP_WEB_DB_EXPLINE_PKG' without its specification
PLS-00905 object APPS.AP_WEB_DB_EXPLINE_PKG is invalid
APPS.AP_WEB_DB_EXP_ATTENDEES_PKG
PLS-00304 cannot compile body of 'AP_WEB_DB_EXP_ATTENDEES_PKG' without its specification
PLS-00905 object APPS.AP_WEB_DB_EXP_ATTENDEES_PKG is invalid
APPS.AP_WEB_MANAGEMENT_REPORTS_PKG
PL/SQL ORA-00904 "AERV"."REPORT_LINE_ID" invalid identifier
PLS-00364 loop index variable 'VIOLREC' use is invalid


Changes

Applied several patches

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