Workflow
Overview:
The
Payment Approval Workflow (Payment Approval WF) is designed to automate
and streamline the process of reviewing and approving payment requests within
the system. It ensures that all submitted payment requests follow a structured
approval hierarchy, improving accuracy, accountability, and processing efficiency.
The
workflow begins when a payment request is submitted and moves through multiple
validation and approval stages. The system first checks the status of the
request, after which it is routed to the assigned approver. Based on the
approver’s decision, the workflow evaluates conditions such as whether the
request is approved and if the current approver is the final authority.
If
the request is approved and requires additional approvals, it is forwarded to
the next approver in the hierarchy. Once the final approval is completed, the
system updates the status accordingly. If the request is rejected or not
submitted properly, the workflow terminates with the appropriate status.
This
workflow ensures:
- Controlled
approval flow with defined decision points
- Clear tracking
of request status at each stage
- Reduction of
manual intervention and errors
- Improved
transparency and auditability of payment processes
·
Go to Share Component
·
Open task Definition under Workflow and Automation.
·
Create task Definition
·
Fill all information (Name, Static_id , Subject ,Priority and all
mandatory fields)
select
(select USER_NAME from XXEXP_APPROVALS where seq > nvl(LAST_SEQ,0) order by
seq
fetch
first 1 row only) user_name,(select SEQ from XXEXP_APPROVALS
where seq > nvl(LAST_SEQ,0) order by seq
fetch
first 1 row only) CUR_SEQ, e.*
FROM
TMEXP_PAYMENT_TBL e
where
ID = :P_TRX_ID
·
Add Participant
·
Add parameter
· Add Action
·
Choose Approve or Reject action while create
·
Choose action Type (Execute code, Send Email, Send Push notification, Server-Side
geocoding)
· Choose on Event from dropdown (Complete, Delegate Update Comment, Update Priority. Update Parameter, Release, cancel, Request Information, Submit Information, Before Expire Expire)
·
Add Query in code section
·
Repeat same step with rejection
Step2: Go I Share Component: Workflow and Automation
· Create Workflow
·
Create and configure workflow
Step 3: Start Workflow
·
Once User send request for approval from UI
·
The status on UI get change to submitted
·
Once Status get submitted workflow get start
Step 3: After start workflow it check status
· If not submitted
·
Make condition false
· Map activity to End
· If Status is Submitted
·
Make condition True
· Map Activity
Step
4: Add Human task
·
If Submitted
·
Make Condition True
· Map the actviy
·
Send Next approver
·
Make condition False
· Map activity to approver
Step5: isApproved
· Check status of approval if it is No
Step
6: isFinalApprover
·
If yes make condition True
· Otherwise send for next approver make condition false
Step
7: Update Status
·
If Approved update Status
·
If Rejected update status
update TMEXP_PAYMENT_TBL e
set status='APPROVED',
STATUS_DATE=SYSDATE, APPROVED_DATE=SYSDATE, APPROVED_BY=:APP_USER
where id=:P_TRX_ID;
Comments
Post a Comment