An Orphaned Concurrent Job

Issue: An Orphaned concurrent Job is running since 16-DEC-2010 14:28:21

ebsdbprd1 > @jobs

REQ_ID STA PID        SID  TIME     U_REC USER_DES PGM_NAME

--------- --- -------- ----- ----- --------- -------- ------------------------------------------------

677944 R/R 1208422        #####         0 matgrp   CUS_BANK_RECONCILE_SUMMARY

Findings:

Name: CUS_BANK_RECONCILE_SUMMARY

Request Id: 677944

Application: CUS Application

It was submitted by user: MATGRP

Using responsibility: Cash Management Superuser, Agra

It was submitted on: 16-DEC-10 14:28:21

Arguments (5): 81, 1-OCT-10, 31-OCT-10, 10001,

This request did not finish processing due to an unrecoverable error, and the concurrent manager that was running this request is no longer active.

The Internal Concurrent Manager will mark this request as having completed with an error.

During PCP configuration this job might became unrecoverable. The log file of the request does not exists.

Logfile: /apps_PROD/inst/apps/ebsdbprd_ifebapp1/logs/appl/conc/log/l677944.req

Output file: /apps_PROD/inst/apps/ebsdbprd_ifebapp1/logs/appl/conc/out/o677944.out

ebsdbprd1 > select REQUEST_ID,REQUEST_DATE,PHASE_CODE,STATUS_CODE,REQUESTED_START_DATE,ACTUAL_START_DATE from fnd_concurrent_requests

where REQUEST_ID=677944;

REQUEST_ID REQUEST_D P S REQUESTED ACTUAL_ST

---------- --------- - - --------- ---------

677944 16-DEC-10 R R 16-DEC-10 16-DEC-10

Solution:

update fnd_concurrent_requests set Phase_code='C',status_code='E' where REQUEST_ID=677944;

commit;