// fusionrest agent · financials

Expenses

expenses Based on 26C

Create, change, delete and look up Expenses, with expense attendee, expense distribution and expense itemization. Actions include notification request and send email notification.

The record key expensesUniqID 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/expenses
Operations
GET (list)GET (one)POST (create)PATCH (update)DELETE3 actions
Record key
expensesUniqID
Required on create
AssignmentIdOrgIdPersonIdTicketClass
At a glance
132 fields3 finders15 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.

Finder
Include children (expand)
Paging and options
limit
Endpoint and headers
GET /fscmRestApi/resources/11.13.18.05/expenses?fields=AgencyName,AssignmentId,AttachmentExists,AuditAdjustmentReason,AuditAdjustmentReasonCode&limit=25&onlyData=true
Response shape (placeholders)
{
  "items": [
    {
      "AgencyName": "<string, max 80>",
      "AssignmentId": 0,
      "AttachmentExists": "<string, max 1>",
      "AuditAdjustmentReason": "<string, max 240>",
      "AuditAdjustmentReasonCode": "<string, max 30>"
    }
  ],
  "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 132

AttributeTypeUse
AgencyNametext · max 80Optional on createUpdatableSearchable
AssignmentIdnumberRequired on createUpdatableSearchable
AttachmentExiststext · max 1Read-onlySearchable
AuditAdjustmentReasontext · max 240Optional on createUpdatableSearchable
AuditAdjustmentReasonCodetext · max 30Optional on createUpdatableSearchable
AuthTrxnNumbertext · max 240Optional on createUpdatableSearchable
AutoSubmitDatedate-timeOptional on createUpdatableSearchable
AwtGroupIdnumberOptional on createUpdatableSearchable
BilledAmountnumberOptional on createUpdatable
BilledCurrencyCodetextOptional on createUpdatable
BusinessUnittext · max 240Optional on createUpdatableSearchable
CardIdnumberRead-onlySearchable
CcAuthorizationIdentifiertext · max 240Optional on createUpdatableSearchable
CcNetworkReferenceNumbertext · max 240Optional on createUpdatableSearchable
CheckoutDatedateOptional on createUpdatableSearchable
CountryCodetextOptional on createUpdatableSearchable
CreatedBytext · max 64Read-onlySearchable
CreationDatedate-timeRead-onlySearchable
CreditCardTrxnIdnumberRead-onlySearchable
DailyAmountnumberOptional on createUpdatable
DailyDistancenumberOptional on createUpdatableSearchable
DailyLimittextOptional on createUpdatable
DepartureLocationIdnumberOptional on createUpdatableSearchable
Descriptiontext · max 240Optional on createUpdatableSearchable
DestinationFromtext · max 4000Optional on createUpdatableSearchable
DestinationTotext · max 4000Optional on createUpdatableSearchable
DistanceUnittext · max 80Read-onlySearchable
DistanceUnitCodetext · max 30Optional on createUpdatableSearchable
EndDatetextOptional on createUpdatable
EndDateTimestampdate-timeRead-onlySearchable
EndOdometernumberOptional on createUpdatableSearchable
ExchangeRatenumberOptional on createUpdatableSearchable
ExpenseCategoryCodetext · max 30Optional on createUpdatableSearchable
ExpenseCreationMethodCodetext · max 30Optional on createUpdatableSearchable
ExpenseIdnumberOptional on createUpdatableSearchable
ExpenseReferencenumberOptional on createUpdatableSearchable
ExpenseReportIdnumberOptional on createUpdatableSearchable
ExpenseReportStatustext · max 30Read-onlySearchable
ExpenseSourcetext · max 30Optional on createUpdatableSearchable
ExpenseSourceNametext · max 80Read-onlySearchable
ExpenseTemplatetext · max 80Optional on createUpdatableSearchable
ExpenseTemplateIdnumberOptional on createUpdatableSearchable
ExpenseTypetext · max 80Optional on createUpdatableSearchable
ExpenseTypeCategoryCodetext · max 30Optional on createUpdatableSearchable
ExpenseTypeIdnumberOptional on createUpdatableSearchable
FlightClassLimittextOptional on createUpdatable
FlightDurationnumberOptional on createUpdatableSearchable
FlightNumbertext · max 80Optional on createUpdatableSearchable
FuelTypetext · max 30Optional on createUpdatableSearchable
FuelTypeNametextOptional on createUpdatableSearchable
ImageReceiptRequiredFlagyes/no · max 1Optional on createUpdatableSearchable
ItemizationParentExpenseIdnumberOptional on createUpdatableSearchable
ItemizationReceiptBusinessTotalAmountnumberOptional on createUpdatable
ItemizationReceiptPersonalTotalAmountnumberOptional on createUpdatable
ItineraryReservationIdnumberOptional on createUpdatableSearchable
Justificationtext · max 240Optional on createUpdatableSearchable
JustificationRequiredFlagyes/no · max 1Optional on createUpdatableSearchable
LastUpdateDatedate-timeRead-onlySearchable
LastUpdateLogintext · max 32Read-onlySearchable
LastUpdatedBytext · max 64Read-onlySearchable
LicensePlateNumbertext · max 30Optional on createUpdatableSearchable
Locationtext · max 80Optional on createUpdatableSearchable
LocationIdnumberOptional on createUpdatableSearchable
LongTermTripFlagyes/no · max 1Optional on createUpdatableSearchable
LongTermTripStartDatedateOptional on createUpdatableSearchable
MerchantDocumentNumbertext · max 80Optional on createUpdatableSearchable
MerchantNametext · max 80Optional on createUpdatableSearchable
MerchantReferencetext · max 240Optional on createUpdatableSearchable
MerchantTaxRegNumbertext · max 80Optional on createUpdatableSearchable
MerchantTaxpayerIdtext · max 80Optional on createUpdatableSearchable
MergedParentExpenseIdnumberOptional on createUpdatableSearchable
MileagePolicyIdnumberOptional on createUpdatable
NumberOfAttendeesnumberOptional on createUpdatableSearchable
NumberOfDaysnumberOptional on createUpdatable
NumberPeoplenumberOptional on createUpdatableSearchable
OrgIdnumberRequired on createUpdatableSearchable
PassengerAmountnumberOptional on createUpdatableSearchable
PassengerNametext · max 240Optional on createUpdatableSearchable
PassengerRateTypetext · max 30Optional on createUpdatableSearchable
PaymentDueFromCodetextOptional on createUpdatable
PersonIdnumberRequired on createUpdatableSearchable
PersonNametext · max 240Optional on createUpdatableSearchable
PersonalReceiptAmountnumberOptional on createUpdatableSearchable
PolicyShortpayFlagyes/no · max 1Optional on createUpdatableSearchable
PolicyViolatedFlagyes/no · max 1Optional on createUpdatableSearchable
PolicyWarningFlagyes/no · max 1Optional on createUpdatableSearchable
PolicyWarningReasonCodetext · max 30Optional on createUpdatableSearchable
PrepaidFlagyes/no · max 1Optional on createUpdatableSearchable
PreparerIdnumberOptional on createUpdatableSearchable
RatePerPassengernumberOptional on createUpdatableSearchable
ReceiptAmountnumberOptional on createUpdatableSearchable
ReceiptCurrencytext · max 80Optional on createUpdatableSearchable
ReceiptCurrencyCodetext · max 15Optional on createUpdatableSearchable
ReceiptDatedateOptional on createUpdatable
ReceiptMissingDecRequiredFlagyes/no · max 1Optional on createUpdatableSearchable
ReceiptMissingFlagyes/no · max 1Optional on createUpdatableSearchable
ReceiptRequiredFlagyes/no · max 1Optional on createUpdatableSearchable
ReceiptTimedate-timeOptional on createUpdatableSearchable
ReceiptVerifiedFlagyes/no · max 1Optional on createUpdatableSearchable
ReferenceNumbertext · max 240Read-onlySearchable
ReimbursableAmountnumberOptional on createUpdatableSearchable
ReimbursementCurrencytext · max 80Optional on createUpdatableSearchable
ReimbursementCurrencyCodetext · max 15Optional on createUpdatableSearchable
RequestnumberRead-onlySearchable
SequenceNumbernumberOptional on createUpdatableSearchable
StartDatedateOptional on createUpdatable
StartDateTimestampdate-timeRead-onlySearchable
StartOdometernumberOptional on createUpdatableSearchable
TaxClassificationtextOptional on createUpdatableSearchable
TaxClassificationCodetext · max 30Optional on createUpdatableSearchable
TicketClasstext · max 80Required on createUpdatableSearchable
TicketClassCodetext · max 30Optional on createUpdatableSearchable
TicketNumbertext · max 80Optional on createUpdatableSearchable
TipAmountnumberOptional on createUpdatableSearchable
TravelMethodCodetext · max 30Optional on createUpdatableSearchable
TravelTypetext · max 30Optional on createUpdatableSearchable
TravelTypeNametextOptional on createUpdatableSearchable
TripDistancenumberOptional on createUpdatableSearchable
UOMDaysnumberOptional on createUpdatableSearchable
ValidateExpensetextOptional on createUpdatable
ValidationErrorFlagyes/noOptional on createUpdatable
ValidationErrorMessagestextOptional on createUpdatable
ValidationStatustext · max 30Optional on createUpdatableSearchable
ValidationWarningMessagestextOptional on createUpdatable
VehicleCategorytextOptional on createUpdatableSearchable
VehicleCategoryCodetext · max 30Optional on createUpdatableSearchable
VehicleTypetext · max 30Optional on createUpdatableSearchable
VehicleTypeNametextOptional on createUpdatableSearchable
VendorExpenseReferenceIdnumberOptional on createUpdatableSearchable
VisitedFlagyes/no · max 1Optional on createUpdatableSearchable
ZoneCodetext · max 30Optional on createUpdatableSearchable
ZoneTypeCodetextOptional on createUpdatable

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

Finders 3

Predefined searches: ?finder=Name;variable=value,variable2=value2. Pick one in Try it to build the call.

Check a payload

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

Children 15

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

Actions 3

Actions use Content-Type: application/vnd.oracle.adf.action+json. A path with a {key} runs on one record.

Use in AI Agent Studio

More in For Builders.

Pitfalls