Do we need a DB patch for slow update to PJI_FP_XBS_ACCUM_F
We use Oracle Projects in a RAC Linux Exadata environment. At month end close time we have some WorkFlow programs that get blocking locks from other programs updating the PJI_FP_XBS_ACCUM_F table. Not sure if it could be related to Doc. 30618056. We do not get an error message returned but we do see long durations for this update statement that begins like this:
UPDATE /*+ ordered use_nl(rl) rowid(rl) PJI_FP_XBS_ACCUM_F … as executed from PJI_FM_PLAN_MAINT_T_PVT package and update_fp_rows proceedure.