HZ_CUSTOMER_PROFILE_V2PUB Compilation Error PLS-00907: Cannot Load Library Unit APPS.HZ_CUSTOMER_PR (Doc ID 1645725.1)

Last updated on OCTOBER 13, 2022

Applies to:

Symptoms

In R12.1.3, trying to create a customer using API HZ_CUST_ACCOUNT_V2PUB and the following error is received:

Error
ORA-06550: line 0, column 0:
PLS-00907: cannot load library unit APPS.HZ_CUSTOMER_PROFILE_V2PUB (referenced by APPS.HZ_CUST_ACCOUNT_V2PUB)
ORA-06550: line 41, column 1:
PL/SQL: Statement ignored
06550. 00000 - "line %s, column %s:\n%s"
*Cause: Usually a PL/SQL compilation error.
*Action:


Cross verifying the object "APPS.HZ_CUSTOMER_PROFILE_V2PUB" is invalid and when trying to compile, the same error is received:

  Package Body APPS.HZ_CUSTOMER_PROFILE_V2PUB@SFDEV
  Error: PLS-00907: cannot load library unit APPS.HZ_CUSTOMER_PROFILE_V2PUB (referenced by APPS.HZ_ACCOUNT_VALIDATE_V2PUB)
  Error(544,5): PL/SQL: Statement ignored
  Error(1224,5): PL/SQL: Statement ignored
  Error(1741,5): PL/SQL: Statement ignored
  Error(1988,5): PL/SQL: Statement ignored

Also when trying to compile "HZ_ACCOUNT_VALIDATE_V2PUB", the same error is received:

Package Body APPS.HZ_ACCOUNT_VALIDATE_V2PUB@SFDEV
  Error: PLS-00907: cannot load library unit APPS.HZ_CUSTOMER_PROFILE_V2PUB (referenced by APPS.HZ_ACCOUNT_VALIDATE_V2PUB)

Changes

Cause

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