SpendClassificationSummaryByCategories
The Spend Classification Summary by Categories resource aggregates the transaction amounts for transactions in a data set organized by category.
Table-Specific Information
Select
The connector uses the Oracle Fusion Cloud Financials API to process some of the filters having 'queryable'='true' in metadata. The connector processes other filters within the connector.
For example, the following query is processed server-side:
SELECT * FROM Procurement.SpendClassificationSummaryByCategories WHERE Finder = 'SummaryByCategoriesFinder' 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 SpendClassificationSummaryByCategories view supports the 'SummaryByCategoriesFinder' finder. The fields which can be used along with it are
- BindDataset
- BindSupplier
- BindTaxonomyId
- BindBatchNumber
- BindBusinessUnit
- BindBusinessUnitId
- BindCategory
Columns
| Name | Type | SupportedFinders | Description |
| CategoryName [KEY] | String | PrimaryKey | Name of the category. |
| TransactionAmount | Decimal | Total amount of a transaction in the functional currency. | |
| BindBatchNumber | Long | SummaryByCategoriesFinder | Number that identifies the batch. |
| BindBusinessUnit | String | SummaryByCategoriesFinder | Name of the business unit. |
| BindBusinessUnitId | Long | SummaryByCategoriesFinder | Value that uniquely identifies the business unit. |
| BindCategory | Long | SummaryByCategoriesFinder | Name of the category. |
| BindDataset | String | SummaryByCategoriesFinder | Name of the data set. |
| BindSupplier | String | SummaryByCategoriesFinder | Name of the supplier. |
| BindTaxonomyId | Long | SummaryByCategoriesFinder | Value that uniquely identifies the taxonomy. |
| Finder | String | Finder criteria used to filter spend classification summary by categories resources based on specific search parameters and conditions. |