5 Replies Latest reply: Dec 10, 2012 9:28 AM by JasonBatzlaff RSS

    Customize the standard workflow

    Sam1004
      Hi All,

      My requirement is:
      Whenever the total amount of a Sales Order exceeds certain limit, then it should keep the SO on hold, then it will raise a business event to send information to a different system(SOA in our case). SOA will derive the approver's name and will release the hold. Then workflow will progress to next step.

      Pls put forward your valuable suggestions for the same.

      Thanks in advance !!!
      Sambit
        • 1. Re: Customize the standard workflow
          AutoInstall
          I guess you can think of customize the Order Header workflow.
          Adding new nodes in between Book - Eligible and Book would help.
          • 2. Re: Customize the standard workflow
            Sam1004
            Can you pls explain in detail ?
            what extra steps need to be incorporated to achieve the desired result ?
            • 3. Re: Customize the standard workflow
              AutoInstall
              First, add a function to carry out the checking, find out the approver, and apply hold if needed.

              And assume this function returns Yes (apply hold) or No (no need to hold).

              "No" should connect to the original Book node so that the status will be changed to Book directly.

              For "Yes", it should first link to a Notification, which tells the approver that a SO is required for his approval. The result should be either Approve or Reject. When Approve, connect to another new function that is release the hold.
              • 4. Re: Customize the standard workflow
                978902
                Hi,

                This Requirement can be catered using forms personalizations ,

                Create a condition in personalization if total_amount > limit then call a builtin which will call a pl/Sql procedure,
                inside this procedure you can call api oe_holds_pub which will put the order on hold, and you can raise a custom business event to inform SOA taht business event has been raised.

                Thanks,
                Pritam k
                • 5. Re: Customize the standard workflow
                  JasonBatzlaff
                  Forms personalization could be an option, but beware, that these extensions would only be applicable for users of the Sales Order form. I run into many cases where Forms Personalization would be the simpler method of extension. However, if there is an unspoken requirement that the same extension also functions for on-line users, EDI, Order Import, Process Order API, etc, then the use of Workflow might be more appropriate.

                  Thanks,
                  Jason