29 May 2008

Oracle Apps: Concurrent Program Status SQL

Run the following SQL to know the status of a Concurrent Program

SELECT Request_id, Program, request_date, status_code,r.COMPLETION_TEXT
FROM apps.FND_CONC_REQ_SUMMARY_V r WHERE PROGRAM ='UL Discoverer EUL Initial Data Load'
ORDER BY REQUEST_DATE DESC

No comments: