OPP Issue

Posted by raja on
URL: http://erman-arslan-s-oracle-forum.114.s1.nabble.com/OPP-Issue-tp5085.html

Hi Erman

When i check the OPP status from backend database, it shows that the OPP is running wih actual and target as 4 and 4. But at the same time when checked from front end, it shows that actual 0 and target 4. Any clue why this might be happening


The query used to check from backend is:
SELECT b.user_concurrent_queue_name "Concurrent Manager", b.target_node "Node", a.running_processes "Actual Processes", a.max_processes "Target Processes"
    FROM apps.fnd_concurrent_queues a, apps.fnd_concurrent_queues_vl b
   WHERE a.concurrent_queue_id = b.concurrent_queue_id
    AND a.concurrent_queue_name = 'FNDCPOPP' ;