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 FEBRUARY 05, 2019
Applies to:
Oracle Applications DBA - Version 12.2 and laterInformation 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
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 |