3 Replies Latest reply on May 19, 2014 2:35 AM by Coco Zhao-Oracle

    Automatically creating PO from requisitions

    Feeling Happy

      Hi All,

       

      May i know is there any functionality either in iprocurement/Purchasing to create PO from requisitions through Auto create functionality.

        • 1. Re: Automatically creating PO from requisitions
          Hemant Garg

          Hi ,

           

          you can create the Purchase Order automatically for the catalog item which are sourced through the BPA , for these BPA you can either create automatic release or standard purchase order through requisition approval workflow .

           

          The CREATEPO Workflow Attribute "Is Automatic Creation Allowed?" is set to 'Y'. This allows the workflow to automatically create a Purchase Order from a Requisition.

           

          Steps:

          1.  Enter Workflow Builder

          2.  Connect to the Database

          3.  Open the PO Create Documents workflow (poxwfatc.wft)

          4.  Expand the navigator under PO Create Documents

          5.  Expand the navigator under Attributes
          6.  Locate attribute Is Automatic Creation Allowed?

          7.  Double click Is Automatic Creation Allowed?
          8.  In the Navigation Control Properties set Default Value Y



          Regards,

          Hemant

          • 2. Re: Automatically creating PO from requisitions
            Hemant Garg

            Hi ,

             

            Did you try the above approach . pls let me know if it resolves your problem.

             

            Thanks

            Hemant

            • 3. Re: Automatically creating PO from requisitions
              Coco Zhao-Oracle

              Hi,

               

              To update those attributes, you may also use following scripts instead of via workflow builder.

               

              update WF_ITEM_ATTRIBUTES
              set text_default = 'Y'
              where item_type = 'CREATEPO'
              and name = 'AUTO_APPROVE_DOC'


              update WF_ITEM_ATTRIBUTES
              set text_default = 'Y'
              where item_type = 'CREATEPO'
              and name = 'AUTOCREATE_DOC'


              Regards

              Coco