4 Replies Latest reply on Mar 3, 2016 8:07 AM by 885148

    Purchasing API

    885148

      Deal All,

      I have a requirement to  -


      (a) Bulk update  some PO data (like Need By Date, promise Date etc).

      (b) Auto-increment the revision.

      (c) Auto-approve the PO.

       

      Could you please help me with points b and c as how I am auto increment the PO Revision after the updates are done and how I can auto approve the PO (the new approver should be same as last approver).

       

       

      Thanks,

      Amit

        • 1. Re: Purchasing API
          Jignesh Makwana

          Hi Amit,

           

          You can try with Data Loader software ?

           

          Regards,

          Jignesh

          • 2. Re: Purchasing API
            885148

            Hi Jignesh,

             

            This will be a new application which will give the users the facility to mass update the PO dates (and attachments).

            Hence we cant use data loader.

            Basically the proposed design is as under -

            • User uploads the data from an excel into a OAF page.
            • From this excel the data is inserted into a staging table.
            • Then there will be an Oracle concurrent program (custom) which will read data from the staging table and update into standard tables along with revision increment and approval.

             

            Thanks,

            Amit

            • 3. Re: Purchasing API
              Vanha.L-Oracle

              Hello Amit,

               

              You should be able to update existing PO and automatically increase revision. This is standard revision control for PO document.

               

              This is per standard documentation:

              "For the Update action code, the document revision number is increased every time

              the unit Price, item Description, UOM, or Expiration Date is updated, or when a

              new line is added (unless Archive on Approval is chosen in the Document Types

              window and PO: Archive Catalog on Approval is set to No)."

               

              To approve the update, you can pass LAUNCH_APPROVALS_FLAG = 'Y' for the API.

               

              The following notes have some good examples and details of the API:

               

              Vision Demo - How To Use the PO Change API To Update Existing Purchase Orders (Doc ID 1078842.1)

              How to use PO_CHANGE_API1_S.update_po to Change Three Lines (Doc ID 1077455.1) -- look at last example for lauch_approval_flag

               

              Regards,

              Vanha

              1 person found this helpful
              • 4. Re: Purchasing API
                885148

                Hi Vanha,

                 

                One question.

                Is it possible to use the PO_CHANGE_API1_S API for updating the revision only?

                I mean without updating any date/price etc.

                 

                 

                Thanks,

                Amit