Oracle Fusion FSCM endpoint reference

Expense Travel Itineraries REST API

Get all travel itineraries

GET https://your-pod.oraclecloud.com/fscmRestApi/resources/11.13.18.05/expenseTravelItineraries

Everything on this page is extracted from Oracle's official OpenAPI specification for Fusion Cloud FSCM: 16 queryable q fields, and 1 child resource. Unsure how q works? See the Oracle Fusion API guide.

Supported operations

GET /expenseTravelItineraries
GET /expenseTravelItineraries/{id}
PATCH /expenseTravelItineraries/{id}
POST /expenseTravelItineraries

Queryable q fields (16)

Only these fields can appear in a q filter expression on /expenseTravelItineraries. Filtering on any other field returns 400 Bad Request.

Example q request

GET /fscmRestApi/resources/11.13.18.05/expenseTravelItineraries?q=BookingDateTime='<value>'&onlyData=true&limit=25
Field Type Operators
BookingDateTime string = !=
BookingSiteName string = !=
CreatedBy string = !=
CreationDate string = !=
EmployeeNumber string = !=
FirstName string = !=
ItineraryRecordLocator string = !=
LastName string = !=
LastUpdateDate string = !=
LastUpdateLogin string = !=
LastUpdatedBy string = !=
StatusCode string = !=
TravelItineraryId integer = !=
TravelPartnerName string = !=
TravelPartnerTripNumber string = !=
TripId integer = !=

Child resources (1)

Each child is reachable at /expenseTravelItineraries/{id}/child/<name> and most can also be inlined with expand.

itineraryReservations

Response fields (17)

Top-level attributes returned for each row. Use fields= to request a subset and shrink the payload.

BookingDateTimeBookingSiteNameCreatedByCreationDateEmployeeNumberFirstNameItineraryRecordLocatorLastNameLastUpdateDateLastUpdateLoginLastUpdatedByStatusCodeTravelItineraryIdTravelPartnerNameTravelPartnerTripNumberTripIditineraryReservations

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