Oracle APEX Bill Approval Workflow
Budget: ₹1,500 – ₹12,500 INR
I need an Oracle APEX application that lets employees submit bills and automatically routes each request to the employee’s reporting manager for a quick review before it moves on to the next approval level. Approval authority will be driven strictly by amount-based limits, so the workflow must read the bill value, compare it to the configured thresholds, and decide whether it stops with the manager, escalates to a higher level, or is returned to the requester.
Email notifications are essential at every stage—submission confirmation, manager review, escalation, final approval or rejection—so users always know the bill’s status without having to log in. I’d also like a searchable audit trail that shows who reviewed or approved and when, plus a simple dashboard summarising pending, approved and rejected bills.
Please build the front-end in standard Oracle APEX components and keep the back-end logic in PL/SQL packages so we can extend the limits table and approval hierarchy later. A short hand-off session and clear deployment script will complete the job.
Email notifications are essential at every stage—submission confirmation, manager review, escalation, final approval or rejection—so users always know the bill’s status without having to log in. I’d also like a searchable audit trail that shows who reviewed or approved and when, plus a simple dashboard summarising pending, approved and rejected bills.
Please build the front-end in standard Oracle APEX components and keep the back-end logic in PL/SQL packages so we can extend the limits table and approval hierarchy later. A short hand-off session and clear deployment script will complete the job.