Supported operations
| GET /expenseTypes |
| GET /expenseTypes/{id} |
Finders (2)
Finders are named, pre-built queries with bound parameters. They can search values plain
q filters cannot reach.
| Finder | Bind variables |
|---|---|
| PrimaryKey | — |
| findByTemplateIdAndDate | — |
Example finder request
GET /fscmRestApi/resources/11.13.18.05/expenseTypes?finder=PrimaryKey Queryable q fields (37)
Only these fields can appear in a q filter expression on
/expenseTypes. Filtering on any other field returns
400 Bad Request.
Example q request
GET /fscmRestApi/resources/11.13.18.05/expenseTypes?q=BusinessUnit='<value>'&onlyData=true&limit=25
| Field | Type | Operators |
|---|---|---|
| BusinessUnit | string | = != |
| Category | string | = != |
| CategoryCode | string | = != |
| CcReceiptRequiredFlag | boolean | = != |
| CcReceiptThreshold | number | = != |
| CreatedBy | string | = != |
| CreationDate | string | = != |
| DefaultProjExpendType | integer | = != |
| Description | string | = != |
| DescriptionBehaviour | string | = != |
| DescriptionBehaviourCode | string | = != |
| DispRcptViolationFlag | boolean | = != |
| EnableProjectsFlag | boolean | = != |
| EndDate | string | = != |
| ExpenseTemplateId | integer | = != |
| ExpenseTypeId | integer | = != |
| ItemizationBehaviour | string | = != |
| ItemizationBehaviourCode | string | = != |
| ItemizationOnlyFlag | boolean | = != |
| LastUpdateDate | string | = != |
| LastUpdateLogin | string | = != |
| LastUpdatedBy | string | = != |
| LocationBehaviour | string | = != |
| LocationBehaviourCode | string | = != |
| MerchantBehaviour | string | = != |
| MerchantBehaviourCode | string | = != |
| Name | string | = != |
| NegativeRcptRequiredCode | string | = != |
| NumberOfDaysBehaviour | string | = != |
| NumberOfDaysBehaviourCode | string | = != |
| OrgId | integer | = != |
| RcptRequiredProjFlag | boolean | = != |
| ReceiptRequiredFlag | boolean | = != |
| ReceiptThreshold | number | = != |
| StartDate | string | = != |
| TaxClassification | string | = != |
| TaxClassificationCode | string | = != |
Child resources (3)
Each child is reachable at
/expenseTypes/{id}/child/<name>
and most can also be inlined with expand.
itemizedExpenseTypespreferredAgencyListspreferredMerchantLists Response fields (41)
Top-level attributes returned for each row. Use
fields= to request a subset and shrink the payload.
BusinessUnitCategoryCategoryCodeCcReceiptRequiredFlagCcReceiptThresholdCreatedByCreationDateDefaultProjExpendTypeDescriptionDescriptionBehaviourDescriptionBehaviourCodeDispRcptViolationCodeDispRcptViolationFlagEnableProjectsFlagEndDateExpenseTemplateIdExpenseTypeIdItemizationBehaviourItemizationBehaviourCodeItemizationOnlyFlagLastUpdateDateLastUpdateLoginLastUpdatedByLocationBehaviourLocationBehaviourCodeMerchantBehaviourMerchantBehaviourCodeNameNegativeRcptRequiredCodeNumberOfDaysBehaviourNumberOfDaysBehaviourCodeOrgIdRcptRequiredProjFlagReceiptRequiredFlagReceiptThresholdStartDateTaxClassificationTaxClassificationCodeitemizedExpenseTypespreferredAgencyListspreferredMerchantLists Build this query visually in OPAL
OPAL bundles this endpoint — and 59,000+ more — fully searchable offline, with a visual Q Builder and Finder Builder that only offer the fields listed above, so your filter can't 400. Download free · see features.
Related reference & reading
- /transactionTaxLines Get all transaction tax lines
- /jointVentureBasicGLDistributions Get all joint venture general ledger distributions
- /paymentsExternalPayees Get all external payees
- /taxRegistrations Get all tax registrations
- /expenseEntertainmentPolicies Get all expense entertainment policies
- Oracle Fusion API guide
- Why the q parameter fails and how to fix it
- Finders: named queries in Oracle Fusion REST APIs
- All endpoint reference pages