Solution : https://service.sap.com/sap/support/notes/1636936 (SAP Service marketplace login required)
Summary :
This SAP Note discusses a discrepancy in query results attributed to Oracle bug 12827166, affecting versions 11.2.0.1 through 11.2.0.3 with star transformation enabled. The bug leads to incorrect results when the query execution plan includes an index range predicate with equality in start or stop keys. The resolution involves applying specific patches detailed for supported Oracle versions (except 11.2.0.1, no longer supported) in SAP Bundle Patches / Oracle patch collections dated after 201110 or 201112. A temporary workaround to disable star transformation is suggested, though it may degrade performance in BW queries. It is recommended to upgrade and apply the appropriate patches to mitigate this issue.
Key words :
enabledstar_transformation_enabled = true orstar_transformation_enabled = temp_disable execution plan, sap bundle patch / windows patch collection, alter system set star_transformation_enabled = false scope=, sap bundle patches / oracle patch collections, stop key solution oracle bug 12827166, prerequisites oracle bug 12827166 - wrong result, query returns wrong results, terms wrong results, query differs depending, index range predicate
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 |