Query to find Pending Requests Against Output Post Processor
Himanshu
APPS R12.2 Architecture
,
funoracleapps
,
Oracle Apps
,
R12.2
,
R12.2 Installation
,
scripts
1 comment
Below query can be used to find the pending requests again OPP.
Query:
select REQUEST_ID,PHASE_CODE,STATUS_CODE from fnd_concurrent_requests
where request_id in (
select concurrent_request_id
from fnd_conc_pp_actions
where action_type >= 6
and processor_id is null)
and PHASE_CODE!='C';
Query:
select REQUEST_ID,PHASE_CODE,STATUS_CODE from fnd_concurrent_requests
where request_id in (
select concurrent_request_id
from fnd_conc_pp_actions
where action_type >= 6
and processor_id is null)
and PHASE_CODE!='C';
Subscribe to:
Post Comments
(
Atom
)
I love all the posts, I really enjoyed, I would like more information about this, because it is very nice.
ReplyDelete