SpendClassificationSummaryFromSources
The Spend Classification Summary From Sources resource aggregates the transaction amounts for source transactions in a data set organized by categories.
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.SpendClassificationSummaryFromSources WHERE Finder = 'SummaryFromSourcesFinder' AND bindDataset = 'ORA_POI_EXPENSES';
Due to the limitations of the Oracle Fusion Cloud Financials API, querying this view requires the use of Finders.
The SpendClassificationSummaryFromSources view supports the 'SummaryFromSourcesFinder' finder. The fields which can be used along with it are
- BindDataset
- BindSupplier
- BindTaxonomyId
- BindBatchNumber
- BindBusinessUnit
- BindBusinessUnitId
- BindCategory
Columns
| Name | Type | Description |
| CategoryName [KEY] | String | Name of the category. |
| TransactionAmount | Decimal | Total amount of a transaction in the functional currency. |
| BindBatchNumber | Long | Number that identifies the batch. |
| BindBusinessUnit | String | Name of the business unit. |
| BindBusinessUnitId | Long | Value that uniquely identifies the business unit. |
| BindCategory | Long | Name of the category. |
| BindDataset | String | Name of the data set. |
| BindSupplier | String | Name of the supplier. |
| BindTaxonomyId | Long | Value that uniquely identifies a taxonomy. |
| Finder | String | Finder criteria used to filter spend classification summary from sources resources based on specific search parameters and conditions. |