R:12:AP: During installation of patch 22507584 compilation gives PLS-00302: Component 'LINE_LOCATION_TAB_TYPE' Must Be Declared (Doc ID 2273802.1)

Last updated on JUNE 05, 2017

Applies to:

Oracle Payables - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

1. DESCRIPTION OF THE LOSS OF FUNCTIONALITY
------------------------------------------------------
In Oracle Payables, package AP_IMPORT_INVOICES_PKG is INVALID. The following error is displayed:

ERROR
-------

MSG-00999: ORA-04063: package body "APPS.AP_IMPORT_INVOICES_PKG" has errors
REP-1419: 'beforereport': PL/SQL program aborted.
REP-0069: Internal error
REP-57054: In-process job terminated:Terminated with error:
REP-1419: MSG-00999: ORA-04063: package body "APPS.AP_IMPORT_INVOICES_PKG" has errors
REP-1419: 'beforereport': PL/SQL program aborted.

When trying to compile APPS.AP_IMPORT_INVOICES_PKG body

 





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