Duplicated concurrent requests
This week I noticed that some (maybe all) scheduled concurrent requests were duplicated.
For example, a request schedule at 07-mar-2006 apears twice in concurrent requests form.
When querying fnd_concurrent_requests I found that the duplicated concurrent requests can be identified by root_request_id attribute:
select * from fnd_concurrent_requests where phase_code<>'C' and root_request_id in
(
select root_request_id from fnd_concurrent_requests where phase_code<>'C' and root_request_id is not NULL
group by root_request_id having count(*)> 1
)
Someone could give me a direction?
Thanks in advance