Core Concurrent Processing - EBS (MOSC)

MOSC Banner

Long running SQL query begin fndcp_tmsrv.read_message in Database

edited May 14, 2014 12:00PM in Core Concurrent Processing - EBS (MOSC) 2 commentsAnswered

Hi,

begin fndcp_tmsrv.read_message(:ec, :to, :typ, :enddt, :rid, :retid, :nl, :nc, :dl, :secgrp, :usr, :rspap, :rsp, :log, :app, :prg, :argc, :orgt, :orgid, :a1,  :a2,  :a3,  :a4,  :a5,  :a6,  :a7,  :a8,  :a9,  :a10, :a11, :a12, :a13, :a14, :a15, :a16, :a17, :a18, :a19, :a20); end;

Insert into FND_CRM_HISTORY (requests_examined, requests_standby,  requests_released, requests_returned,  work_start, work_end) (Select :exmd, :stby, :rels, :retd, Decode(Work_Start,NULL, Sysdate, Work_Start), Decode(Work_End,NULL, Sysdate, Work_End) from Fnd_Concurrent_Queues WHERE Application_ID     = 0   AND Concurrent_Queue_Id = 4)

begin   WF_EVENT.setNavigationParams  (  p_agentName => :1, p_navigationThreshold => :2  );  WF_EVENT.LISTEN  (  p_agent_name =>

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center