GL posting after upgrade 12c of databse not taking 11G nested loop hint USE_NL (VW_NSO_1, B) thus
12C: Nested loop hint not taken , as provide by GL posting code -> taking hash join semi
update /*+ ORDERED INDEX (B, GL_BALANCES_N1) USE_NL (VW_NSO_1, +*/ GL_BALANCES B
set (period_net_dr,period_net_cr,quarter_to_date_dr,quarter_to_date_cr,proje
...
oject_to_date_cr_beq,translated_flag,last_update_date,last_updated_by)=(
select /*+ INDEX(PI1, GL_POSTING_INTERIM_N1) +*/
-----------------------------------------------------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes |TempSpc| Cost (%CPU)| Time |
-----------------------------------------------------------------------------------------------------------------------
| 0 | UPDATE STATEMENT | | | | | 10M(100)| |
| 1 | UPDATE | GL_BALANCES | | | | | |
|* 2 | HASH JOIN SEMI | | 1 | 193 | 1346M| 10M (1)| 00:07:03 |
| 3 | TABLE ACCESS BY INDEX ROWID BATCHED| GL_BALANCES | 11M| 1209M| | 10M (1)| 00:07:01 |