Supported operations
| GET /expenseReports |
| GET /expenseReports/{id} |
| PATCH /expenseReports/{id} |
| POST /expenseReports |
Finders (4)
Finders are named, pre-built queries with bound parameters. They can search values plain
q filters cannot reach.
| Finder | Bind variables |
|---|---|
| PrimaryKey | — |
| bothpayReportsFinder | — |
| findByBusinessUnit | — |
| shortpaidReportsFinder | — |
Example finder request
GET /fscmRestApi/resources/11.13.18.05/expenseReports?finder=PrimaryKey Queryable q fields (44)
Only these fields can appear in a q filter expression on
/expenseReports. Filtering on any other field returns
400 Bad Request.
Example q request
GET /fscmRestApi/resources/11.13.18.05/expenseReports?q=AuditCode='<value>'&onlyData=true&limit=25
| Field | Type | Operators |
|---|---|---|
| AssignmentId | integer | = != |
| AuditCode | string | = != |
| AuditCodeName | string | = != |
| AuditReturnReasonCode | string | = != |
| BothpayFlag | boolean | = != |
| BusinessUnit | string | = != |
| CreatedBy | string | = != |
| CreationDate | string | = != |
| CurrentApproverId | integer | = != |
| CurrentApprovers | string | = != |
| ExchangeRateType | string | = != |
| ExpenseReportDate | string | = != |
| ExpenseReportId | integer | = != |
| ExpenseReportNumber | string | = != |
| ExpenseReportStatus | string | = != |
| ExpenseReportTotal | number | = != |
| ExpenseStatusCode | string | = != |
| ExpenseStatusDate | string | = != |
| FinalApprovalDate | string | = != |
| ImagedReceiptsReceivedDate | string | = != |
| ImagedReceiptsStatus | string | = != |
| ImagedReceiptsStatusCode | string | = != |
| LastUpdateDate | string | = != |
| LastUpdateLogin | string | = != |
| LastUpdatedBy | string | = != |
| MissingImagesReason | string | = != |
| OrgId | integer | = != |
| OriginalReceiptsStatus | string | = != |
| OverrideApproverId | integer | = != |
| ParentExpenseReportId | integer | = != |
| PaymentMethodCode | string | = != |
| PersonId | integer | = != |
| PersonName | string | = != |
| PreparerId | integer | = != |
| Purpose | string | = != |
| ReceiptsFilingNumber | string | = != |
| ReceiptsReceivedDate | string | = != |
| ReceiptsStatusCode | string | = != |
| ReimbursementCurrencyCode | string | = != |
| ReportCreationMethodCode | string | = != |
| ReportSubmitDate | string | = != |
| TripId | integer | = != |
| UnappliedAdvancesJust | string | = != |
| UnappliedCashAdvReason | string | = != |
Child resources (6)
Each child is reachable at
/expenseReports/{id}/child/<name>
and most can also be inlined with expand.
AttachmentsExpenseExpensePaymentExpenseReportDffexpenseNotesprocessingDetails Response fields (53)
Top-level attributes returned for each row. Use
fields= to request a subset and shrink the payload.
AssignmentIdAttachmentsAuditCodeAuditCodeNameAuditReturnReasonCodeBothpayFlagBusinessUnitCreatedByCreationDateCurrentApproverIdCurrentApproversExchangeRateTypeExpenseExpensePaymentExpenseReportDateExpenseReportDffExpenseReportIdExpenseReportNumberExpenseReportStatusExpenseReportTotalExpenseStatusCodeExpenseStatusDateFinalApprovalDateImagedReceiptsReceivedDateImagedReceiptsStatusImagedReceiptsStatusCodeLastUpdateDateLastUpdateLoginLastUpdatedByMatchExpensesMissingImagesReasonOrgIdOriginalReceiptsStatusOverrideApproverIdParentExpenseReportIdPaymentMethodCodePersonIdPersonNamePreparerIdPurposeReceiptsFilingNumberReceiptsReceivedDateReceiptsStatusCodeReimbursementCurrencyCodeReportCreationMethodCodeReportSubmitDateSubmitErrorsSubmitReportTripIdUnappliedAdvancesJustUnappliedCashAdvReasonexpenseNotesprocessingDetails 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
- /receivablesInvoices Get all receivables invoices
- /journalBatches Get all batches
- /payablesInterfaceInvoices Get all interface invoices
- /expensePerDiemPolicies Get all expense per diem policies
- /jointVentures Get all joint ventures
- 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