I am working with Oracle APEX 23.2.0 and have a wizard form with 16 forms and a 2-level approval process.
- When a requestor submits a scheme for approval, it moves to Level 1 and then to Level 2.
- Once approved, the scheme status changes to "Approved", and editing is restricted.
- However, we have an edit option that allows modifications even after approval. After editing, the scheme must be resubmitted for approval.
Requirement:
When an approved scheme is edited and resubmitted, the approver should see only the updated fields across all 16 forms.
Question:
Is it possible to track and display only the modified fields in the Oracle APEX approval hierarchy? What would be the best approach to implement this?
Looking forward to suggestions and best practices.