Thursday, July 21, 2016

Concurrent program is running more than once in same timing

--Concurrent program is running more than once in same timing

SELECT prog.user_concurrent_program_name,
actual_start_date,
argument_text,
requested_by,
RESPONSIBILITY_ID,
COUNT(*)
FROM apps.fnd_concurrent_requests xx,apps.fnd_concurrent_programs_tl prog
WHERE status_code = 'C' and prog.concurrent_program_id =xx.concurrent_program_id
AND prog.language='US' AND TRUNC (actual_start_date) >= TRUNC (SYSDATE)-40
AND application_id=20003
AND prog.user_concurrent_program_name='Amway Inventory Adjustment Interface'
GROUP BY prog.user_concurrent_program_name,
actual_start_date,
argument_text,
requested_by,
RESPONSIBILITY_ID
HAVING COUNT(*)  > 1

No comments:

Post a Comment

Drilldown from GL to Inventory Transactions, Inv to gl Link Query R12,Inventory to General ledger links, r12 ,Inv to gl drill down

Drilldown from GL to Inventory Transactions, Inv to gl Link Query R12,Inventory to General ledger links, r12 ,Inv to gl drill down Link bet...