How to find Total Purge Eligible Records in FND_CONCURRENT_REQUESTS
Execute below Script as apps user
select p.USER_CONCURRENT_PROGRAM_NAME, count(r.request_id)
FROM fnd_concurrent_requests r, FND_CONCURRENT_PROGRAMS_TL p
WHERE r.CONCURRENT_PROGRAM_ID = p.CONCURRENT_PROGRAM_ID
and r.phase_code='C'
group by p.USER_CONCURRENT_PROGRAM_NAME
order by count(r.request_id) desc;
Execute below Script as apps user
select p.USER_CONCURRENT_PROGRAM_NAME, count(r.request_id)
FROM fnd_concurrent_requests r, FND_CONCURRENT_PROGRAMS_TL p
WHERE r.CONCURRENT_PROGRAM_ID = p.CONCURRENT_PROGRAM_ID
and r.phase_code='C'
group by p.USER_CONCURRENT_PROGRAM_NAME
order by count(r.request_id) desc;
|
Concurrent Program Name
|
Count of Requests
|
|
Create
Accounting
|
22,587
|
|
Check
Event Alert
|
22,556
|
|
Journal
Import
|
11,393
|
|
Transfer
Journal Entries to GL
|
9,543
|
|
Invoice
Approval Workflow
|
9,392
|
|
Workflow
Background Process
|
9,117
|