DATA IS NOT MIGRATED FROM 11I TO R12.1.3 , POST UPGRADE (Doc ID 2045435.1)

Last updated on JANUARY 10, 2016

Applies to:

Oracle Financials for India - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, India GL Localizations

Observed that post upgrade activity , unable to view the data for Service , TDS regime registrations and in addition organization addition information details.
The same details does exists in 11i.

ERROR
-----------------------
1.$JA_TOP/patch/115/sql/jaiinstchktabcr.sql, ORA-00955: name is already used by an existing object
2. ORA-01400: cannot insert NULL into ("JA"."JAI_AP_TDS_PAYMENTS"."BANK_NAME")

3. Adworker which runs the script jai_ren_tab.sql failed

STEPS
-----------------------
This is an Upgrade activity from 11i to R12.1.3 where unable to view the data post the R12 upgrade.


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, the respective 11i data across regimes and other important details are not migrated to R12.

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