隨手筆記

查詢Conncurrent LOG FILE位置

SELECT FCPP.CONCURRENT_REQUEST_ID REQ_ID,
       FCP.NODE_NAME,
       FCP.LOGFILE_NAME
  FROM FND_CONC_PP_ACTIONS      FCPP,
       FND_CONCURRENT_PROCESSES FCP
 WHERE FCPP.PROCESSOR_ID = FCP.CONCURRENT_PROCESS_ID
   AND FCPP.ACTION_TYPE = 6
   AND FCPP.CONCURRENT_REQUEST_ID = 12271664;

查詢Conncurrent View Output FILE位置
select *
  from FND_CONCURRENT_REQUESTS  
 WHERE REQUEST_ID = 23849363;