R12: PRC: Launch Update Project Performance Data Completes but the table PJI_PRG_BATCH appears to be stuck with CURR_REQUEST_STATUS as Running. (Doc ID 2288541.1)

Last updated on JULY 20, 2017

Applies to:

Oracle Project Planning and Control - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

When the process PRC: Launch Update Project Performance data is started, the table PJI_PRG_BATCH appears to be stuck with CURR_REQUEST_STATUS as Running.  This is the same issue as described in Bug 24737179 - PRC: UPDATE PROJECT PERFORMANCE DATA COMPLETED BUT RUNNING IN PJI_PRG_BATCH. The issue is resolved by cancelling the Launch parent process, but a code fix is needed to stop the issue from happening in the future. 

WORKAROUNDS
===========
In this case they cancelled the process

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms