Tech Trainings

Requisition Approval Workfow – Customization – Status History- Table Details – Oracle Fusion ERP

February 20, 2025 by admin

--Requisition Headers
select 
 prha.REQUISITION_HEADER_ID
,prha.REQUISITION_NUMBER
,prha.DESCRIPTION
,prha.DOCUMENT_STATUS
,prha.SUBMISSION_DATE
,prha.APPROVED_DATE
,prha.APPROVAL_INSTANCE_ID
,prha.CREATED_BY
from POR_REQUISITION_HEADERS_ALL   prha 

order by prha.creation_date desc

--Requisition Action History
select 
 prha.REQUISITION_HEADER_ID ,
prha.REQUISITION_NUMBER ,
 pah.OBJECT_TYPE_CODE,
 pah.OBJECT_ID,
 pah.ASSIGNMENT_DATE ,
 pah.PO_VERSION_ID,
 pah.ACTION_CODE , 
 pah.IDENTIFICATION_KEY,
 pah.CREATED_BY  
from PO_ACTION_HISTORY pah  , POR_REQUISITION_HEADERS_ALL prha 
where 1=1
and OBJECT_TYPE_CODE ='REQ' 
and prha.REQUISITION_HEADER_ID = pah.object_id 

order by pah.creation_date desc

--BPM WF History



SELECT 
wf.APPROVERS                  ,
wf.ASSIGNEES                  ,
wf.ASSIGNEESDISPLAYNAME       ,
wf.CREATOR                    ,
wf.PROCESSNAME                ,
wf.CREATEDDATE                ,
wf.FROMUSER                   ,
wf.OUTCOME                    ,
wf.STATE                      ,
wf.WORKFLOWPATTERN            ,
wf.IDENTIFICATIONKEY          ,
wf.TASKDEFINITIONNAME         ,
wf.PARTICIPANTNAME

FROM  fa_fusion_soainfra.wftaskhistory   wf 
WHERE 1=1
AND   PROCESSNAME ='ApproveReq' 
AND IDENTIFICATIONKEY  = NVL ( :P_IDENTIFICATIONKEY,IDENTIFICATIONKEY)

order by createddate desc

Comments |0|