1. REST API for Oracle Fusion Cloud Procurement
  2. Tasks
  3. Spend Classification Data Set Definitions

Get one data set definition

get

/fscmRestApi/resources/11.13.18.05/spendClassificationDatasetDefinitions/{spendClassificationDatasetDefinitionsUniqID}

Request

Path Parameters
  • This is the hash key of the attributes which make up the composite key for the Spend Classification Data Set Definitions resource and used to uniquely identify an instance of Spend Classification Data Set Definitions. The client should not generate the hash key value. Instead, the client should query on the Spend Classification Data Set Definitions collection resource in order to navigate to a specific instance of Spend Classification Data Set Definitions to get the hash key.
Query Parameters
  • This parameter specifies dependencies which are fields that are set before and rolled back after generating the response. Generally they are used to preview the effects of an attribute change. The fields specified in this parameter are always set in the resource instance in question. When a child resource collection is requested and the parameter is set, the fields will be set in the parent resource instance before generating the resource collection payload. The value of this query parameter is a set of dependency fields. Example: dependency=ProductId=2

    Format: <attr1>=<val1>,<attr2>=<value2>
  • When this parameter is provided, the specified children are included in the resource payload (instead of just a link). The value of this query parameter is "all" or "". More than one child can be specified using comma as a separator. Example: ?expand=Employees,Localizations. Nested children can also be provided following the format "Child.NestedChild" (Example: ?expand=Employees.Managers). If a nested child is provided (Example: Employees.Managers), the missing children will be processed implicitly. For example, "?expand=Employees.Managers" is the same as "?expand=Employees,Employees.Managers" (which will expand Employees and Managers).
  • This parameter filters the resource fields. Only the specified fields are returned, which means that if no fields are specified, no fields are returned (useful to get only the links). If an indirect child resource is provided (Example: Employees.Managers), the missing children will be processed implicitly. For example, "?fields=Employees.Managers:Empname" is the same as "?fields=;Employees:;Employees.Managers:Empname" (which will only return the "Empname" field for Managers). the value of this query parameter is a list of resource fields. The attribute can be a direct (Example: Employees) or indirect (Example: Employees.Managers) child. It cannot be combined with expand query parameter. If both are provided, only fields will be considered.

    Format: ?fields=Attribute1,Attribute2

    Format for fields in child resource: ?fields=Accessor1:Attribute1,Attribute2
  • This parameter can be used to show only certain links while accessing a singular resource or a resource collection. The parameter value format is a comma-separated list of : <link_relation>

    Example:
    self,canonical
  • The resource item payload will be filtered in order to contain only data (no links section, for example).
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.

There's no request body for this operation.

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 : spendClassificationDatasetDefinitions-item-response
Type: object
Show Source
Back to Top

Examples

This example describes how to get one data set definition.

Example cURL Command

Use the following cURL command to submit a request on the REST resource:

curl -u username:password "https://servername/fscmRestApi/resources/version/spendClassificationDatasetDefinitions/spendClassificationDatasetDefinitionsUniqID"

For example:

curl -u username:password "https://servername/fscmRestApi/resources/version/spendClassificationDatasetDefinitions/0002000000055445535435000000055445535435"

Example Response Body

