Supported operations
| DELETE /expenseCashAdvances/{id} |
| GET /expenseCashAdvances |
| GET /expenseCashAdvances/{id} |
| PATCH /expenseCashAdvances/{id} |
| POST /expenseCashAdvances |
Finders (1)
Finders are named, pre-built queries with bound parameters. They can search values plain
q filters cannot reach.
| Finder | Bind variables |
|---|---|
| PrimaryKey | — |
Example finder request
GET /fscmRestApi/resources/11.13.18.05/expenseCashAdvances?finder=PrimaryKey Queryable q fields (35)
Only these fields can appear in a q filter expression on
/expenseCashAdvances. Filtering on any other field returns
400 Bad Request.
Example q request
GET /fscmRestApi/resources/11.13.18.05/expenseCashAdvances?q=AdvanceStatus='<value>'&onlyData=true&limit=25
| Field | Type | Operators |
|---|---|---|
| AdjustedAmount | number | = != |
| AdvanceStatus | string | = != |
| Amount | number | = != |
| AssignmentId | integer | = != |
| BusinessUnit | string | = != |
| CashAdvanceId | integer | = != |
| CashAdvanceNumber | string | = != |
| CashAdvanceType | string | = != |
| CreatedBy | string | = != |
| CreationDate | string | = != |
| Currency | string | = != |
| CurrencyCode | string | = != |
| Description | string | = != |
| EmployeeNumber | string | = != |
| ExchangeRate | number | = != |
| LastUpdateDate | string | = != |
| LastUpdateLogin | string | = != |
| LastUpdatedBy | string | = != |
| Location | string | = != |
| PaymentAmount | number | = != |
| PaymentCurrency | string | = != |
| PaymentCurrencyCode | string | = != |
| PaymentMethodCode | string | = != |
| PersonId | integer | = != |
| PersonName | string | = != |
| Purpose | string | = != |
| SequoiaAdvanceStatus | string | = != |
| SequoiaStatusCode | string | = != |
| SettlementDate | string | = != |
| StatusCode | string | = != |
| SubmittedDate | string | = != |
| TripEndDate | string | = != |
| TripId | integer | = != |
| TripStartDate | string | = != |
| UnappliedAmount | number | = != |
Child resources (2)
Each child is reachable at
/expenseCashAdvances/{id}/child/<name>
and most can also be inlined with expand.
AttachmentsCashAdvanceDff Response fields (37)
Top-level attributes returned for each row. Use
fields= to request a subset and shrink the payload.
AdjustedAmountAdvanceStatusAmountAssignmentIdAttachmentsBusinessUnitCashAdvanceDffCashAdvanceIdCashAdvanceNumberCashAdvanceTypeCreatedByCreationDateCurrencyCurrencyCodeDescriptionEmployeeNumberExchangeRateLastUpdateDateLastUpdateLoginLastUpdatedByLocationPaymentAmountPaymentCurrencyPaymentCurrencyCodePaymentMethodCodePersonIdPersonNamePurposeSequoiaAdvanceStatusSequoiaStatusCodeSettlementDateStatusCodeSubmittedDateTripEndDateTripIdTripStartDateUnappliedAmount 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
- /dataAccessSetLedgersLOV Get all ledgers or ledger sets
- /payablesAndProcurementOptions Get payables and procurement options for all business units
- /receivablesCreditMemos Get all receivables credit memos
- /expenseDffSegments Get all descriptive flexfield segments for expenses and expense reports
- /payeeBankAccountsLOV Get all payee bank accounts
- 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