E-Business Tax (MOSC)

MOSC Banner

Issue during upgrade of 12.1.1 relates to WBiz-Tax ZX_EXEMPTIONS_U2

edited May 24, 2010 2:28AM in E-Business Tax (MOSC) 2 commentsAnswered
 We are in a process upgrade to release 12.1.1 from 11.5.10.2 and having data issue with related to new 12.1.1 eBiz tax. The issue is while upgrade is running the following sql script and coming out with error message:

Error are

*****************************************************************************

sqlplus -s APPS/***** @/appl3/oracle/DFIN/apps/apps_st/appl/zx/12.0.0/patch/115/sql/zxexceptmig1.sql &un_ar &batchsize 4 8

DECLARE

*

ERROR at line 1:

ORA-00001: unique constraint (ZX.ZX_EXCEPTIONS_U2) violated

ORA-06512: at line 48

*******************************************************************************

sqlplus -s APPS/***** @/appl3/oracle/DFIN/apps/apps_st/appl/zx/12.0.0/patch/115/sql/zxexemptmig1.sql &un_ar &batchsize 6 8

DECLARE

*

ERROR at line 1:

ORA-01400: cannot insert NULL into ("ZX"."ZX_EXCEPTIONS"."TAX_REGIME_CODE")

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center