Solution : https://service.sap.com/sap/support/notes/760302 (SAP Service marketplace login required)
Key words :
_new_initial_join_orders = false affected oracle releases, star_transformation_enabled = temp_disable affected oracle releases, exit affected oracle releases, sqlplus sapr3/<password> select, level 1' affected oracle releases, alter index <index_name> parallel, affected oracle releases, sqlplus sapr3/<password>, oracle database version 9, fact table views
Related Notes :
| 760301 | |
| 760257 | Composite SAP note Oracle 9.2.0.5 and incorrect data |
| 610445 | Merge fix for Oracle 9.2.0.3 |
| 595757 | Composite note Oracle 9.2.0.2 & incor. data (star transf.) |
| 594513 | Oracle 9.2.0: Result not sorted in spite of ORDER BY |
| 587196 | |
| 577373 | Wrong values with star_transformation_enabled (8174 & 920) |
| 561961 | Deactivating/activating usage of fact table view |
| 539921 | Current patch set for Oracle 9.2.0 |