My Oracle Support Banner

Zx_product_integration_pkg Invalid (Doc ID 737140.1)

Last updated on DECEMBER 03, 2019

Applies to:

Oracle E-Business Tax - Version 12.0.5 and later
Information in this document applies to any platform.

Symptoms


On 12.0.5 in Production:
When attempting to apply patches from note:note 406376.1
the following error occurs:

alter package ZX_PRODUCT_INTEGRATION_PKG compile body;

ERROR
ZX_PRODUCT_INTEGRATION_PKG package body is invalid

When attempting to compile we get the following errors:
show err package body ZX_PRODUCT_INTEGRATION_PKG;

PL/SQL: Statement ignored
PLS-00302: component 'G_JL_EXCEPTION_TYPE' must be declared
PL/SQL: Statement ignored
PLS-00302: component 'G_JL_EXCEPTION_TYPE' must be declared

 

Changes

apply patches from <note 406376.1>

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
 Still Have Questions?
References


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