My Oracle Support Banner

File csictex8.sql Fails When Upgrading Counters From R11i To R12.1.1 (Doc ID 1322604.1)

Last updated on MAY 19, 2020

Applies to:

Oracle Installed Base - Version 12.1.1 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.1 version,

After applying <Patch 11841096>, when attempting to upgrade counters from release 11i to release 12.1.1 the following error occurs.

ERROR
-----------------------
sqlplus -s APPS/*****
/u10/ar121/apps/apps_st/appl/csi/12.0.0/patch/115/sql/csictex8.sql &un_csi
DECLARE
*
ERROR at line 1:
ORA-01400: cannot insert NULL into
 ("CSI"."CSI_TRANSACTIONS"."TRANSACTION_TYPE_ID")
ORA-06512: at line 30

The solution mentioned in the folllowing article did not resolve the issue:
While Running The R12 Upgrade (U6394500.Drv) The Worker For Csictex8.Sql Fails. [ID 810583.1]

STEPS
-----------------------
1. Apply <Patch 11841096>
2. Apply <Patch 6678700> to upgrade from R11i to R12.1.1

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, upgrade cannot be completed successfully

Changes

 

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
References


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