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

How to improve blog performance

Improving the performance of a blog can involve a variety of strategies, including optimizing the website's technical infrastructure, im...