Oracle Workflow A Guide to For Your Action Workflow

YouTube video

In this article, we will discuss the For Your Action (FYA) workflow in Oracle Workflow. As you may know, there are two types of workflows in Oracle Notifications: For Your Information (FYI) and For Your Action (FYA) notifications. The FYI notifications do not require any response and do not have any buttons for approval or rejection. On the other hand, the FYA notifications have extra buttons for the approval process, such as “Approve” or “Reject.”

Let’s consider a simple scenario where two employees are involved: a supervisor and an employee. The employee sends a notification to the supervisor, who can then approve or reject the notification. Based on the supervisor’s response, a notification will be sent to the employee.

To design this workflow, we need to follow a simple workflow design process. Here are the steps:

  1. Start by designing the major business logic in the workflow process.
  2. Create a start activity and a supervisor notification.
  3. Add buttons for approval or rejection in the supervisor notification.
  4. Based on the approval or rejection, send the appropriate notification to the employee.
  5. Finally, end the workflow.

The workflow should look like this:
– Start Activity
– Supervisor Notification (with approve/reject buttons)
– If supervisor approves, send an approval notification to the employee.
– If supervisor rejects, send a rejection notification to the employee.
– End Activity

In this workflow, we have two activities: the start activity and the end activity. We also require three notifications: the supervisor notification, the approval notification, and the rejection notification. Additionally, we need two temporary attributes: one for the supervisor and one for the employee.

To design the workflow in Oracle Workflow, follow these steps:
1. Open Oracle Workflow and create a new workflow file.
2. Save the file in the appropriate location.
3. Create a new process and name it “FYA Process.”
4. Add a start activity and an end activity to the process.
5. Create three messages: the approval notification message, the approved message, and the rejected message.
6. Create three notifications: the approval notification, the approved notification, and the rejected notification.
7. Drag and drop the necessary attributes into the messages and notifications.
8. Create a lookup type for the approval/rejection options.
9. Assign the lookup type to the approval notification and the approval message.
10. Connect the activities and notifications as shown in the workflow design.
11. Save and validate the workflow.

Once the workflow is designed, you can invoke it by following these steps:
1. Make a note of the item name and process name.
2. Check the properties of the workflow and ensure there are no issues.
3. Save the file in the database.
4. Invoke the workflow to send the initial notification to the supervisor.
5. Based on the supervisor’s response, the appropriate notification will be sent to the employee.

In real-time scenarios, you may need to invoke some business logic along with the notifications. For example, you may need to call a PL/SQL API or a procedure when the notification is approved or rejected. To do this, you need to create the necessary PL/SQL program and ensure it has the correct signature, following Oracle’s standards.

By following these guidelines, you can successfully design and invoke a For Your Action (FYA) workflow in Oracle Workflow. Remember to thoroughly test your workflow and ensure that all notifications and actions are working as expected. With Oracle Workflow, you can streamline your business processes and improve efficiency.

In conclusion, the For Your Action (FYA) workflow in Oracle Workflow allows for approval or rejection of notifications with the help of extra buttons. By designing the workflow with the necessary activities, notifications, and attributes, and by invoking the workflow appropriately, you can automate and streamline your business processes effectively.