Seeded scripts in FND_TOP/sql as of R12 (12.1.3)

Seeded scripts in FND_TOP/sql as of 12.1.3

Ø  afcmcreq Prints the log file name of managers that can run a given request

Ø  afcmstat Displays all defined managers and shows current status of manager processes

Ø  afimchk Checks to see if the concurrent manager monitor is actually running

Ø  afimlock Monitors locks that the ICM and CRM are waiting for.

Ø  afimpmon Sets the PMON methd based on the argument (for CONC_PMON_METHOD)

Ø  afimveri Resets the concurrent manager monitor

Ø  afrqpend Lists all the pending/normal requetss

Ø  afrqrun Lists all running, terminating, and paused requests

Ø  afrqscm Prints the log file names of managers that can run a given request

Ø  afrqstat Summarizes concurrent request execution since a particular date

Ø  afrquwait Selects all the Pending request with status Q

+++++++++++++++++++++++++++++++++

1. Use the following query to find out your concurrent managers details.

SQL> SELECT distinct C.USER_CONCURRENT_QUEUE_NAME, C.MAX_PROCESSES, C.RUNNING_PROCESSES, C.TARGET_PROCESSES, C.NODE_NAME, C.NODE_NAME2

FROM APPLSYS.FND_CONCURRENT_QUEUE_CONTENT A, APPLSYS.FND_CONCURRENT_PROGRAMS B, APPS.FND_CONCURRENT_QUEUES_VL C

WHERE type_id = b.concurrent_program_id and c.concurrent_queue_id = a.concurrent_queue_id;

++++++++++++++++++++++++++++++++++

How to Re-create Concurrent Manager Views (Doc ID 146786.1)

For UNIX & Windows NT servers enter from the command prompt:

  FNDLIBR  FND  FNDCPBWV  apps/<passwd>  SYSADMIN  'System Administrator'   SYSADMIN

Note:

This will generate the FNDCPBWV view including the new rules in the view.

- Then bounce the concurrent managers.

For VMS servers enter from the command prompt:

  FNDLIBR  "FND"  "FNDCPBWV"  apps/<passwd>  "SYSADMIN"  "System Administrator"    "SYSADMIN"

++++++++++++++++++++++++++

1304305.1,213021.1 & 232116.1

++++++++++++++++++++++++++