REST API for Oracle Fusion Cloud Procurement

Update Requisitions

You may want to update or correct information in a requisition header, or line and distribution after a requisition has been created. You can update either of these only as long as the requisition status is Incomplete, that is, if the requisition has not been submitted.

Let's discuss these scenarios briefly.

Update a requisition header.
Update a requisition line and distribution.

Update Description in a Requisition Header

To update a requisition header:

Identify the RequisitionHeaderId of your requisition.
- An alternative is to perform a GET operation by specifying the Requisition Number and Requisitioning BU Name as query parameters in the request. The response will contain the RequisitionHeaderId.
GET
```
/fscmRestApi/resources/version/purchaseRequisitions?q=Requisition=Requisition Number;RequisitioningBU=Requisitioning BU Name
```
Decide on the text to be updated in the requisition description.
Perform a PATCH operation on the example URL that follows by replacing the RequisitionHeaderId from step 1, providing the following details in the request body:
```
"Description": "Requisition for new hire training"
```

Example URL

Use this resource URL format:

PATCH

/fscmRestApi/resources/version/purchaseRequisitions/RequisitionHeaderId

cURL Command

curl -u username:password -X PATCH -H "Content-Type:application/vnd.vision.adf.resourceitem+json" -d 'request payload' 
"https://servername/fscmRestApi/resources/version/purchaseRequisitions/RequisitionHeaderId"

Example Request

Here's an example of the request body in JSON format:

{ 

"Description": "Requisition for new hire training"
}

Example Response

Here's an example of the response body in JSON format:

{
    "RequisitionHeaderId": 300100546219759,
    "Requisition": "10505802",
    "RequisitioningBUId": 204,
    "RequisitioningBU": "Vision Operations",
    "PreparerId": 300100542558856,
    "Preparer": "Jill Jack",
    "PreparerEmail": "jnj@oracle.com",
    "Description": "Requisition for new hire training",
    "Justification": null,
    "DocumentStatus": "Incomplete",
    "DocumentStatusCode": "INCOMPLETE",
    "SubmissionDate": null,
    "ApprovedDate": null,
    "FunctionalCurrencyCode": "USD",
    "SoldToLegalEntityId": null,
    "SoldToLegalEntity": null,
    "FundsStatus": null,
    "FundsStatusCode": null,
    "InterfaceSourceCode": null,
    "InterfaceSourceLineId": null,
    "EmergencyPONumber": null,
    "ModifyingApproverId": null,
    "ModifyingApprover": null,
    "ModifyingApproverEmail": null,
    "OverridingApproverId": null,
    "OverridingApprover": null,
    "OverridingApproverEmail": null,
    "FundsOverrideApproverId": null,
    "FundsOverrideApprover": null,
    "FundsOverrideApproverEmail": null,
    "ApprovedById": null,
    "ApprovedByEmail": null,
    "BudgetaryControlEnabledFlag": false,
    "EmergencyRequisitionFlag": null,
    "ExternallyManagedFlag": false,
    "InternalTransferFlag": false,
    "FundsChkFailWarnFlag": false,
    "CreationDate": "2021-08-18T07:36:56+00:00",
    "LastUpdateDate": "2021-08-20T04:53:59+00:00",
    "CreatedBy": "jnj@oracle.com",
    "LastUpdatedBy": "jnj@oracle.com",
    "ActiveRequisitionFlag": false,
    "SourceApplicationCode": null,
    "RejectedById": null,
    "RejectedByDisplayName": null,
    "RejectedReason": null,
    "links": [
        {
            "rel": "self",
            "href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/300100546219759",
            "name": "purchaseRequisitions",
            "kind": "item",
            "properties": {
                "changeIndicator": "ACED0005737200136A6176612E7574696C2E41727261794C6973747881D21D99C7619D03000149000473697A65787000000001770400000001737200116A6176612E6C616E672E496E746567657212E2A0A4F781873802000149000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B02000078700000000278"
            }
        },
        {
            "rel": "canonical",
            "href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/300100546219759",
            "name": "purchaseRequisitions",
            "kind": "item"
        },
        {
            "rel": "lov",
            "href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/300100546219759/lov/ApprovedByEmailPersonLovPVO",
            "name": "ApprovedByEmailPersonLovPVO",
            "kind": "collection"
        },
        {
            "rel": "lov",
            "href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/300100546219759/lov/PreparerEmailPersonLovPVO",
            "name": "PreparerEmailPersonLovPVO",
            "kind": "collection"
        },
        {
            "rel": "lov",
            "href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/300100546219759/lov/ReqBUNameRequisitionBusinessUnitVVO",
            "name": "ReqBUNameRequisitionBusinessUnitVVO",
            "kind": "collection"
        },
        {
            "rel": "child",
            "href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/300100546219759/child/DFF",
            "name": "DFF",
            "kind": "collection"
        },
        {
            "rel": "child",
            "href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/300100546219759/child/attachments",
            "name": "attachments",
            "kind": "collection"
        },
        {
            "rel": "child",
            "href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/300100546219759/child/lines",
            "name": "lines",
            "kind": "collection"
        },
        {
            "rel": "child",
            "href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/300100546219759/child/summaryAttributes",
            "name": "summaryAttributes",
            "kind": "collection"
        },
        {
            "rel": "action",
            "href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/300100546219759/action/submitRequisition",
            "name": "submitRequisition",
            "kind": "other"
        },
        {
            "rel": "action",
            "href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/300100546219759/action/calculateTaxAndAccounting",
            "name": "calculateTaxAndAccounting",
            "kind": "other"
        },
        {
            "rel": "action",
            "href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/300100546219759/action/createDefaultDistributions",
            "name": "createDefaultDistributions",
            "kind": "other"
        },
        {
            "rel": "action",
            "href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/300100546219759/action/cancel",
            "name": "cancel",
            "kind": "other"
        },
        {
            "rel": "action",
            "href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/300100546219759/action/updateAllLines",
            "name": "updateAllLines",
            "kind": "other"
        },
        {
            "rel": "action",
            "href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/300100546219759/action/processPunchoutShoppingCart",
            "name": "processPunchoutShoppingCart",
            "kind": "other"
        }
    ]
}

