top of page

Tags

Archive

Creating PO Using Webservice - Oracle Purchasing Cloud

When you are integrating between system once should have good knowledge on various SOAP Web services available in ERP cloud. This article Explains the SOAP web service way of creating PO's in the purchasing cloud.


WSDL : https://POD-abcdef .fa.us6.oraclecloud.com:443/fscmService/PurchaseOrderServiceV2


Sample Request Pay Load:


<?xml version="1.0" encoding="UTF-8"?><soapenv:Envelopexmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"xmlns:draf="http://xmlns.oracle.com/apps/prc/po/editDocument/flex/draftPurchaseOrderDistribution/"xmlns:draf1="http://xmlns.oracle.com/apps/prc/po/editDocument/flex/draftPurchasingDocumentSchedule/"xmlns:draf2="http://xmlns.oracle.com/apps/prc/po/editDocument/flex/draftPurchasingDocumentLine/"xmlns:draf3="http://xmlns.oracle.com/apps/prc/po/editDocument/flex/draftPurchasingDocumentHeader/"xmlns:pjc="http://xmlns.oracle.com/apps/prc/po/commonPo/flex/PJCPoDraftDistribution/"xmlns:pur="http://xmlns.oracle.com/apps/prc/po/editDocument/purchaseOrderServiceV2/"xmlns:typ="http://xmlns.oracle.com/apps/prc/po/editDocument/purchaseOrderServiceV2/types/"><soapenv:Header /><soapenv:Body><typ:createPurchaseOrder><typ:createOrderEntry><pur:OrderNumber>19DREGULAR BUSINESS UNITDEPPPO123</pur:OrderNumber><pur:Action>ADD</pur:Action><pur:SoldToLegalEntity>Test Company</pur:SoldToLegalEntity><pur:DeliverToLocationCode>Test Company</pur:DeliverToLocationCode><pur:DefaultShipToLocationCode>Test Company</pur:DefaultShipToLocationCode><pur:ShipToLocationCode>Test Company</pur:ShipToLocationCode><pur:BillToLocationCode>Test Company</pur:BillToLocationCode><pur:InterfaceSourceCode>JDBCUI</pur:InterfaceSourceCode><pur:ApprovalActionCode>BYPASS</pur:ApprovalActionCode><pur:ProcurementBusinessUnit>REGULAR BUSINESS UNIT</pur:ProcurementBusinessUnit><pur:RequisitioningBusinessUnit>REGULAR BUSINESS UNIT</pur:RequisitioningBusinessUnit><pur:BillToBusinessUnit>REGULAR BUSINESS UNIT</pur:BillToBusinessUnit><pur:CurrencyCode>USD</pur:CurrencyCode><pur:SupplierSiteCode>Site-1</pur:SupplierSiteCode><pur:ChangeOrderDescription>MX Rev Num: 0 -</pur:ChangeOrderDescription><pur:SupplierCommunicationMethod>None</pur:SupplierCommunicationMethod><pur:CategoryName>REGULAR BUSINESS UNIT MAX DEFAULT CATEGORY</pur:CategoryName><pur:UnitOfMeasure>Each</pur:UnitOfMeasure><pur:ShipToOrganizationCode>REGULAR BUSINESS UNIT_REG_INV_ORG</pur:ShipToOrganizationCode><pur:ScheduleNumber>1</pur:ScheduleNumber><pur:DestinationTypeCode>EXPENSE</pur:DestinationTypeCode><pur:DocumentDescription>BUY SMALL PALLETS - FOR STOCK</pur:DocumentDescription><pur:BuyerName>Satyavolu, Sandeep</pur:BuyerName><pur:PaymentTerms>Net 45</pur:PaymentTerms><pur:Supplier>DUMBA COMPANY</pur:Supplier><pur:PurchaseOrderEntryLine><!--Zero or more repetitions:--><pur:LineType>Goods</pur:LineType><pur:LineNumber>1</pur:LineNumber><pur:CategoryCode>SAM_MAX_DEFAULT_CATEGORY</pur:CategoryCode><pur:CategoryName>SAM MAX DEFAULT CATEGORY</pur:CategoryName><!--<pur:ItemNumber>201100</pur:ItemNumber>--><pur:ItemDescription>201100 PALLET, WOODEN (17 PER STACK), SIZE- 48 INCH X 40 INCH</pur:ItemDescription><!--<pur:MaximoShipToLocation>DLC</pur:MaximoShipToLocation>--><pur:OverReceiptTolerancePercent>0.0</pur:OverReceiptTolerancePercent><pur:LineDescription>19ctest</pur:LineDescription><pur:Quantity>374.0</pur:Quantity><pur:UnitOfMeasure>Each</pur:UnitOfMeasure><pur:Price>14.75</pur:Price><pur:NeedByDate>2019-10-11</pur:NeedByDate><pur:PromisedDate>2019-10-31</pur:PromisedDate><pur:PurchaseOrderEntrySchedule><pur:ShipToOrganizationId>300000009542139</pur:ShipToOrganizationId><!--Optional:--><pur:ShipToLocationId>300000002721081</pur:ShipToLocationId><!--<pur:ShipToOrganizationCode>?</pur:ShipToOrganizationCode>--><pur:PurchaseOrderEntryDistribution><pur:DistributionNumber>1</pur:DistributionNumber><pur:Quantity>374.0</pur:Quantity><pur:OrderedAmount>5516.5</pur:OrderedAmount><pur:RequesterName>Satyavolu, Sandeep</pur:RequesterName><pur:POChargeAccount>101-003-20-0-1230001-0000000000-000-0000000-0000</pur:POChargeAccount></pur:PurchaseOrderEntryDistribution></pur:PurchaseOrderEntrySchedule></pur:PurchaseOrderEntryLine></typ:createOrderEntry></typ:createPurchaseOrder></soapenv:Body></soapenv:Envelope>

