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

 Step 1:  Create task Definition

·       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

Popular posts from this blog

Implementing Authentication and Authorization in Oracle APEX

Mastering Shared Components in Oracle APEX

Designing a Scalable Database Architecture for Oracle APEX Applications