Update a Requisition Line and Distribution

Let's consider that you created a requisition that has a line for 5 LCD monitors and there is a single distribution with quantity 5. The requisition is in Incomplete status. The requirement for LCD monitors has changed to 8 and the delivery location has changed to V10 Virginia instead of V1- New York City.

The update comprises this series of operations:

Update the location on the requisition line.
Update the quantity on the requisition line.
Update the quantity on distribution for the requisition line.

Note:
An update to line quantity does not automatically update the distribution quantity.

To update a requisition line and it's distribution:

Identify the RequisitionHeaderId, RequisitionLineId, and RequisitionDistributionId of your requisition.
- An alternative is to perform a GET operation by specifying the requisition number and requisitioning BU name as query parameters using the example URL that follows. The response will return all the lines in the requisition. Note the RequisitionHeaderId and RequisitionLineId for the line with LCD Monitors and the corresponding RequisitionDistributionId.
GET
```
/fscmRestApi/resources/version/purchaseRequisitions?q=Requisition=Requisition Number;RequisitioningBU=Requisitioning BU Name&onlyData=true&expand=lines.distributions
```
Perform a PATCH operation on the URL by replacing the RequisitionHeaderId obtained from step 1, providing these details in the request body. The RequisitionLineId and RequisitionDistributionId obtained from step 1 need to be inserted in the request body.
```
{
"lines":[
{
  "RequisitionLineId":RequisitionLineId,
  "DeliverToLocationCode": "V10 Virginia",
  "Quantity": 8,
  "distributions":[
{
       "RequisitionDistributionId": RequisitionDistributionId,
       "Quantity":8
}]}]
}
```