// fusionrest agent · financials

Expense Cash Advances

expenseCashAdvances Based on 26C

Create, change, delete and look up Expense Cash Advances.

The record key expenseCashAdvancesUniqID is a generated hash. Take it from the record's links (rel self) in a GET response; never build it yourself.

Oracle documents an Effective-Of header and an effectiveDate parameter for this resource, used for date-effective reads and changes.

/fscmRestApi/resources/11.13.18.05/expenseCashAdvances
Operations
GET (list)GET (one)POST (create)PATCH (update)DELETE
Record key
expenseCashAdvancesUniqID
Required on create
CashAdvanceNumber
At a glance
35 fields0 finders2 children
Extra parameters
?effectiveDate=Effective-Of:
I want to…List the latest 25Count recordsGet one recordCreate oneUpdate one

Try it

Response fields ·
Filters (q)

Only attributes Oracle marks as searchable are offered.

Include children (expand)
Paging and options
limit
Endpoint and headers
GET /fscmRestApi/resources/11.13.18.05/expenseCashAdvances?fields=AdjustedAmount,AdvanceStatus,Amount,AssignmentId,BusinessUnit&limit=25&onlyData=true
Response shape (placeholders)
{
  "items": [
    {
      "AdjustedAmount": 0,
      "AdvanceStatus": "<string, max 255>",
      "Amount": 0,
      "AssignmentId": 0,
      "BusinessUnit": "<string, max 240>"
    }
  ],
  "count": 25,
  "hasMore": true,
  "limit": 25,
  "offset": 0
}

Shapes and placeholders, not real data. Replace https://<your-pod> and the login with your own: this site never sees them. Based on Oracle's 26C REST specification.

Fields 35

AttributeTypeUse
AdjustedAmountnumberOptional on createUpdatableSearchable
AdvanceStatustext · max 255Optional on createUpdatableSearchable
AmountnumberOptional on createUpdatableSearchable
AssignmentIdnumberOptional on createSearchable
BusinessUnittext · max 240Read-onlySearchable
CashAdvanceIdnumberOptional on createSearchable
CashAdvanceNumbertext · max 60Required on createSearchable
CashAdvanceTypetext · max 255Optional on createUpdatableSearchable
CreatedBytext · max 64Read-onlySearchable
CreationDatedate-timeRead-onlySearchable
Currencytext · max 80Read-onlySearchable
CurrencyCodetext · max 15Optional on createUpdatableSearchable
Descriptiontext · max 240Optional on createUpdatableSearchable
EmployeeNumbertext · max 255Optional on createSearchable
ExchangeRatenumberRead-onlySearchable
LastUpdateDatedate-timeRead-onlySearchable
LastUpdateLogintext · max 32Read-onlySearchable
LastUpdatedBytext · max 64Read-onlySearchable
Locationtext · max 200Read-onlySearchable
PaymentAmountnumberOptional on createSearchable
PaymentCurrencytext · max 80Read-onlySearchable
PaymentCurrencyCodetext · max 15Optional on createSearchable
PaymentMethodCodetext · max 120Optional on createUpdatableSearchable
PersonIdnumberOptional on createSearchable
PersonNametext · max 255Optional on createSearchable
Purposetext · max 240Optional on createUpdatableSearchable
SequoiaAdvanceStatustext · max 255Read-onlySearchable
SequoiaStatusCodetext · max 255Read-onlySearchable
SettlementDatedateOptional on createUpdatableSearchable
StatusCodetext · max 30Optional on createUpdatableSearchable
SubmittedDatedateOptional on createUpdatableSearchable
TripEndDatedateOptional on createUpdatableSearchable
TripIdnumberRead-onlySearchable
TripStartDatedateOptional on createUpdatableSearchable
UnappliedAmountnumberOptional on createUpdatableSearchable

Names, types, labels and flags from Oracle's REST specification (26C). Flexfield and custom attributes vary by pod: check /describe for yours.

Check a payload

Checked in your browser only; nothing you paste is sent anywhere. Checks names and flags, not values.

Children 2

Child resources sit under one record: /fscmRestApi/resources/11.13.18.05/expenseCashAdvances/{expenseCashAdvancesUniqID}/child/<name>. Add them to a GET with expand.

Use in AI Agent Studio

More in For Builders.

Pitfalls