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

Get all data set definitions

get

/fscmRestApi/resources/11.13.18.05/spendClassificationDatasetDefinitions

Request

Query Parameters
  • 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
  • Used as a predefined finder to search the collection.

    Format: ?finder=<finderName>;<variableName>=<variableValue>,<variableName2>=<variableValue2>

    The following are the available finder names and corresponding finder variables:

    • PrimaryKey: Finds the dataset definition based on the specified primary key criteria.
      Finder Variables:
      • DatasetName; string; Unique identifier for the data set definition.
  • This parameter restricts the number of resources returned inside the resource collection. If the limit exceeds the resource count then the framework will only return the available resources.
  • 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
  • Used to define the starting position of the resource collection. If offset exceeds the resource count then no resources are returned. Default value is 0.
  • The resource item payload will be filtered in order to contain only data (no links section, for example).
  • This parameter orders a resource collection based on the specified fields. The parameter value is a comma-separated string of attribute names, each optionally followed by a colon and "asc" or "desc". Specify "asc" for ascending and "desc" for descending. The default value is "asc". For example, ?orderBy=field1:asc,field2:desc
  • This query parameter defines the where clause. The resource collection will be queried using the provided expressions. The value of this query parameter is one or more expressions. Example: ?q=Deptno>=10 and <= 30;Loc!=NY

    Format: ?q=expression1;expression2

    You can use these queryable attributes to filter this collection resource using the q query parameter:
    • DatasetName; string; Name of the data set.
    • ExtendedFromClause; string; Extended from clause with seeded and user mapped spend attribute tables.
    • ExtendedSelectClause; string; Extended select clause with seeded and user-mapped spend attributes.
    • ExtendedWhereClause; string; Extended where clause with standard and user mapped spend attribute join conditions.
    • SeededFromClause; string; Seeded from clause for data set.
    • SeededSelectClause; string; Seeded select clause for data set.
    • SeededWhereClause; string; Seeded where clause for data set.
  • The resource collection representation will include the "estimated row count" when "?totalResults=true", otherwise the count is not included. The default value is "false".
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
Type: object
Show Source
Nested Schema : Items
Type: array
Title: Items
The items in the collection.
Show Source
Nested Schema : spendClassificationDatasetDefinitions-item-response
Type: object
Show Source
Back to Top

Examples

This example describes how to get all data set definitions.

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"

Example Response Body