The following example includes the contents of the response body in JSON format:
{
    "DatasetName": "TEST5",
    "SeededSelectClause": "'PO_DISTRIBUTIONS_ALL' source_table,\n10 datasource_num_id, \nPOD.po_distribution_id txn_id,\nPOD.po_distribution_id source_txn_id,\t\t\t\t\t\t\t\t\t \n'ORA_POI_ORDERS' spend_txn_type,\nPOH.segment1 txn_num,\nPOL.LINE_NUM,\nPOH.approved_date txn_date,\nPOH.vendor_id supplier_id,\ndecode(POL.matching_basis, 'QUANTITY',POD.quantity_ordered-nvl(POD.quantity_cancelled,0)) line_quantity,\nPOL.unit_price*nvl(POD.rate,1) unit_price,\ndecode(POL.MATCHING_BASIS, 'QUANTITY', (POD.QUANTITY_ORDERED - nvl(POD.QUANTITY_CANCELLED,0))* POL.UNIT_PRICE*nvl(POD.rate,1), 'AMOUNT', ((POD.amount_ordered - nvl(POD.amount_cancelled,0))*nvl(POD.rate,1)))  line_amount,\nPOL.category_id ebs_category_code,\nto_number(null) unspsc_category_code,\nto_number(null) custom_category_code1,\nto_number(null) custom_category_code2,\nto_number(null) custom_category_code3,\nto_number(null) ebs_auto_code,\nto_number(null) unspsc_auto_code,\nto_number(null) custom_auto_code1,\nto_number(null) custom_auto_code2,\nto_number(null) custom_auto_code3,\nPOH.approved_date w_update_dt,\nto_char(POD.po_distribution_id) fact_integration_id,\n'PO_DISTRIBUTIONS_ALL' fact_table,\nPOH.prc_bu_id bu_id,\nto_number(null) PREDICTION_CODE1,\nto_number(null) PREDICTION_MATCH_SCORE1,\nto_number(null) PREDICTION_CODE2,\nto_number(null) PREDICTION_MATCH_SCORE2,\nto_number(null) PREDICTION_CODE3,\nto_number(null) PREDICTION_MATCH_SCORE3",
    "SeededFromClause": "po_distributions_all POD, \npo_headers_all POH, \npo_lines_all POL,\nEGP_SYSTEM_ITEMS_VL ESI,\npoz_suppliers PSU,\nhz_parties HZP, \npoz_supplier_sites_all_m PSS,\nhr_all_organization_units_f_vl HOU,\npo_system_parameters_all PSP",
    "SeededWhereClause": "POH.po_header_id = POL.po_header_id\nand POL.po_line_id = POD.po_line_id\nand POL.item_id = ESI.inventory_item_id(+)\nand ESI.organization_id(+) = POD.destination_organization_id\nand POH.vendor_id = PSU.vendor_id\nand PSU.party_id = HZP.party_id\nand POH.vendor_site_id= PSS.vendor_site_id\nand POH.prc_bu_id = HOU.organization_id\nand POH.prc_bu_id = PSP.prc_bu_id\nand POH.approved_flag = 'Y'\nand trunc(sysdate) between HOU.effective_start_date and HOU.effective_end_date",
    "ExtendedSelectClause": "POL.ITEM_DESCRIPTION ITEM_DESCRIPTION,POH.COMMENTS TXN_DESC,POL.ITEM_DESCRIPTION LINE_DESC,ESI.ITEM_NUMBER ITEM_CODE,HZP.PARTY_NAME SUPPLIER_NAME,PSS.VENDOR_SITE_CODE SUPPLIER_SITE,HOU.NAME OPERATING_UNIT,POL.UOM_CODE UOM,PSP.CURRENCY_CODE CURRENCY,POD.CODE_COMBINATION_ID COST_CENTER,null CLASSIFICATION_ATTRIBUTE1,null CLASSIFICATION_ATTRIBUTE2,null CLASSIFICATION_ATTRIBUTE3,null CLASSIFICATION_ATTRIBUTE4,null CLASSIFICATION_ATTRIBUTE5,null CLASSIFICATION_ATTRIBUTE6,null CLASSIFICATION_ATTRIBUTE7,null CLASSIFICATION_ATTRIBUTE8,null CLASSIFICATION_ATTRIBUTE9,null CLASSIFICATION_ATTRIBUTE10,null CLASSIFICATION_ATTRIBUTE11,null CLASSIFICATION_ATTRIBUTE12,null CLASSIFICATION_ATTRIBUTE13,null CLASSIFICATION_ATTRIBUTE14,null CLASSIFICATION_ATTRIBUTE15,null CLASSIFICATION_ATTRIBUTE16,null CLASSIFICATION_ATTRIBUTE17,null CLASSIFICATION_ATTRIBUTE18,null CLASSIFICATION_ATTRIBUTE19,null CLASSIFICATION_ATTRIBUTE20, null ship_to_location, null natural_account, null natural_account_desc, null proc_cat_hierarchy1, null proc_cat_hierarchy2, null proc_cat_hierarchy3, null proc_cat_hierarchy4, null proc_cat_hierarchy5, null proc_cat_hierarchy6, null proc_cat_hierarchy7, null proc_cat_hierarchy8, null proc_cat_hierarchy9, null proc_cat_hierarchy10, null legal_entity, null line_type, null invoice_type",
    "ExtendedFromClause": null,
    "ExtendedWhereClause": null,
                  "links": [
        {
            "rel": "self",
            "href": "https://servername/fscmRestApi/resources/version/spendClassificationDatasetDefinitions/0002000000055445535435000000055445535435",
            "name": "spendClassificationDatasetDefinitions",
            "kind": "item",
            "properties": {
                "changeIndicator": "ACED0005737200136A6176612E7574696C2E41727261794C6973747881D21D99C7619D03000149000473697A65787000000002770400000002737200116A6176612E6C616E672E496E746567657212E2A0A4F781873802000149000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B0200007870000000017371007E00020000000178"
            }
        },
        {
            "rel": "canonical",
            "href": "https://servername/fscmRestApi/resources/version/spendClassificationDatasetDefinitions/0002000000055445535435000000055445535435",
            "name": "spendClassificationDatasetDefinitions",
            "kind": "item"
        }
    ]

}
Back to Top