R12: Upgrade to R12 Caused Canadian Tax Groups Not to Calculate Tax (Doc ID 2005023.1)

Last updated on MAY 13, 2015

Applies to:

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

Symptoms

On : 12.1.1 version, Tax Set Up

You have upgraded from 11i to R12 and the Canadian Tax Groups are not calculating Tax.

Steps to Reproduce:
Create a transaction for Canada
Populate the Tax Classification Code
The Tax Regime, Status, and Tax Rate are not populated automatically.

On Diagnostics apps check the following error appears :

Errors for PACKAGE BODY ZX_MIGRATE_TAX_DEFAULT_HIER

PL/SQL: ORA-02289: sequence does not exist
PL/SQL: SQL Statement ignored
PL/SQL: ORA-02289: sequence does not exist
PL/SQL: SQL Statement ignored
PL/SQL: ORA-02289: sequence does not exist
PL/SQL: SQL Statement ignored
PL/SQL: ORA-02289: sequence does not exist
PL/SQL: SQL Statement ignored
PL/SQL: ORA-02289: sequence does not exist
PL/SQL: SQL Statement ignored

Files versions and the tax regime:
zxmigrateutilb.pls         120.15.12010000.3              
zxmigrateutils.pls          120.5
zxtaxdefmigb.pls          120.124.12010000.20
zxtaxhiermigb.pls         120.40.12010000.9

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