JDBC Driver for Oracle Fusion Cloud Financials

Build 25.0.9434

SpendClassificationDataSetTransactions

The Spend Classification Data Set Transactions resource manages data set transactions in Oracle Fusion Cloud Spend Classification.

Table-Specific Information

Select

The driver uses the Oracle Fusion Cloud Financials API to process some of the filters having 'queryable'='true' in metadata. The driver processes other filters within the driver.

For example, the following query is processed server-side: 

SELECT * FROM Procurement.SpendClassificationDataSetTransactions WHERE Finder = 'DataSetTransactionFinder' AND BindDataSetName = 'ORA_POI_EXPENSES';

Due to the limitations of the Oracle Fusion Cloud Financials API, querying this view requires the use of Finders.

The SpendClassificationDataSetTransactions view supports the 'DataSetTransactionFinder' finder. The fields which can be used along with it are

  • BindBuId
  • BindDataSetName
  • BindTransactionId
  • BindTxnFrom
  • BindTxnUntil

Columns

Name Type Description
SourceTable String Name of the source table that has the transaction.
DatasourceId Long Value that uniquely identifies the data source.
TransactionId [KEY] Long Value that uniquely identifies the transaction.
SourceTransactionId Decimal Value that uniquely identifies the transaction in the source application.
DataSetName [KEY] String Name of the data set.
TransactionNumber String Number that identifies the transaction in the source application.
LineNumber Long Value that indicates the line number in a transaction.
TransactionDate Date Date when the transaction was entered in the application.
TransactionDescription String Description of the transaction.
LineDescription String Description of the line in a transaction.
Item String Value that uniquely identifies an item.
ItemDescription String Description of an item.
SupplierName String Name of the supplier.
SupplierSite String Name of the supplier site.
BusinessUnit String Name of the business unit.
UnitOfMeasure String Value that indicates the unit of measure for the item quantity in a transaction.
LineQuantity Decimal Value that indicates the quantity of item.
Currency String Value that indicates the currency of the transaction.
UnitPrice Decimal Value that indicates the unit price for goods or services in a transaction.
LineAmount Decimal Value that indicates the amount of goods or services in the line of a transaction.
CostCenter String Value that indicates the cost center.
PurchasingCategoryCode String Abbreviation that uniquely identifies the purchasing category.
UNSPSCCategoryCode String Abbreviation that uniquely identifies the UNSPSC category.
CustomCategoryCode1 String Abbreviation that uniquely identifies the custom 1 category.
CustomCategoryCode2 String Abbreviation that uniquely identifies the custom 2 category.
CustomCategoryCode3 String Abbreviation that uniquely identifies the custom 3 category.
PurchasingAutoCode String Abbreviation that uniquely identifies the predicted purchasing category.
UNSPSCAutoCode String Abbreviation that uniquely identifies the predicted UNSPSC category.
CustomAutoCode1 String Abbreviation that uniquely identifies the predicted custom 1 category.
CustomAutoCode2 String Abbreviation that uniquely identifies the predicted custom 2 category.
CustomAutoCode3 String Abbreviation that uniquely identifies the predicted custom 3 category.
FactIntegrationId String Value that uniquely identifies the integration between the source and destination tables.
FactTable String Table name that is used for integration between the source and destination.
Purpose String Purpose for which the data set is used.
ClassificationAttribute1 String Additional attribute mapped during spend classification configuration to influence classification results.
ClassificationAttribute2 String Additional attribute mapped during spend classification configuration to influence classification results.
ClassificationAttribute3 String Additional attribute mapped during spend classification configuration to influence classification results.
ClassificationAttribute4 String Additional attribute mapped during spend classification configuration to influence classification results.
ClassificationAttribute5 String Additional attribute mapped during spend classification configuration to influence classification results.
ClassificationAttribute6 String Additional attribute mapped during spend classification configuration to influence classification results.
ClassificationAttribute7 String Additional attribute mapped during spend classification configuration to influence classification results.
ClassificationAttribute8 String Additional attribute mapped during spend classification configuration to influence classification results.
ClassificationAttribute9 String Additional attribute mapped during spend classification configuration to influence classification results.
ClassificationAttribute10 String Additional attribute mapped during spend classification configuration to influence classification results.
ClassificationAttribute11 String Additional attribute mapped during spend classification configuration to influence classification results.
ClassificationAttribute12 String Additional attribute mapped during spend classification configuration to influence classification results.
ClassificationAttribute13 String Additional attribute mapped during spend classification configuration to influence classification results.
ClassificationAttribute14 String Additional attribute mapped during spend classification configuration to influence classification results.
ClassificationAttribute15 String Additional attribute mapped during spend classification configuration to influence classification results.
ClassificationAttribute16 String Additional attribute mapped during spend classification configuration to influence classification results.
ClassificationAttribute17 String Additional attribute mapped during spend classification configuration to influence classification results.
ClassificationAttribute18 String Additional attribute mapped during spend classification configuration to influence classification results.
ClassificationAttribute19 String Additional attribute mapped during spend classification configuration to influence classification results.
ClassificationAttribute20 String Additional attribute mapped during spend classification configuration to influence classification results.
BestPrediction String Best-category prediction based on the transaction text and the description of the uploaded categories.
ConfidenceForBestPrediction Double Similarity score based on the transaction text and description of the best category.
SecondBestPrediction String Second-best category prediction based on the transaction text and the description of the uploaded categories.
ConfidenceForSecondBestPrediction Double Similarity score based on the transaction text and description of the second-best category.
ThirdBestPrediction String Third-best category prediction based on the transaction text and the description of the uploaded categories.
ConfidenceForThirdBestPrediction Double Similarity score based on the transaction text and the description of the third-best category.
BindBuId Long The business unit identifier (to filter transactions for a specific business unit).
BindDataSetName String The name of the data set (to filter transactions belonging to a specific data set).
BindTransactionId Long The unique transaction identifier (to find a specific transaction).
BindTxnFrom Date The start date (or lower bound) of the transaction date range filter.
BindTxnUntil Date The end date (or upper bound) of the transaction date range filter.
Finder String Finder criteria used to filter data set transactions based on specific search parameters and conditions.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434