1. REST API for Oracle Fusion Cloud Financials
  2. Tasks
  3. Invoices
  4. Invoice Lines
  5. Invoice Lines Descriptive Flexfields

Update descriptive flexfields for an invoice line

patch

/fscmRestApi/resources/11.13.18.05/invoices/{invoicesUniqID}/child/invoiceLines/{invoiceLinesUniqID}/child/invoiceLineDff/{invoiceLineDffUniqID}

Request

Path Parameters
  • This is the hash key of the attributes which make up the composite key--- InvoiceId and LineNumber ---for the Invoice Lines Descriptive Flexfields resource and used to uniquely identify an instance of Invoice Lines Descriptive Flexfields. The client should not generate the hash key value. Instead, the client should query on the Invoice Lines Descriptive Flexfields collection resource with a filter on the primary key values in order to navigate to a specific instance of Invoice Lines Descriptive Flexfields.

    For example: invoiceLineDff?q=InvoiceId=<value1>;LineNumber=<value2>
  • This is the hash key of the attributes which make up the composite key for the Invoice Lines resource and used to uniquely identify an instance of Invoice Lines. The client should not generate the hash key value. Instead, the client should query on the Invoice Lines collection resource in order to navigate to a specific instance of Invoice Lines to get the hash key.
  • This is the hash key of the attributes which make up the composite key for the Invoices resource and used to uniquely identify an instance of Invoices. The client should not generate the hash key value. Instead, the client should query on the Invoices collection resource in order to navigate to a specific instance of Invoices to get the hash key.
Header Parameters
  • If the REST API supports runtime customizations, the shape of the service may change during runtime. The REST client may isolate itself from these changes or choose to interact with the latest version of the API by specifying this header. For example: Metadata-Context:sandbox="TrackEmployeeFeature".
  • The protocol version between a REST client and service. If the client does not specify this header in the request the server will pick a default version for the API.
Supported Media Types
Request Body - application/json ()
Root Schema : schema
Type: object
Show Source
Back to Top

Response

Supported Media Types

Default Response

The following table describes the default response for this task.
Headers
  • If the REST API supports runtime customizations, the shape of the service may change during runtime. The REST client may isolate itself from these changes or choose to interact with the latest version of the API by specifying this header. For example: Metadata-Context:sandbox="TrackEmployeeFeature".
  • The protocol version between a REST client and service. If the client does not specify this header in the request the server will pick a default version for the API.
Body ()
Root Schema : invoices-invoiceLines-invoiceLineDff-item-response
Type: object
Show Source
Links
LVVO_V___FLEX_Context
Parameters:
  • finder: ValidValuesFinder%3BBind_ApplicationId%3D200%2CBind_DescriptiveFlexfieldCode%3DAP_INVOICE_LINES
The following properties are defined on the LOV link relation:
  • Source Attribute: __FLEX_Context_DisplayValue; Target Attribute: Name
  • Display Attribute: Name, Description
LVVO___FLEX_Context
Parameters:
  • finder: ValidValuesFinder%3BBind_ApplicationId%3D200%2CBind_DescriptiveFlexfieldCode%3DAP_INVOICE_LINES
The following properties are defined on the LOV link relation:
  • Source Attribute: __FLEX_Context; Target Attribute: ContextCode
  • Display Attribute: Name
Back to Top

Examples

The following example shows how to retrieve and update a descriptive flexfield of an invoice line of an invoice:

  • Get all the invoice lines of an invoice.
  • Use the self URI of the specific invoice line.
  • Get all the descriptive flexfields of the invoice line.
  • Use the self URI of the specific descriptive flexfield.
  • Submit a PATCH request on the REST resource using cURL.

Here's the cURL command to retrieve all the invoice lines.

curl -i -u "<username>:<password>" -H "Content-Type: application/json" -X GET https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/invoices/300100155475915/child/invoiceLines

Example Response Body

The following example shows the contents of the response body in JSON format:

