Using oracle apex 26.1.0
Users:
1.initiator
2.approver1
3.approver2(final (approver)
Requirement:
For APPROVAL state:
1.initiator à raise request àinitial status ‘submitted’.
2.approver1 à opens request,sees details in the task details page with read-only form.
If everything is OK à approves à moves to approver2(status ‘appr1_approved’).
3.same for approver2 àstatus ‘appr2_approved’.
For REJECT state:
1.initiator à raise request àinitial status ‘submitted’.
2.approver1 à opens request,sees details in the task details page with read-only form.
Suggest changes by adding comments à rejects à goes back to initiator for resubmit
3.initiator changes data (form is editable-only for initiator when status is resubmitted).
4.then approver1 checks the details and clicks approve.
5.same for approver2 as well.
Task details ‘read-only’ form requirements:
when initiator creates a request,in task details page,a form is created(read-only with data)
1.initiator à creates request à status-‘submitted’àform-read-only
2.approver1 à approves à status-‘appr1_approved’àform-read-only
3.approver2 à approves à status-‘appr2_approved’àform-read-only
4.approver1 à rejects à status-‘appr1_rejected’àsends back to initiatoràform-editable(only for initiator)
Table: product_development
Columns(request id-‘P00001’-format,
Requested by,
Date of request,
Product type(lov),product name,length,width,height,thickness,weight,priority(lov),mfg type(lov),attachments(image/file/video)).
Understanding:
1.is this achievable using oracle apex workflow with version 26.1.0
2.explain from where to start?
3.i created a application with task definitions,workflow,task details page,form,unified task list(initiated by me),and for approval,its working,but for rejection-struck here,don’t know what to do-tried everything-no result.
4.explain how resubmit process works,i tried to look for resubmit option when creating Task Definitions Actions-complete-approve/reject:two options are available.
5.point 3-is this correct approach or not?explain.
6.provide the solution.