Sampl response Payload :



<?xml version="1.0" encoding="UTF-8"?><env:Envelopexmlns:env="http://schemas.xmlsoap.org/soap/envelope/"xmlns:typ="http://xmlns.oracle.com/apps/prc/po/editDocument/purchaseOrderServiceV2/types/"xmlns:wsa="http://www.w3.org/2005/08/addressing"><env:Header><wsa:Action>http://xmlns.oracle.com/apps/prc/po/editDocument/purchaseOrderServiceV2//PurchaseOrderService/createPurchaseOrderResponse</wsa:Action><wsa:MessageID>urn:uuid:4ea46917-35d8-4e65-a6ef-bf2c8bd7e134</wsa:MessageID></env:Header><env:Body><ns0:createPurchaseOrderResponsexmlns:ns0="http://xmlns.oracle.com/apps/prc/po/editDocument/purchaseOrderServiceV2/types/"><ns1:resultxmlns:ns1="http://xmlns.oracle.com/apps/prc/po/editDocument/purchaseOrderServiceV2/types/"xmlns:ns0="http://xmlns.oracle.com/apps/prc/po/editDocument/purchaseOrderServiceV2/"xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"xsi:type="ns0:RequestResults"><ns0:POHeaderId>300000075887</ns0:POHeaderId><ns0:OrderNumber>19DSAMDEPPPO123</ns0:OrderNumber><ns0:SoldToLegalEntityId>3000002621035</ns0:SoldToLegalEntityId><ns0:ChangeOrderNumberxsi:nil="true" /><ns0:RequestStatus>SUCCESS</ns0:RequestStatus></ns1:result></ns0:createPurchaseOrderResponse></env:Body></env:Envelope>


Hope this Article Helps !



20 views0 comments

Recent Posts

See All

When transactions are entered, Dynamic Insertion in Oracle Fusion General Ledger (GL) allows an organisation to automatically insert extra segments or values in the GL chart of accounts. This feature

Oracle Fusion Segment Security The General Ledger (GL) feature enables an organisation to restrict access to data in the GL depending on certain parts of the GL chart of accounts. A segment is a subse

Oracle Fusion General Ledger (GL) Cross-Validation Rules are used to assure the integrity and accuracy of data entered into the GL module. They are used to ensure that data submitted in the GL is cons

Other Posts you may Interested