// fusionrest agent · financials

Expense Reports

expenseReports Based on 26C

Create, change and look up Expense Reports, with expense, expense payment and expense notes. Actions include apply cash advances and process WF action.

The record key expenseReportsUniqID 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/expenseReports
Operations
GET (list)GET (one)POST (create)PATCH (update)7 actions
Record key
expenseReportsUniqID
Required on create
OrgId
At a glance
47 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/expenseReports?fields=AssignmentId,AuditCode,AuditCodeName,AuditReturnReasonCode,BothpayFlag&limit=25&onlyData=true
Response shape (placeholders)
{
  "items": [
    {
      "AssignmentId": 0,
      "AuditCode": "<string, max 30>",
      "AuditCodeName": "<string, max 80>",
      "AuditReturnReasonCode": "<string, max 30>",
      "BothpayFlag": false
    }
  ],
  "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 47

AttributeTypeUse
AssignmentIdnumberOptional on createUpdatableSearchable
AuditCodetext · max 30Optional on createUpdatableSearchable
AuditCodeNametext · max 80Read-onlySearchable
AuditReturnReasonCodetext · max 30Optional on createUpdatableSearchable
BothpayFlagyes/no · max 1Optional on createUpdatableSearchable
BusinessUnittext · max 240Optional on createUpdatableSearchable
CreatedBytext · max 64Read-onlySearchable
CreationDatedate-timeRead-onlySearchable
CurrentApproverIdnumberOptional on createUpdatableSearchable
CurrentApproverstext · max 2550Read-onlySearchable
ExchangeRateTypetext · max 30Optional on createUpdatableSearchable
ExpenseReportDatedateOptional on createUpdatableSearchable
ExpenseReportIdnumberOptional on createUpdatableSearchable
ExpenseReportNumbertext · max 50Optional on createUpdatableSearchable
ExpenseReportStatustext · max 80Read-onlySearchable
ExpenseReportTotalnumberOptional on createUpdatableSearchable
ExpenseStatusCodetext · max 30Optional on createUpdatableSearchable
ExpenseStatusDatedateOptional on createUpdatableSearchable
FinalApprovalDatedateOptional on createUpdatableSearchable
ImagedReceiptsReceivedDatedateOptional on createUpdatableSearchable
ImagedReceiptsStatustext · max 80Read-onlySearchable
ImagedReceiptsStatusCodetext · max 30Optional on createUpdatableSearchable
LastUpdateDatedate-timeRead-onlySearchable
LastUpdateLogintext · max 32Read-onlySearchable
LastUpdatedBytext · max 64Read-onlySearchable
MatchExpensestextOptional on createUpdatable
MissingImagesReasontext · max 80Optional on createUpdatableSearchable
OrgIdnumberRequired on createUpdatableSearchable
OriginalReceiptsStatustext · max 80Read-onlySearchable
OverrideApproverIdnumberOptional on createUpdatableSearchable
ParentExpenseReportIdnumberOptional on createUpdatableSearchable
PaymentMethodCodetext · max 120Optional on createUpdatableSearchable
PersonIdnumberOptional on createUpdatableSearchable
PersonNametext · max 240Read-onlySearchable
PreparerIdnumberOptional on createUpdatableSearchable
Purposetext · max 240Optional on createUpdatableSearchable
ReceiptsFilingNumbertext · max 240Optional on createUpdatableSearchable
ReceiptsReceivedDatedateOptional on createUpdatableSearchable
ReceiptsStatusCodetext · max 30Optional on createUpdatableSearchable
ReimbursementCurrencyCodetext · max 15Optional on createUpdatableSearchable
ReportCreationMethodCodetext · max 30Optional on createUpdatableSearchable
ReportSubmitDatedateOptional on createUpdatableSearchable
SubmitErrorstextOptional on createUpdatable
SubmitReporttextOptional on createUpdatable
TripIdnumberOptional on createUpdatableSearchable
UnappliedAdvancesJusttext · max 240Optional on createUpdatableSearchable
UnappliedCashAdvReasontext · max 240Optional on createUpdatableSearchable

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/expenseReports/{expenseReportsUniqID}/child/<name>. Add them to a GET with expand.

Actions 7

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