The following example includes the contents of the response body in JSON format:
{
    "items": [
        {
            "DatasetName": "ORA_POI_ALL_REQUISITIONS",
            "SeededSelectClause": "'POR_REQ_DISTRIBUTIONS_ALL' source_table,\n70 datasource_num_id, \nPRD.distribution_id txn_id,\nPRD.distribution_id source_txn_id,\t\t\t\t\t\t\t\t  \n'ORA_POI_ALL_REQUISITIONS' spend_txn_type,\nPRH.requisition_number txn_num,\nPRL.line_number line_num,\nnvl(PRH.approved_date,prh.creation_date) txn_date,\nPRL.vendor_id supplier_id,\ndecode(PRL.matching_basis, 'QUANTITY', PRD.distribution_quantity) line_quantity,\nPRL.UNIT_PRICE,\ndecode(PRL.MATCHING_BASIS, 'QUANTITY', PRD.distribution_quantity * PRL.unit_price, 'AMOUNT', PRD.distribution_amount) line_amount,\nPRL.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,\nPRH.approved_date w_update_dt,\nto_char(PRD.distribution_id) fact_integration_id,\n'POR_REQ_DISTRIBUTIONS_ALL' fact_table,\nPRH.req_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": "por_req_distributions_all PRD, \npor_requisition_headers_all PRH, \npor_requisition_lines_all PRL,\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": "PRH.requisition_header_id = PRL.requisition_header_id\nand PRL.requisition_line_id = PRD.requisition_line_id\nand PRH.req_bu_id = PSP.prc_bu_id\nand PRL.item_id = ESI.inventory_item_id (+)\nand ESI.organization_id(+) = PRL.destination_organization_id\nand PRL.vendor_id = PSU.vendor_id (+)\nand PSU.party_id = HZP.party_id(+)\nand PRL.vendor_site_id= PSS.vendor_site_id (+)\nand PRH.req_bu_id = HOU.organization_id\nand PRH.document_status in ('APPROVED','PENDING APPROVAL')\nand PRL.line_status in ('APPROVED','PENDING APPROVAL')\nand trunc(sysdate) between HOU.effective_start_date and HOU.effective_end_date",
            "ExtendedSelectClause": "null CLASSIFICATION_ATTRIBUTE14,PRL.ITEM_DESCRIPTION ITEM_DESCRIPTION,PRH.DESCRIPTION || ' ' || PRH.JUSTIFICATION TXN_DESC,PRL.ITEM_DESCRIPTION LINE_DESC,ESI.ITEM_NUMBER ITEM_CODE,HZP.PARTY_NAME SUPPLIER_NAME,PSS.VENDOR_SITE_CODE SUPPLIER_SITE,HOU.NAME OPERATING_UNIT,PRL.UOM_CODE UOM,PSP.CURRENCY_CODE CURRENCY,PRD.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_ATTRIBUTE16,null CLASSIFICATION_ATTRIBUTE17,null CLASSIFICATION_ATTRIBUTE18,null CLASSIFICATION_ATTRIBUTE19,null CLASSIFICATION_ATTRIBUTE15,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, null legal_entity_id",
            "ExtendedFromClause": null,
            "ExtendedWhereClause": null,
            "links": [
                {
                    "rel": "self",
                    "href": "https://servername/fscmRestApi/resources/version/spendClassificationDatasetDefinitions/0002000000184F52415F504F495F414C4C5F5245515549534954494F4E53000000184F52415F504F495F414C4C5F5245515549534954494F4E53",
                    "name": "spendClassificationDatasetDefinitions",
                    "kind": "item",
                    "properties": {
                        "changeIndicator": "ACED0005737200136A6176612E7574696C2E41727261794C6973747881D21D99C7619D03000149000473697A657870000000027704000000027372001B6F7261636C652E6A626F2E646F6D61696E2E4E756C6C56616C75655899C1C58DAABEEB02000149000A6D53514C54797065496478700000000C71007E000378"
                    }
                },
                {
                    "rel": "canonical",
                    "href": "https://servername/fscmRestApi/resources/version/spendClassificationDatasetDefinitions/0002000000184F52415F504F495F414C4C5F5245515549534954494F4E53000000184F52415F504F495F414C4C5F5245515549534954494F4E53",
                    "name": "spendClassificationDatasetDefinitions",
                    "kind": "item"
                }
            ]
        },
        {
            "DatasetName": "ORA_POI_ESG_INVOICES",
            "SeededSelectClause": "'AP_INVOICE_DISTRIBUTIONS_ALL' source_table,\n60 datasource_num_id,\nAID.invoice_distribution_id txn_id,\nAID.invoice_distribution_id source_txn_id,\t\t\t\t\t\t\t\t\t\t  \n'ORA_POI_ESG_INVOICES' spend_txn_type,\nAIH.invoice_num txn_num,\nAID.invoice_line_number line_num,\nAID.accounting_date txn_date,\nAIH.vendor_id supplier_id,\nAID.quantity_invoiced line_quantity,\nAID.unit_price,\naid.amount 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,\nAID.accounting_date w_update_dt,\nto_char(AID.invoice_distribution_id) fact_integration_id,\n'AP_INVOICE_DISTRIBUTIONS_ALL' fact_table,\nAIH.org_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": "\nap_invoices_all AIH,\nap_invoice_distributions_all AID,\npo_lines_all POL,\npo_distributions_all POD,\negp_system_items_vl ESI,\npoz_suppliers PSU,\nhz_parties HZP, \npoz_supplier_sites_all_m PSS,\nhr_all_organization_units_f_vl HOU,\nap_system_parameters_all ASP,\ngl_code_combinations GCC,\nhr_locations_all_vl HRL,\nap_invoice_lines_all AIL,\npor_item_cat_parent_levels PIC,\npor_browse_categories_tl PC1,\npor_browse_categories_tl PC2,\npor_browse_categories_tl PC3,\npor_browse_categories_tl PC4,\npor_browse_categories_tl PC5,\npor_browse_categories_tl PC6,\npor_browse_categories_tl PC7,\npor_browse_categories_tl PC8,\npor_browse_categories_tl PC9,\npor_browse_categories_tl PC10,\nxle_entity_profiles XEP,\nfnd_lookup_values_vl FLVV,\nfnd_lookup_values_vl FLVV_INVTYP,\negp_system_items_vl ESIB,\ninv_units_of_measure_vl IUOM,\nPO_SYSTEM_PARAMETERS_ALL posp \n",
            "SeededWhereClause": "\nAIH.invoice_id = AID.invoice_id\nAND AID.po_distribution_id = POD.po_distribution_id(+)\nAND POD.po_line_id  = POL.po_line_id (+)\nAND POL.item_id = ESI.inventory_item_id (+)\nAND POD.destination_organization_id = ESI.organization_id(+)\nAND AIH.vendor_site_id = PSS.vendor_site_id\nAND AIH.vendor_id = PSU.vendor_id\nAND PSS.VENDOR_ID = PSU.VENDOR_ID\nAND PSU.party_id = HZP.party_id\nAND AIH.org_id = HOU.organization_id\nAND AIH.org_id = ASP.org_id\nAND trunc(sysdate) between HOU.effective_start_date and HOU.effective_end_date\nAND AID.posted_flag = 'Y'\nAND POL.category_id = PIC.purchasing_cat_id (+)\nAND PIC.type (+) = 'SOURCING'\nAND AID.dist_code_combination_id = GCC.code_combination_id (+)\nAND AID.invoice_id = AIL.invoice_id\nAND AID.invoice_line_number = AIL.line_number \nAND AIL.ship_to_location_id = HRL.location_id (+)\nAND PIC.level1_cat_id = PC1.category_id (+)\nAND PC1.language (+) = userenv('LANG')\nAND PIC.level2_cat_id = PC2.category_id (+)\nAND PC2.language (+) = userenv('LANG')\nAND PIC.level3_cat_id = PC3.category_id (+)\nAND PC3.language (+) = userenv('LANG')\nAND PIC.level4_cat_id = PC4.category_id (+)\nAND PC4.language (+) = userenv('LANG')\nAND PIC.level5_cat_id = PC5.category_id (+)\nAND PC5.language (+) = userenv('LANG')\nAND PIC.level6_cat_id = PC6.category_id (+)\nAND PC6.language (+) = userenv('LANG')\nAND PIC.level7_cat_id = PC7.category_id (+)\nAND PC7.language (+) = userenv('LANG')\nAND PIC.level8_cat_id = PC8.category_id (+)\nAND PC8.language (+) = userenv('LANG')\nAND PIC.level9_cat_id = PC9.category_id (+)\nAND PC9.language (+) = userenv('LANG')\nAND PIC.level10_cat_id = PC10.category_id (+)\nAND PC10.language (+) = userenv('LANG')\nAND AIH.legal_entity_id = XEP.legal_entity_id\nAND HRL.ACTIVE_STATUS(+) = 'A' \nAND HRL.SHIP_TO_SITE_FLAG(+) = 'Y'\nAND FLVV.lookup_type = 'INVOICE LINE TYPE'\nAND FLVV.lookup_code = AIL.LINE_TYPE_LOOKUP_CODE\nAND FLVV_INVTYP.lookup_type = 'INVOICE TYPE'\nAND FLVV_INVTYP.lookup_code = AIH.INVOICE_TYPE_LOOKUP_CODE\nAND AIL.inventory_item_id = ESIB.inventory_item_id(+)\nAND AIL.unit_meas_lookup_code = IUOM.uom_code(+)\nAND PSS.PRC_BU_ID = posp.PRC_BU_ID(+)\nAND posp.INVENTORY_ORGANIZATION_ID = ESIB.organization_id(+)\n",
            "ExtendedSelectClause": null,
            "ExtendedFromClause": null,
            "ExtendedWhereClause": null,
            "links": [
                {
                    "rel": "self",
                    "href": "https://servername/fscmRestApi/resources/version/spendClassificationDatasetDefinitions/0002000000144F52415F504F495F4553475F494E564F49434553FFFFFFFF",
                    "name": "spendClassificationDatasetDefinitions",
                    "kind": "item",
                    "properties": {
                        "changeIndicator": "ACED0005737200136A6176612E7574696C2E41727261794C6973747881D21D99C7619D03000149000473697A657870000000027704000000027372001B6F7261636C652E6A626F2E646F6D61696E2E4E756C6C56616C75655899C1C58DAABEEB02000149000A6D53514C54797065496478700000000C71007E000378"
                    }
                },
                {
                    "rel": "canonical",
                    "href": "https://servername/fscmRestApi/resources/version/spendClassificationDatasetDefinitions/0002000000144F52415F504F495F4553475F494E564F49434553FFFFFFFF",
                    "name": "spendClassificationDatasetDefinitions",
                    "kind": "item"
                }
            ]
        },
        {
            "DatasetName": "ORA_POI_EXPENSES",
            "SeededSelectClause": "'EXM_EXPENSE_DISTS' source_table,\n40 datasource_num_id,\nEED.expense_dist_id txn_id,\nEED.expense_dist_id source_txn_id,\t\t\t\t\t\t\t\t  \n'ORA_POI_EXPENSES' spend_txn_type,\nEER.expense_report_num txn_num,\nto_number(null) line_num,\nEER.final_approval_date txn_date,\nto_number(null) line_quantity,\nto_number(null) unit_price,\ncase\n  when GLE.currency_code = EEH.reimbursement_currency_code then EED.reimbursable_amount\n  ELSE\n      (select EED.reimbursable_amount*gdr.conversion_rate from gl_daily_rates gdr\n        where gdr.conversion_type = EER.EXCHANGE_RATE_TYPE\n        and gdr.conversion_date = EER.final_approval_date\n        and gdr.from_currency = EEH.reimbursement_currency_code\n        and gdr.to_currency = GLE.currency_code)\nend line_amount, \nto_number(null) 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,\nEER.final_approval_date w_update_dt,\nto_char(EED.expense_dist_id) fact_integration_id,\n'EXM_EXPENSE_DISTS' fact_table,\nEER.org_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": "exm_expense_reports EER,\nexm_expenses EEH,\nexm_expense_dists EED,\nfun_all_business_units_v FBU,\ngl_ledgers GLE,\nfnd_lookup_values_vl",
            "SeededWhereClause": "EER.expense_report_id = EEH.expense_report_id\nand EEH.expense_id = EED.expense_id\nand EER.org_id = FBU.bu_id\nand FBU.primary_ledger_id = GLE.ledger_id\nand EER.expense_status_code in ('APPROVAL_COMPLETE', 'PARTIAL_PAID','PAID','INVOICED')\nand nvl(EER.bothpay_flag,'N') = 'N'\nand fnd_lookup_values_vl.lookup_type = 'EXM_EXPENSE_TYPE_CATEGORY'\nand fnd_lookup_values_vl.lookup_code = EEH.expense_type_category_code\nand (EEH.itemization_parent_expense_id is null or EEH.itemization_parent_expense_id != -1)",
            "ExtendedSelectClause": null,
            "ExtendedFromClause": null,
            "ExtendedWhereClause": null,
            "links": [
                {
                    "rel": "self",
                    "href": "https://servername/fscmRestApi/resources/version/spendClassificationDatasetDefinitions/0002000000104F52415F504F495F455850454E534553FFFFFFFF",
                    "name": "spendClassificationDatasetDefinitions",
                    "kind": "item",
                    "properties": {
                        "changeIndicator": "ACED0005737200136A6176612E7574696C2E41727261794C6973747881D21D99C7619D03000149000473697A657870000000027704000000027372001B6F7261636C652E6A626F2E646F6D61696E2E4E756C6C56616C75655899C1C58DAABEEB02000149000A6D53514C54797065496478700000000C71007E000378"
                    }
                },
                {
                    "rel": "canonical",
                    "href": "https://servername/fscmRestApi/resources/version/spendClassificationDatasetDefinitions/0002000000104F52415F504F495F455850454E534553FFFFFFFF",
                    "name": "spendClassificationDatasetDefinitions",
                    "kind": "item"
                }
            ]
        },
        {
            "DatasetName": "ORA_POI_INVOICES",
            "SeededSelectClause": "'AP_INVOICE_DISTRIBUTIONS_ALL' source_table,\n30 datasource_num_id,\nAID.invoice_distribution_id txn_id,\nAID.invoice_distribution_id source_txn_id,\t\t\t\t\t\t\t\t\t\t  \n'ORA_POI_INVOICES' spend_txn_type,\nAIH.invoice_num txn_num,\nAID.invoice_line_number line_num,\nAID.accounting_date txn_date,\nAIH.vendor_id supplier_id,\nAID.quantity_invoiced line_quantity,\nAID.unit_price,\nNVL(AID.base_amount,AID.amount) 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,\nAID.accounting_date w_update_dt,\nto_char(AID.invoice_distribution_id) fact_integration_id,\n'AP_INVOICE_DISTRIBUTIONS_ALL' fact_table,\nAIH.org_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": "ap_invoices_all AIH,\nap_invoice_distributions_all AID,\npo_lines_all POL,\npo_distributions_all POD,\negp_system_items_vl ESI,\npoz_suppliers PSU,\nhz_parties HZP, \npoz_supplier_sites_all_m PSS,\nhr_all_organization_units_f_vl HOU,\nap_system_parameters_all ASP",
            "SeededWhereClause": "AIH.invoice_id = AID.invoice_id\nand AID.po_distribution_id = POD.po_distribution_id(+)\nand POD.po_line_id  = POL.po_line_id (+)\nand POL.item_id = ESI.inventory_item_id (+)\nand POD.destination_organization_id = ESI.organization_id(+)\nand AIH.vendor_site_id = PSS.vendor_site_id\nAND AIH.vendor_id = PSU.vendor_id\nAND PSS.VENDOR_ID = PSU.VENDOR_ID\nAND PSU.party_id = HZP.party_id\nand AIH.org_id = HOU.organization_id\nand AIH.org_id = ASP.org_id\nand trunc(sysdate) between HOU.effective_start_date and HOU.effective_end_date\nand AID.posted_flag = 'Y'",
            "ExtendedSelectClause": null,
            "ExtendedFromClause": null,
            "ExtendedWhereClause": null,
            "links": [
                {
                    "rel": "self",
                    "href": "https://servername/fscmRestApi/resources/version/spendClassificationDatasetDefinitions/0002000000104F52415F504F495F494E564F49434553FFFFFFFF",
                    "name": "spendClassificationDatasetDefinitions",
                    "kind": "item",
                    "properties": {
                        "changeIndicator": "ACED0005737200136A6176612E7574696C2E41727261794C6973747881D21D99C7619D03000149000473697A657870000000027704000000027372001B6F7261636C652E6A626F2E646F6D61696E2E4E756C6C56616C75655899C1C58DAABEEB02000149000A6D53514C54797065496478700000000C71007E000378"
                    }
                },
                {
                    "rel": "canonical",
                    "href": "https://servername/fscmRestApi/resources/version/spendClassificationDatasetDefinitions/0002000000104F52415F504F495F494E564F49434553FFFFFFFF",
                    "name": "spendClassificationDatasetDefinitions",
                    "kind": "item"
                }
            ]
        },
        {
            "DatasetName": "ORA_POI_ORDERS",
            "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, null legal_entity_id",
            "ExtendedFromClause": null,
            "ExtendedWhereClause": null,
            "links": [
                {
                    "rel": "self",
                    "href": "https://servername/fscmRestApi/resources/version/spendClassificationDatasetDefinitions/00020000000E4F52415F504F495F4F52444552530000000E4F52415F504F495F4F5244455253",
                    "name": "spendClassificationDatasetDefinitions",
                    "kind": "item",
                    "properties": {
                        "changeIndicator": "ACED0005737200136A6176612E7574696C2E41727261794C6973747881D21D99C7619D03000149000473697A657870000000027704000000027372001B6F7261636C652E6A626F2E646F6D61696E2E4E756C6C56616C75655899C1C58DAABEEB02000149000A6D53514C54797065496478700000000C71007E000378"
                    }
                },
                {
                    "rel": "canonical",
                    "href": "https://servername/fscmRestApi/resources/version/spendClassificationDatasetDefinitions/00020000000E4F52415F504F495F4F52444552530000000E4F52415F504F495F4F5244455253",
                    "name": "spendClassificationDatasetDefinitions",
                    "kind": "item"
                }
            ]
        },
        {
            "DatasetName": "ORA_POI_REQUISITIONS",
            "SeededSelectClause": "'POR_REQ_DISTRIBUTIONS_ALL' source_table,\n20 datasource_num_id, \nPRD.distribution_id txn_id,\nPRD.distribution_id source_txn_id,\t\t\t\t\t\t\t\t  \n'ORA_POI_REQUISITIONS' spend_txn_type,\nPRH.requisition_number txn_num,\nPRL.line_number line_num,\nPRH.approved_date txn_date,\nPRL.vendor_id supplier_id,\ndecode(PRL.matching_basis, 'QUANTITY', PRD.distribution_quantity) line_quantity,\nPRL.UNIT_PRICE,\ndecode(PRL.MATCHING_BASIS, 'QUANTITY', PRD.distribution_quantity * PRL.unit_price, 'AMOUNT', PRD.distribution_amount) line_amount,\nPRL.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,\nPRH.approved_date w_update_dt,\nto_char(PRD.distribution_id) fact_integration_id,\n'POR_REQ_DISTRIBUTIONS_ALL' fact_table,\nPRH.req_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": "por_req_distributions_all PRD, \npor_requisition_headers_all PRH, \npor_requisition_lines_all PRL,\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": "PRH.requisition_header_id = PRL.requisition_header_id\nand PRL.requisition_line_id = PRD.requisition_line_id\nand PRH.req_bu_id = PSP.prc_bu_id\nand PRL.item_id = ESI.inventory_item_id (+)\nand ESI.organization_id(+) = PRL.destination_organization_id\nand PRL.vendor_id = PSU.vendor_id (+)\nand PSU.party_id = HZP.party_id(+)\nand PRL.vendor_site_id= PSS.vendor_site_id (+)\nand PRH.req_bu_id = HOU.organization_id\nand PRH.document_status = 'APPROVED'\nand PRL.line_status = 'APPROVED'\nand trunc(sysdate) between HOU.effective_start_date and HOU.effective_end_date",
            "ExtendedSelectClause": "PRL.ITEM_DESCRIPTION ITEM_DESCRIPTION,PRH.DESCRIPTION || ' ' || PRH.JUSTIFICATION TXN_DESC,PRL.ITEM_DESCRIPTION LINE_DESC,ESI.ITEM_NUMBER ITEM_CODE,HZP.PARTY_NAME SUPPLIER_NAME,PSS.VENDOR_SITE_CODE SUPPLIER_SITE,HOU.NAME OPERATING_UNIT,PRL.UOM_CODE UOM,PSP.CURRENCY_CODE CURRENCY,PRD.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, null legal_entity_id",
            "ExtendedFromClause": null,
            "ExtendedWhereClause": null,
            "links": [
                {
                    "rel": "self",
                    "href": "https://servername/fscmRestApi/resources/version/spendClassificationDatasetDefinitions/0002000000144F52415F504F495F5245515549534954494F4E53000000144F52415F504F495F5245515549534954494F4E53",
                    "name": "spendClassificationDatasetDefinitions",
                    "kind": "item",
                    "properties": {
                        "changeIndicator": "ACED0005737200136A6176612E7574696C2E41727261794C6973747881D21D99C7619D03000149000473697A657870000000027704000000027372001B6F7261636C652E6A626F2E646F6D61696E2E4E756C6C56616C75655899C1C58DAABEEB02000149000A6D53514C54797065496478700000000C71007E000378"
                    }
                },
                {
                    "rel": "canonical",
                    "href": "https://servername/fscmRestApi/resources/version/spendClassificationDatasetDefinitions/0002000000144F52415F504F495F5245515549534954494F4E53000000144F52415F504F495F5245515549534954494F4E53",
                    "name": "spendClassificationDatasetDefinitions",
                    "kind": "item"
                }
            ]
        },
        {
            "DatasetName": "POI_SPEND_DATA",
            "SeededSelectClause": "'POI_SPEND_DATA' source_table,\n50 datasource_num_id,\ntxn_id,\nsource_transaction_id source_txn_id,\nspend_txn_type,\ntxn_num,\nline_num,\ntxn_date,\ntxn_desc,\nline_desc,\nitem_code,\nitem_description,\n-1 supplier_id,\nsupplier_name,\nsupplier_site,\noperating_unit,\nuom,\nline_quantity,\ncurrency,\nunit_price,\nline_amount,\ncost_center,\nebs_category_code,\nunspsc_category_code,\ncustom_category_code1,\ncustom_category_code2,\ncustom_category_code3,\nebs_auto_code,\nunspsc_auto_code,\ncustom_auto_code1,\ncustom_auto_code2,\ncustom_auto_code3,\nw_update_dt,\nFACT_INTEGRATION_ID,\nFACT_TABLE,\n-1 bu_id,\nship_to_location,\nnatural_account,\nnatural_account_desc,\nlegal_entity,\nline_type,\ninvoice_type,\nproc_cat_hierarchy1,\nproc_cat_hierarchy2,\nproc_cat_hierarchy3,\nproc_cat_hierarchy4,\nproc_cat_hierarchy5,\nproc_cat_hierarchy6,\nproc_cat_hierarchy7,\nproc_cat_hierarchy8,\nproc_cat_hierarchy9,\nproc_cat_hierarchy10,\nds_attribute1 classification_attribute1, \nds_attribute2 classification_attribute2, \nds_attribute3 classification_attribute3, \nds_attribute4 classification_attribute4, \nds_attribute5 classification_attribute5, \nds_attribute6 classification_attribute6, \nds_attribute7 classification_attribute7, \nds_attribute8 classification_attribute8, \nds_attribute9 classification_attribute9, \nds_attribute10 classification_attribute10, \nds_attribute11 classification_attribute11, \nds_attribute12 classification_attribute12, \nds_attribute13 classification_attribute13, \nds_attribute14 classification_attribute14, \nds_attribute15 classification_attribute15, \nds_attribute16 classification_attribute16, \nds_attribute17 classification_attribute17, \nds_attribute18 classification_attribute18, \nds_attribute19 classification_attribute19, \nds_attribute20 classification_attribute20,\nprediction_code1,\nprediction_match_score1,\nprediction_code2,\nprediction_match_score2,\nprediction_code3,\nprediction_match_score3,\nlegal_entity_id",
            "SeededFromClause": "poi_spend_data",
            "SeededWhereClause": null,
            "ExtendedSelectClause": null,
            "ExtendedFromClause": null,
            "ExtendedWhereClause": null,
            "links": [
                {
                    "rel": "self",
                    "href": "https://servername/fscmRestApi/resources/version/spendClassificationDatasetDefinitions/00020000000E504F495F5350454E445F44415441FFFFFFFF",
                    "name": "spendClassificationDatasetDefinitions",
                    "kind": "item",
                    "properties": {
                        "changeIndicator": "ACED0005737200136A6176612E7574696C2E41727261794C6973747881D21D99C7619D03000149000473697A657870000000027704000000027372001B6F7261636C652E6A626F2E646F6D61696E2E4E756C6C56616C75655899C1C58DAABEEB02000149000A6D53514C54797065496478700000000C71007E000378"
                    }
                },
                {
                    "rel": "canonical",
                    "href": "https://servername/fscmRestApi/resources/version/spendClassificationDatasetDefinitions/00020000000E504F495F5350454E445F44415441FFFFFFFF",
                    "name": "spendClassificationDatasetDefinitions",
                    "kind": "item"
                }
            ]
        },
        {
            "DatasetName": "TEST5",
            "SeededSelectClause": "'PO_DISTRIBUTIONS_ALL' source_table,\n20 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": "ACED0005737200136A6176612E7574696C2E41727261794C6973747881D21D99C7619D03000149000473697A657870000000027704000000027372001B6F7261636C652E6A626F2E646F6D61696E2E4E756C6C56616C75655899C1C58DAABEEB02000149000A6D53514C54797065496478700000000C71007E000378"
                    }
                },
                {
                    "rel": "canonical",
                    "href": "https://servername/fscmRestApi/resources/version/spendClassificationDatasetDefinitions/0002000000055445535435000000055445535435",
                    "name": "spendClassificationDatasetDefinitions",
                    "kind": "item"
                }
            ]
        }
    ],
    "count": 8,
    "hasMore": false,
    "limit": 25,
    "offset": 0,
    "links": [
        {
            "rel": "self",
            "href": "https://servername/fscmRestApi/resources/version/spendClassificationDatasetDefinitions",
            "name": "spendClassificationDatasetDefinitions",
            "kind": "collection"
        }
    ]
}
Back to Top