| target node in fnd_concurrent_queues_vl different [message #583113] |
Fri, 26 April 2013 00:04 |
 |
GoGreen
Messages: 28
Registered: February 2012
Location: Java Island
|
Junior Member |
|
|
Hi,
DBA in my office has been install oracle finance and source from cloning.
what cause the target node in table fnd_concurrent_queues_vl different ?
how to correction a target node in the table fnd_concurrent_queues_vl from FIN.PROD.COM to ORA-ORA-FIN-TEST, as should all of the target nodes must ORA-FIN-TEST.
SELECT concurrent_queue_name, user_concurrent_queue_name,
target_node
FROM fnd_concurrent_queues_vl
WHERE enabled_flag = 'Y'
ORDER BY DECODE (application_id, 0, DECODE (concurrent_queue_id, 1, 1, 4, 2)),
SIGN (max_processes) DESC,
concurrent_queue_name,
application_id
for example :
CONCURRENT_QUEUE_NAME,USER_CONCURRENT_QUEUE_NAME, TARGET_NODE
IEXCONMGR-------------Collections Manager----------------------ORA-FIN-TEST
MRPMGR----------------MRP Manager-----------------------------ORA-FIN-TEST
MWA001----------------MWA001---------------------------------ORA-FIN.PROD.COM
OKCCONCMGR-----------Contracts Core Concurrent Manager-------ORA-FIN-TEST
WFALSNRSVC-----------Workflow Agent Listener Service-----------ORA-FIN.PROD.COM
WFMLRSVC-------------Workflow Mailer Service--------------------ORA-FIN.PROD.COM
WFWSSVC--------------Workflow Document Web Services Service---ORA-FIN.PROD.COM
please help me, because the application could not runing normal.
Regards
Go Green
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
