You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Is data purged from fa_fusion_soainfra WF% tables?

edited Nov 26, 2020 3:42PM in Payables, Payments & Cash Management 3 comments

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')

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!