Oracle Vertex Tax Link Patch Error (Doc ID 2909256.1)

Last updated on NOVEMBER 14, 2022

Applies to:

Goal

Having an error message when applying the patch for Vertex Tax Link for R12.2
Errors for PACKAGE BODY P_VERTEX_ETAX_PKG:

LINE/COL ERROR
-------- -----------------------------------------------------------------
1524/9 PL/SQL: SQL Statement ignored
1972/18 PL/SQL: ORA-00984: column not allowed here
1972/18 PLS-00302: component 'JURISDICTION_ID' must be declared
2019/9 PL/SQL: SQL Statement ignored
2291/20 PL/SQL: ORA-00984: column not allowed here
2291/20 PLS-00302: component 'JURISDICTION_ID' must be declared
2742/9 PL/SQL: SQL Statement ignored
3190/16 PL/SQL: ORA-00984: column not allowed here
3190/16 PLS-00302: component 'JURISDICTION_ID' must be declared
3247/9 PL/SQL: SQL Statement ignored
3519/18 PL/SQL: ORA-00984: column not allowed here

LINE/COL ERROR
-------- -----------------------------------------------------------------
3519/18 PLS-00302: component 'JURISDICTION_ID' must be declared
7857/10 PL/SQL: Statement ignored
7857/29 PLS-00302: component 'PHYS_ORIGIN_LATITUDE' must be declared
7858/10 PL/SQL: Statement ignored
7858/29 PLS-00302: component 'PHYS_ORIGIN_LONGITUDE' must be declared
7859/10 PL/SQL: Statement ignored
7859/29 PLS-00302: component 'ADMIN_ORIGIN_LATITUDE' must be declared
7860/10 PL/SQL: Statement ignored
7860/29 PLS-00302: component 'ADMIN_ORIGIN_LONGITUDE' must be declared
Executing p_vertex_util.plb ...
 

Solution

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