Home » Applications » Oracle Fusion Apps & E-Business Suite » target node in fnd_concurrent_queues_vl different (Oracle Finance , version : 11.5.0, OS, Oracle9i Enterprise Edition Release 9.2.0.6.0 - 64bit Production (TNS for Solaris: Version 9.2.0.6.0 ))
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
Previous Topic: oracle balance sheet report
Next Topic: Oracle apps 12.1.3 functional knowledge
Goto Forum:
  


Current Time: Thu Mar 28 14:30:06 CDT 2024