Skip to Main Content

Java Development Tools

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Need to approve/reject the request from outlook mail

saikowshikFeb 1 2020 — edited Feb 3 2020

Hi All, I have a new requirement with regard to mail approval and the Scenario is as below:

1) User will create a request through Oracle PAAS ADF application(Jdeveloper 12.1.3.0).

2)The request details are saved into the database table with Status as "PendingAtSupervisor".

3) Through database Package sends a mail to the "Supervisor" to approve the above request details (Triggering package whenever data insert/update on table).

4)The "Supervisor" who receives the mail, logs into the ADF application and then Approves through a specific Approval screen .Database is therefore updated to next level approver status as "PendingAtAGO".

Here -- I require a slight modification , wherein I nned to provide a Approve/Reject option in the Mail.This will reduce the need to Login to the application in order to approve the same. So, the supervisor can approve the user request in the mail by clicking Approve/Reject button.

Any suggestions for the above requirement.

Regards,

Pavan

Comments
Post Details
Added on Feb 1 2020
4 comments
385 views