Invalid EBTax Objects After Upgrade To 12.2.6 ZX_SRVC_TYP_PKG & ZX_TPI_SERVICES_PKG (Doc ID 2220214.1)

Last updated on JANUARY 04, 2017

Applies to:

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

Symptoms

On : 12.2.6 version, Upgrade and Migration

ACTUAL BEHAVIOR
---------------
Invalid EBTax Objects after Upgrade to 12.2.6 ZX_SRVC_TYP_PKG & ZX_TPI_SERVICES_PKG

Errors for PACKAGE BODY ZX_SRVC_TYP_PKG:

LINE/COL ERROR
-------- -----------------------------------------------------------------
12571/18 PL/SQL: Statement ignored
12571/38 PLS-00302: component 'SYNC_MIG_TAX_DIST_AMT' must be declared

Errors for PACKAGE BODY ZX_TPI_SERVICES_PKG:

LINE/COL ERROR
-------- -----------------------------------------------------------------
339/4 PL/SQL: Statement ignored
339/52 PLS-00302: component 'CURRENCY_CONVERSION_DATE' must be declared
340/4 PL/SQL: Statement ignored
340/52 PLS-00302: component 'CURRENCY_CONVERSION_RATE' must be declared
341/4 PL/SQL: Statement ignored
341/52 PLS-00302: component 'CURRENCY_CONVERSION_TYPE' must be declared
2898/9 PL/SQL: SQL Statement ignored
3096/64 PLS-00302: component 'CURRENCY_CONVERSION_DATE' must be declared
3097/64 PLS-00302: component 'CURRENCY_CONVERSION_TYPE' must be declared
3098/16 PL/SQL: ORA-00904:
  "ZX_PTNR_SRVC_INTGRTN_PKG"."G_TAX_LINES_RESULT_TBL"."CURRENCY_CON
  VERSION_RATE": invalid identifier

3098/64 PLS-00302: component 'CURRENCY_CONVERSION_RATE' must be declared
3098/64 PLS-00302: component 'CURRENCY_CONVERSION_RATE' must be declared

 

EXPECTED BEHAVIOR
-----------------------
Package must be Compiled successfully

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