Solution : https://service.sap.com/sap/support/notes/727310 (SAP Service marketplace login required)
Key words :
/3 cbo ods 3559212 wrong values results kko merge 9, runningsqlplus sapr3/<password> alter session set, apply thebug fix mentioned, 5 kko merge fix, star_transformation features due, bw specific problem, itcan affect sap, setting _new_initial_join_orders = false, insert _new_initial_join_orders = falseinto, wrong results
Related Notes :
| 760257 | Composite SAP note Oracle 9.2.0.5 and incorrect data |
| 755629 | KKO merge fix for Oracle 9.2.0.5 |
| 721332 | 9204: MJC in temporary table causes ORA-1652 (PARALLEL hint) |
| 721331 | 9204: MERGE JOIN CARTESIAN IN TEMP TABLE- STAR and FACT Hint |
| 706132 | Composite SAP Note: Problems with Oracle 9i |
| 658322 | Composite SAP Note: Incorrect resulting set with Oracle |
| 577365 | |
| 354080 | Note collection for Oracle performance problems |