Total Pageviews

Concurrent Managers

How do you shutdown concurrent managers using CONCSUB ?

CONCSUB apps/fnd SYSADMIN 'System Administrator' sysadmin WAIT=Y CONCURRENT FND ABORT

How do you stop/start/verify MFG environment concurrent managers ?

Login to Oracle Applications.
Switch to System Administrator Responsibility.
Navigate to Administer Concurrent Manager Screen.
Concurrent->
Manager->
Administer->

Query the below managers.
1) MRP Manager.
2) INV Remote Procedure Manager.
3) Inventory Manager.
If any one of the above managers is inactive, activate them.
Make sure that Actual=Target. If actual <>
Transactions->
Interface Managers->
Make sure that status for material transaction manager is “Active”. If the status says “Inactive” Launch "Material Transaction Manager" from Inventory setup module. This will schedule a concurrent program called Process transactions interface (INCTCM) every 5 minutes. This manager (concurrent program) reads records from MTL_TRANSACTIONS_INTERFACE validates them and moves the successful transactions onto MTL_MATERIAL_TRANSACTIONS_TEMP, and submits Inventory Transaction Worker (INCTCW) which then processes these records through inventory. This process consists of data derivation, validation, and transfer of records from MTL_TRANSCTIONS_INTERFACE, MTL_TRANSACTIONS_LOTS_INTERFACE and MTL_SERIAL_NUMBERS_INTERFACE into their respective TEMP (temporary) tables from where the transactions processor processes them. The worker rows should be 200(seeded setting), which means each time manager launches the worker, the worker processes 200 records. This seeded setting is more than adequate for current transaction volume. Leave the process interval as 5 minutes which is also a seeded setting.

Make sure that “Cost Manager” status is “Active”. If the status says “Inactive” Launch "Cost Manager" from Inventory setup module. This schedules a concurrent program called Cost Manager (CMCTCM) every 5 minutes. Cost transaction manager costs material transactions in Oracle Inventory and Oracle Work in Process in the background.

Make sure that “Move transaction Manager” status is “Active”. If the status says “Inactive” Launch "Move transaction Manager" from Inventory setup module. This will schedule a concurrent program called WIP Move Transactions Manager (WICTMS) every 5 minutes. The WIP move transaction manager processes move transactions in Oracle Work in Process and move transactions you import from devices such as portable bar code readers or your custom data entry forms using the Open Move Transaction Interface.


Login to Oracle Applications.
Switch to Material Planner Responsibility.
Navigate to Planning Manager Screen.
Setup->
Planning Manager->

If the planning manager is down start the Planning Manager. Choose the Schedule this for every 4 hours. The Planning Manager runs under the MRP Manager, which has only one process (the Planning Manager). The Planning Manager kicks off a Planning Manager worker which runs under the Standard Manager.

What are the profiles which controls the concurrent managers for MFG modules ?

Login to Oracle Applications
Navigate to System Profile Values Screen.
Profiles->
System->
Query the profile name TP: INV Transaction processing.
Make sure that value=Background Processing.
With this option, Oracle Inventory processes transactions on a periodic basis via the Inventory Transaction Manager. With this option Returns control immediately to users. This is the recommended setting.

MRP: Planning Manager Max Workers=0MRP: Planning Manager Batch Size=10000
MRP: Interface Table History Days=5
MRP: Snapshot Workers=0
MRP: Use Direct Load Option=No


How do you enable de-bugging for inventory manager ?

Login to Oracle Applications
Navigate to System Profile Values Screen.
Profiles->
System->
Query the profile name
INV:Debug Trace = Yes (Default value is No)
INV:Debug file= file_name_with_fullpath (Default value is null)
INV:Debug Level= 10 (Default value is 0)



How do I register concurrent program sql ?

Using FND_PROGRAM API