My Oracle Support Banner

Identifier Nvl2 Must Be Declared While Generating Hz_imp_load_addresses_pkg (Doc ID 280307.1)

Last updated on FEBRUARY 01, 2018

Applies to:

Oracle Receivables - Version 11.5.9 to [Release 11.5.9 to 11.5.10]
Information in this document applies to any platform.


After upgrading the database to Oracle 9i, the package body HZ_IMP_LOAD_ADDRESSES_PKG fails to compile with the error: Errors for PACKAGE BODY HZ_IMP_LOAD_ADDRESSES_PKG: LINE/COL ERROR -------- ----------------------------------------------------------------- 2681/5 PL/SQL: SQL Statement ignored 2714/14 PLS-00201: identifier 'NVL2' must be declared Other HZ package bodies may fail to compile as well.


This issue is only relevant to environments where the database is being upgraded to another majore database version.


To view full details, 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 a vibrant support community of peers and Oracle experts.