My Oracle Support Banner

R12: AP: 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 JULY 01, 2019

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

 

Changes

 

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!


In this Document
Symptoms
Changes
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.