{
    "items": [
        {
            "LineNumber": 1,
            "LineAmount": 2212.75,
            "AccountingDate": "2018-11-01",
            "UOM": null,
            ...
            "links": [
                {
                    "rel": "self",
                    "href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/invoices/300100155475915/child/invoiceLines/00020000000EACED00057708000110F0832A07CB0000000AACED0005770400000001",
                    "name": "invoiceLines",
                    "kind": "item",
                    "properties": {
                                     "changeIndicator": "ACED0005737200136A6176612E7574696C2E41727261794C6973747881D21D99C7619D03000149000473697A65787000000001770400000001737200116A6176612E6C616E672E496E746567657212E2A0A4F781873802000149000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B02000078700000000178"
                                  }
                },
                {
                    "rel": "child",
                    "href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/invoices/300100155475915/child/invoiceLines/00020000000EACED00057708000110F0832A07CB0000000AACED0005770400000001/child/invoiceLineGdf",
                    "name": "invoiceLineGdf",
                    "kind": "collection"
                },
                ...
            ]
        },
        ...
    ],
    "count": 10,
    "hasMore": false,
    "limit": 25,
    "offset": 0,
    "links": [
        {
            "rel": "self",
            "href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/invoices/300100155475915/child/invoiceLines",
            "name": "invoiceLines",
            "kind": "collection"
        }
    ]
}

A hash key of InvoiceId and LineNumber identifies an invoice line.

Here's the cURL command that uses the hash key in the self URI to retrieve the specific invoice line.

curl -i -u "<username>:<password>" -H "Content-Type: application/json" -X GET https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/invoices/300100155475915/child/invoiceLines/00020000000EACED00057708000110F0832A07CB0000000AACED0005770400000001

Here's the cURL command that uses the child URI of the invoice line to retrieve all the descriptive flexfields.

curl -i -u "<username>:<password>" -H "Content-Type: application/json" -X GET https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/invoices/300100155475915/child/invoiceLines/00020000000EACED00057708000110F0832A07CB0000000AACED0005770400000001/child/invoiceLineDff

A hash key of InvoiceId and LineNumber identifies a descriptive flexfield.

Here's the cURL command that uses the self URI to retrieve the specific descriptive flexfield.

curl -i -u "<username>:<password>" -H "Content-Type: application/json" -X GET https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/invoices/300100155475915/child/invoiceLines/00020000000EACED00057708000110F0832A07CB0000000AACED0005770400000001/child/invoiceLineDff/00020000000EACED00057708000110F0832A07CB0000000AACED0005770400000001

Here's the cURL command that uses the self URI to update the descriptive flexfield.

curl -i -u "<username>:<password>" -H "Content-Type: application/json" -X PATCH -d <payload> https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/invoices/300100155475915/child/invoiceLines/00020000000EACED00057708000110F0832A07CB0000000AACED0005770400000001/child/invoiceLineDff/00020000000EACED00057708000110F0832A07CB0000000AACED0005770400000001

Example Request Payload

The following example shows the contents of the request body in JSON format:

{
 "ProductSubcategory": "Printers"
}

Example Response Body

The following example shows the contents of the response body in JSON format:

{
    "InvoiceId": 300100155475915,
    "LineNumber": 1,
    "ProductSubcategory": "Printers",
    "additionalLineInfo": null,
    "__FLEX_Context": null,
    "__FLEX_Context_DisplayValue": null,
    "links": [
        {
            "rel": "self",
            "href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/invoices/300100155475915/child/invoiceLines/00020000000EACED00057708000110F0832A07CB0000000AACED0005770400000001/child/invoiceLineDff/00020000000EACED00057708000110F0832A07CB0000000AACED0005770400000001",
            "name": "invoiceLineDff",
            "kind": "item",
            "properties": {
                             "changeIndicator": "ACED0005737200136A6176612E7574696C2E41727261794C6973747881D21D99C7619D03000149000473697A65787000000001770400000001737200116A6176612E6C616E672E496E746567657212E2A0A4F781873802000149000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B02000078700000000378"
                          }
        },
        {
            "rel": "canonical",
            "href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/invoices/300100155475915/child/invoiceLines/00020000000EACED00057708000110F0832A07CB0000000AACED0005770400000001/child/invoiceLineDff/00020000000EACED00057708000110F0832A07CB0000000AACED0005770400000001",
            "name": "invoiceLineDff",
            "kind": "item"
        },
        ...
    ]
}
Back to Top