AP_IMPORT_VALIDATION_PKG Package Body Is Invalid PLS-00907: cannot load library unit APPS.AP_IMPORT_INVOICES_PKG (referenced by APPS.AP_IMPORT_VALIDATION_PKG) (Doc ID 2223068.1)

Last updated on MARCH 08, 2017

Applies to:

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

Symptoms


AP_IMPORT_VALIDATION_PKG database object is invalid:

SQL> alter package APPS.AP_IMPORT_VALIDATION_PKG compile body;

Warning: Package Body altered with compilation errors.

SQL> show error
Errors for PACKAGE BODY APPS.AP_IMPORT_VALIDATION_PKG:

LINE/COL ERROR
-------- -----------------------------------------------------------------
0/0 PLS-00907: cannot load library unit APPS.AP_IMPORT_INVOICES_PKG
  (referenced by APPS.AP_IMPORT_VALIDATION_PKG)

0/0 PLS-00907: cannot load library unit APPS.AP_IMPORT_INVOICES_PKG
(referenced by APPS.AP_IMPORT_VALIDATION_PKG)

0/0 PLS-00907: cannot load library unit APPS.AP_IMPORT_INVOICES_PKG
(referenced by APPS.AP_IMPORT_VALIDATION_PKG)

0/0 PLS-00907: cannot load library unit APPS.AP_IMPORT_INVOICES_PKG
(referenced by APPS.AP_IMPORT_VALIDATION_PKG)

0/0 PLS-00907: cannot load library unit APPS.AP_IMPORT_INVOICES_PKG
(referenced by APPS.AP_IMPORT_VALIDATION_PKG)

0/0 PLS-00907: cannot load library unit APPS.AP_IMPORT_INVOICES_PKG
(referenced by APPS.AP_IMPORT_VALIDATION_PKG)

0/0 PLS-00907: cannot load library unit APPS.AP_IMPORT_INVOICES_PKG
(referenced by APPS.AP_IMPORT_VALIDATION_PKG)

0/0 PLS-00907: cannot load library unit APPS.AP_IMPORT_INVOICES_PKG
(referenced by APPS.AP_IMPORT_VALIDATION_PKG)

0/0 PLS-00907: cannot load library unit APPS.AP_IMPORT_INVOICES_PKG
(referenced by APPS.AP_IMPORT_VALIDATION_PKG)

0/0 PLS-00907: cannot load library unit APPS.AP_IMPORT_INVOICES_PKG
(referenced by APPS.AP_IMPORT_VALIDATION_PKG)

160/5 PL/SQL: Statement ignored
237/6 PL/SQL: Statement ignored
252/7 PL/SQL: Statement ignored
380/9 PL/SQL: Statement ignored
404/13 PL/SQL: Statement ignored
423/9 PL/SQL: Statement ignored
481/5 PL/SQL: Statement ignored
563/7 PL/SQL: Statement ignored
618/9 PL/SQL: Statement ignored
671/9 PL/SQL: Statement ignored

 

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