Create Requisition

This section provides and example of how to create a new requisition using the Purchase Request Service Version 1 SOAP service.

Required Privileges

Before attempting to access or create payloads, make sure you have the required privileges.

Manage Purchase Request by Web Service
Search Purchase Request by Web Service

Operations

There a several operations available for the Purchase Request Service Version 1 SOAP service:

getPurchaseRequest
controlPurchaseRequest
changePurchaseRequest
submitImportRequisition
populateInterfaceTable
createRequisition

In this example, we’ll use the createRequisition operation.

The createRequisition operation writes attributes into a requisition interface table and then starts the requisition import process to create a requisition. The requisition import process then performs the source and validation logic.

Example Payload


<soapenv:Envelope
xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"
xmlns:typ="http://xmlns.oracle.com/apps/prc/po/editDocument/purchaseRequestService/types/"
xmlns:pur="http://xmlns.oracle.com/apps/prc/po/editDocument/purchaseRequestService/">
<soapenv:Header></soapenv:Header>
<soapenv:Body>
<typ:createRequisition>
<typ:interfaceSourceCode>DOO</typ:interfaceSourceCode>
<typ:requisitioningBUId>300000001548368</typ:requisitioningBUId>
<typ:groupBy>SUPPLIER</typ:groupBy>
<typ:initiateApprovalAfterRequisitionImport>N</typ:initiateApprovalAfterRequisitionImport>
<typ:errorProcessingLevel>ALL</typ:errorProcessingLevel>
<typ:purchaseRequestPayload>
<pur:ApproverEmail>x.y@oracle.com</pur:ApproverEmail>
<pur:Description>Requisition Created by X with Web Service</pur:Description>
<pur:DocumentStatusCode>APPROVED</pur:DocumentStatusCode>
<pur:InterfaceHeaderKey>REQ_IHK_NSK_22</pur:InterfaceHeaderKey>
<pur:PreparerEmail>x.y@oracle.com</pur:PreparerEmail>
<pur:RequisitioningBUId>300000001548368</pur:RequisitioningBUId>
<pur:ExternallyManagedFlag>False</pur:ExternallyManagedFlag>
<pur:PurchaseRequestInputReqLineInterface>
<pur:CurrencyCode>USD</pur:CurrencyCode>
<pur:CategoryId>300000011704231</pur:CategoryId>
<pur:DeliverToLocationId>300000013028216</pur:DeliverToLocationId>
<pur:DeliverToOrganizationId>300000001548399</pur:DeliverToOrganizationId>
<pur:DeliverToLocationId>300000017774778</pur:DeliverToLocationId>
<pur:DestinationSubinventory />
<pur:DestinationTypeCode>EXPENSE</pur:DestinationTypeCode>
<pur:InterfaceLineKey>REQ_ILK_NSK_22</pur:InterfaceLineKey>
<pur:ItemDescription>TEST Item Description</pur:ItemDescription>
<pur:LineType>Goods</pur:LineType>
<pur:ProcurementBUName>DOO Fusion CSPS Business Unit 1</pur:ProcurementBUName>
<pur:Quantity unitCode="">10</pur:Quantity>
<pur:Price currencyCode="USD">9</pur:Price>
<pur:RequesterEmail>x.y@oracle.com</pur:RequesterEmail>
<pur:SupplierId>300000017513435</pur:SupplierId>
<pur:SupplierSiteId>300000017513448</pur:SupplierSiteId>
<pur:UnitOfMeasureCode>zzy</pur:UnitOfMeasureCode>
<pur:RequestedDeliveryDate>2018-11-30</pur:RequestedDeliveryDate>
<pur:PurchaseRequestInputReqDistInterface >
<pur:ChargeAccountId>10000</pur:ChargeAccountId>
<pur:DistributionAmount currencyCode="USD">90</pur:DistributionAmount>
<pur:DistributionQuantity unitCode="zzy">10</pur:DistributionQuantity>
<pur:Percent>100</pur:Percent>
</pur:PurchaseRequestInputReqDistInterface>
</pur:PurchaseRequestInputReqLineInterface>
</typ:purchaseRequestPayload>
</typ:createRequisition>
</soapenv:Body>
</soapenv:Envelope>

Example Response

<env:Envelope
xmlns:typ="http://xmlns.oracle.com/apps/prc/po/editDocument/purchaseRequestService/types/"
xmlns:env="http://schemas.xmlsoap.org/soap/envelope/"
xmlns:wsa="http://www.w3.org/2005/08/addressing">
<env:Header>
<wsa:Action>http://xmlns.oracle.com/apps/prc/po/editDocument/purchaseRequestService//PurchaseRequestService/createRequisitionResponse</wsa:Action>
<wsa:MessageID>urn:uuid:3dfb8f9a-c89b-4b7a-ba29-16b699f23c66</wsa:MessageID>
</env:Header>
<env:Body>
<typ:createRequisitionResponse>
<typ:result xsi:type="ns0:PurchaseRequestOutputReqHeaderInterface"
xmlns:ns0="http://xmlns.oracle.com/apps/prc/po/editDocument/purchaseRequestService/"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<ns0:RequisitionHeaderId>80014</ns0:RequisitionHeaderId>
<ns0:RequisitionNumber>534</ns0:RequisitionNumber>
<ns0:InterfaceHeaderKey>REQ_IHK_NSK_22</ns0:InterfaceHeaderKey>
<ns0:RequisitionStatus>APPROVED</ns0:RequisitionStatus>
<ns0:Status>SUCCESS</ns0:Status>
<ns0:PurchaseRequestOutputReqLineInterface
xmlns:ns1="http://xmlns.oracle.com/adf/svc/types/">
<ns0:RequisitionHeaderId>80014</ns0:RequisitionHeaderId>
<ns0:RequisitionLineId>84028</ns0:RequisitionLineId>
<ns0:RequisitionLine>1</ns0:RequisitionLine>
<ns0:InterfaceLineKey>REQ_ILK_NSK_22</ns0:InterfaceLineKey>
<ns0:Status>SUCCESS</ns0:Status>
<ns0:BuyerId>300000022033660</ns0:BuyerId>
<ns0:BuyerName> YZ </ns0:BuyerName>
<ns0:BuyerEmail xsi:nil="true" />
<ns0:Quantity unitCode="zzy" 
xmlns:tns="http://xmlns.oracle.com/adf/svc/errors/">10</ns0:Quantity>
<ns0:UnitOfMeasureCode>zzy</ns0:UnitOfMeasureCode>
<ns0:PurchaseRequestOutputReqDistInterface >
<ns0:RequisitionLineId>84028</ns0:RequisitionLineId>
<ns0:RequisitionDistributionId>80014</ns0:RequisitionDistributionId>
<ns0:RequisitionDistributionNumber>1</ns0:RequisitionDistributionNumber>
<ns0:InterfaceDistributionKey xsi:nil="true"/>
<ns0:Status>SUCCESS</ns0:Status>
</ns0:PurchaseRequestOutputReqDistInterface>
</ns0:PurchaseRequestOutputReqLineInterface>
</typ:result>
</typ:createRequisitionResponse>
</env:Body>
</env:Envelope>

Based on the example payload, here’s how the new requisition would look in the Purchase Requisitions work area.

New Purchase Requisition Created by Web Service