Concurrent FND scripts & Related Common SQL Decodes

Concurrent FND scripts

$FND_TOP/sql 下有很多现成Concurrent Program相关脚本

afimchk.sql Tells the status of the ICM

afcmstat.sql Lists active manager processes

afrqrun.sql Lists all the running, waiting and Terminating requests（列出所有正在Running的脚本）

afrqwait.sql Lists requests that are constrained and waiting for the ICM to release them.

afrqscm.sql Prints log file name of managers that can run a given request.

afcmcreq.sql Prints the log file name of the manager that processed the request

afrqstat.sql Summary of completed concurrent requests grouped by completion status and execution type..

afimlock.sql Lists locks that the ICM is waiting to get

afcmrrq.sql Lists managers that currently are running a request

Note:ICM means Internal Concurrent Manager

运行方法

1.登陆Sqlplus,eg. sqlplus apps/apps@instance

2.Sqlplus下，执行

SQL> @$FND_TOP/sql/afimchk.sql

Common SQL Decodes - FCR

phase_code & status_code & execution_method_code的意义

Common SQL Decodes - FCR

DECODE(fcr.phase_code,
'C', 'Completed',
'I', 'Inactive',
'P', 'Pending',
'R', 'Running',
fcr.phase_code)
...
FROM fnd_concurrent_requests fcr

DECODE(fcr.status_code,
'A', 'Waiting', 'B', 'Resuming',
'C', 'Normal', 'D', 'Cancelled',
'E', 'Errored', 'F', 'Scheduled',
'G', 'Warning', 'H', 'On Hold',
'I', 'Normal', 'M', 'No Manager',
'Q', 'Standby', 'R', 'Normal',
'S', 'Suspended', 'T', 'Terminating',
'U', 'Disabled', 'W', 'Paused',
'X', 'Terminated', 'Z', 'Waiting',
fcr.status_code)
...
FROM fnd_concurrent_requests fcr

Common SQL Decodes - FCPG
DECODE (fcpg.execution_method_code,
'A', 'Spawned',
'F', 'Flexsql',
'H', 'Host',
'I', 'PL/SQL',
'L', 'SQL*Loader',
'P', 'Oracle Rpt',
'Q', 'SQL*Plus',
'R', 'SQL*Report',
'S', 'Immediate',
'X', 'FlexRpt',
fcpg.execution_method_code),
...
FROM fnd_concurrent_programs fcpg

转载请注明出处：http://blog.csdn.net/pan_tian/article/details/7702645

======EOF======