6678700: 12: Linux x86-64 : pjiup007.sql running from long time
pjiup007.sql running from long time while running upgrade driver 6678700
Problem Description
---------------------------------------------------
sqlplus -s APPS/***** @/apps/R12/apps/apps_st/appl/pji/12.0.0/patch/115/sql/pjiup007.sql &un_pji
when checked from back end below update sql is running from long time
SQL_TEXT
--------------------------------------------------------------------------------
UPDATE PJI_FP_XBS_ACCUM_F FACT SET FACT.PLAN_TYPE_CODE= 'A', FACT.LAST_UPDATE_DA
TE=:B2 , FACT.LAST_UPDATED_BY =:B1 WHERE FACT.PLAN_VERSION_ID=-1 AND FACT.PLAN_T
YPE_CODE IS NULL
SQL> select count(*) from PJI_FP_XBS_ACCUM_F;
COUNT(*)
----------
173387215
Problem Description
---------------------------------------------------
sqlplus -s APPS/***** @/apps/R12/apps/apps_st/appl/pji/12.0.0/patch/115/sql/pjiup007.sql &un_pji
when checked from back end below update sql is running from long time
SQL_TEXT
--------------------------------------------------------------------------------
UPDATE PJI_FP_XBS_ACCUM_F FACT SET FACT.PLAN_TYPE_CODE= 'A', FACT.LAST_UPDATE_DA
TE=:B2 , FACT.LAST_UPDATED_BY =:B1 WHERE FACT.PLAN_VERSION_ID=-1 AND FACT.PLAN_T
YPE_CODE IS NULL
SQL> select count(*) from PJI_FP_XBS_ACCUM_F;
COUNT(*)
----------
173387215
Tagged:
0