Solution : https://service.sap.com/sap/support/notes/1621425 (SAP Service marketplace login required)
Summary :
This SAP Note diagnoses an issue where a query returns incorrect results due to a known Oracle bug (12971242), affecting Oracle versions 11.2.0.1-11.2.0.3 with star transformation and temporary tables. The problem arises when the specific column, integral to the WHERE condition and TEMP TABLE TRANSFORMATION, displays identical erroneous values across all rows instead of varying entries. Oracle patches and workarounds, such as altering optimizer settings or disabling star transformations, are recommended, though an upgrade to patched Oracle versions is preferable for resolution.
Key words :
sap bundle patch / windows patch collection, sap bundle patches / oracle patch collections, alter system set star_transformation_enabled = temp_disable scope=, /bi0/scustomer index fast full scan, temp table transformation solution oracle bug 12971242, prerequisites oracle bug12971242 - wrong results, /bi0/pcustomer~0 table access full, sys_temp_0fd9d6749_e22fbe table access full, sys_temp_0fd9d6749_e22fbe table access full, cost based star transformation
Related Notes :
| 1656659 | GI 11.2.0: Patches / Patch Collections for 11.2.0.3 |
| 1631931 | Oracle 11.2.0: Patches / Patch collections for 11.2.0.3 |
| 1597736 | GI 11.2.0: Patches / Patch Collections for 11.2.0.2 |
| 1591389 | Exadata 11.2.0: Patches for 11.2.0.2 |
| 1503709 | Oracle 11.2.0: Patches / Patch collections for 11.2.0.2 |
| 1431798 | Oracle 11.2.0: Database Parameter Settings |