Is data purged from fa_fusion_soainfra WF% tables?
Content
Hi,
I am writing some SQL to extract details about AP Payment Approvals using the SQL from this Cloud Customer Connect post.
Sample SQL:
SELECT bpm_task.approvers
, to_char(bpm_task.CREATEDDATE, 'DD-MON-YYYY HH24:MI:SS') task_created
, bpm_task.creator task_created_by
, to_char(bpm_task.ENDDATE, 'DD-MON-YYYY HH24:MI:SS') task_end
, bpm_hist.ACQUIREDBY
, bpm_hist.FROMUSER
, bpm_hist.ASSIGNEESDISPLAYNAME
, bpm_hist.FROMUSERDISPLAYNAME
, bpm_hist.UPDATEDBYDISPLAYNAME
, bpm_hist.tasknumber
, bpm_hist.taskdefinitionname
, bpm_hist.title approval_title
, bpm_hist.state STATUS
, bpm_hist.outcome OUTCOME
FROM fa_fusion_soainfra.wftask_view bpm_task
JOIN fa_fusion_soainfra.wftaskhistory bpm_hist ON bpm_task.taskid = bpm_hist.taskid
WHERE 1 = 1
AND bpm_hist.taskdefinitionname = 'PaymentApproval'
-- AND bpm_hist.outcome = 'APPROVE'
AND bpm_hist.state = 'OUTCOME_UPDATED'
AND bpm_task.approvers NOT IN ('workflowsystem')
1