Patch:3485155: Script paupg103.sql hangs while applying merged patch 11i.PJ_PF.M With Other M Rollup
Hi Team,
Enter value for 1
3 pa_fin_plan_types_b fino,
4 pa_fin_plan_types_b finwp
5 where NVL(pfo.fin_plan_type_id,-99)
6 NOT IN (fino.fin_plan_type_id,finwp.fin_plan_type_id)
7 and pfo.fin_plan_type_id is not null
8 and pfo.use_planning_rates_flag is null
9 and fino.fin_plan_type_code = 'ORG_FORECAST'
Issue:
--------
While apply merge patch script paupg103 is hanged
sqlplus -s APPS/***** @/app01/appl/gendappl/pa/11.5.0/patch/115/sql/paupg103.sql Enter value for 1
Checked the output of the below query:
SQL> select count(*)
2 from pa_proj_fp_options pfo,3 pa_fin_plan_types_b fino,
4 pa_fin_plan_types_b finwp
5 where NVL(pfo.fin_plan_type_id,-99)
6 NOT IN (fino.fin_plan_type_id,finwp.fin_plan_type_id)
7 and pfo.fin_plan_type_id is not null
8 and pfo.use_planning_rates_flag is null
9 and fino.fin_plan_type_code = 'ORG_FORECAST'
Tagged:
0