Create PO Change Order in Oracle Cloud – Add Project Info To Existing PO Line Using SOAP request

This blog describes the sample request for creating Change Order in Oracle Cloud for the existing Purchase Order. This Change Order is to add project details in PO line and distribution level.

Before moving to the request, to access purchase orders through web services it requires below specific privileges to be assigned to the user account from which the request is called. Otherwise the request will end up in “Access Denied” error.

Manage Purchase Order by Web Service privilege is required for create/change/cancel operations
Search Purchase Order by Web Service privilege is required for get/find operations

In this example, a new role with these two privileges was created to access purchase orders.

Below is the sample SOAP payload to create Change Order.

Request URL: https://xxx.oraclecloud.com/fscmService/PurchaseOrderServiceV2?WSDL

Method: Post

Content Type: text/xml (If the request is called from postman it has to be added separately in parameter section. Uncheck the default one)

Sample Payload:

<soap:Envelope xmlns:soap=”http://schemas.xmlsoap.org/soap/envelope/”>
<soap:Body xmlns:ns1=”http://xmlns.oracle.com/apps/prc/po/editDocument/purchaseOrderServiceV2/types/”>
<ns1:changePurchaseOrder>
<ns1:changeOrderEntry xmlns:ns2=”http://xmlns.oracle.com/apps/prc/po/editDocument/purchaseOrderServiceV2/”>
     <ns2:OrderNumber>100001</ns2:OrderNumber>
     <ns2:SoldToLegalEntityId>30000000000213</ns2:SoldToLegalEntityId>
     <ns2:ChangeOrderDescription>Add Project Info</ns2:ChangeOrderDescription>
     <ns2:PurchaseOrderEntryLine>
         <ns2:LineNumber>1</ns2:LineNumber>
         <ns2:PurchaseOrderEntrySchedule>
             <ns2:ScheduleNumber>1</ns2:ScheduleNumber>
             <ns2:PurchaseOrderEntryDistribution>
<ns2:DistributionNumber>1</ns2:DistributionNumber>
                 <ns2:Action>CHANGE</ns2:Action>
                 <ns2:DistributionProjectFlexfield xmlns:ns3=”http://xmlns.oracle.com/apps/prc/po/commonPo/flex/PJCPoDraftDistribution/”>
                   <ns3:_PROJECT_ID>3000000000212</ns3:_PROJECT_ID>
                   <ns3:_TASK_ID>1000000123324532</ns3:_TASK_ID>
                <ns3:_EXPENDITURE_ITEM_DATE>2019-10-27</ns3:_EXPENDITURE_ITEM_DATE>
                   <ns3:_EXPENDITURE_TYPE_ID>300000001234123</ns3:_EXPENDITURE_TYPE_ID>
                   <ns3:_ORGANIZATION_ID>30000000134123434</ns3:_ORGANIZATION_ID>
                 </ns2:DistributionProjectFlexfield>
             </ns2:PurchaseOrderEntryDistribution>
         </ns2:PurchaseOrderEntrySchedule>
</ns2:PurchaseOrderEntryLine>
</ns1:changeOrderEntry>
</ns1:changePurchaseOrder>
</soap:Body>
</soap:Envelope>

Anand Kumar