12.2 E-Business Suite Upgrade Insert Statement Fails Causing Data Corruption (Lost Data) In Tables FND_FLEX_VALUES And FND_FLEX_VALUES_TL After Applying AD/TXK Delta 8 And The 12.2.6 Upgrade Patch (Doc ID 2225204.1)

Last updated on JANUARY 25, 2017

Applies to:

Oracle Applications DBA - Version 12.2 and later
Information in this document applies to any platform.

Symptoms

E-Business Suite 12.2.6 Applications DBA, Upgrade related issues

 

 

Only partial data appears in the Flexfield tables FND_FLEX_VALUES & FND_FLEX_VALUES_TL after upgrade to AD/TXK Delta 8 with RUP 12.2.6.

 

For example, the following select document the changes which can occur to the data in tables FND_FLEX_VALUES & FND_FLEX_VALUES_TL:

TARGET Instance(12.2.6)
====================

SQL> select zd_edition_name, count(1) from applsys.fnd_flex_values_tl group by zd_edition_name;

ZD_EDITION_NAME COUNT(1)
------------------------------ ----------
SET1 8058

SQL> select zd_edition_name, count(1) from applsys.fnd_flex_values group by zd_edition_name;

ZD_EDITION_NAME COUNT(1)
------------------------------ ----------
SET1 29675

 

 

Source Instance (12.2.4)
===================

SQL> select zd_edition_name, count(1) from applsys.fnd_flex_values_tl group by zd_edition_name;

ZD_EDITION_NAME COUNT(1)
------------------------------ ----------
V_20160813_0238 5018094

SQL> select zd_edition_name, count(1) from applsys.fnd_flex_values group by zd_edition_name;

ZD_EDITION_NAME COUNT(1)
------------------------------ ----------
V_20160813_0238 295182

  The above selects confirm some sort of data corruption has occurred.

Changes

Upgrade from AD/TXK Delta 7 on 12.2.4 to AD/TXK Delta 8 with RUP 12.2.6.

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