Supported operations
| GET /expenseMileagePolicies |
| GET /expenseMileagePolicies/{id} |
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/expenseMileagePolicies?finder=PrimaryKey Queryable q fields (53)
Only these fields can appear in a q filter expression on
/expenseMileagePolicies. Filtering on any other field returns
400 Bad Request.
Example q request
GET /fscmRestApi/resources/11.13.18.05/expenseMileagePolicies?q=AdditionalRatesListCode='<value>'&onlyData=true&limit=25
| Field | Type | Operators |
|---|---|---|
| AdditionalRatesListCode | string | = != |
| ApplyThresholdBy | string | = != |
| ApplyThresholdByCode | string | = != |
| CalculationPassRateByDistFlag | boolean | = != |
| CapturePassNamesFlag | boolean | = != |
| CommuteDistanceRequiredFlag | boolean | = != |
| Country | string | = != |
| CountryCode | string | = != |
| CreatedBy | string | = != |
| CreationDate | string | = != |
| Currency | string | = != |
| CurrencyCode | string | = != |
| CurrencyOption | string | = != |
| CurrencyOptionCode | string | = != |
| Description | string | = != |
| DisplayAllUnitsFlag | boolean | = != |
| DistanceThresholdFlag | boolean | = != |
| EligibilityDistance | number | = != |
| EnabledAdditnlRatesFlag | boolean | = != |
| EnabledDeductCommuteFlag | boolean | = != |
| EnabledEligibilityFlag | boolean | = != |
| EnabledFuelTypeFlag | boolean | = != |
| EnabledGenderFlag | boolean | = != |
| EnabledLocationFlag | boolean | = != |
| EnabledMaximumPassFlag | boolean | = != |
| EnabledPassengerFlag | boolean | = != |
| EnabledRoleFlag | boolean | = != |
| EnabledStandardDeductionFlag | boolean | = != |
| EnabledVehCategoryFlag | boolean | = != |
| EnabledVehTypeFlag | boolean | = != |
| FuelTypeListCode | string | = != |
| LastUpdateDate | string | = != |
| LastUpdateLogin | string | = != |
| LastUpdatedBy | string | = != |
| LocationType | string | = != |
| LocationTypeCode | string | = != |
| MaximumPassengers | integer | = != |
| MileageDeduction | number | = != |
| MileagePolicyId | integer | = != |
| PassengerRule | string | = != |
| PassengerRuleCode | string | = != |
| PolicyName | string | = != |
| PolicyRole | string | = != |
| PolicyRoleCode | string | = != |
| StandardDeductionCode | string | = != |
| Status | string | = != |
| StatusCode | string | = != |
| UnitOfMeasure | string | = != |
| UnitOfMeasureCode | string | = != |
| VehicleCategoryListCode | string | = != |
| VehicleTypeListCode | string | = != |
| ZoneType | string | = != |
| ZoneTypeCode | string | = != |
Child resources (1)
Each child is reachable at
/expenseMileagePolicies/{id}/child/<name>
and most can also be inlined with expand.
expenseMileagePolicyLines Response fields (54)
Top-level attributes returned for each row. Use
fields= to request a subset and shrink the payload.
AdditionalRatesListCodeApplyThresholdByApplyThresholdByCodeCalculationPassRateByDistFlagCapturePassNamesFlagCommuteDistanceRequiredFlagCountryCountryCodeCreatedByCreationDateCurrencyCurrencyCodeCurrencyOptionCurrencyOptionCodeDescriptionDisplayAllUnitsFlagDistanceThresholdFlagEligibilityDistanceEnabledAdditnlRatesFlagEnabledDeductCommuteFlagEnabledEligibilityFlagEnabledFuelTypeFlagEnabledGenderFlagEnabledLocationFlagEnabledMaximumPassFlagEnabledPassengerFlagEnabledRoleFlagEnabledStandardDeductionFlagEnabledVehCategoryFlagEnabledVehTypeFlagFuelTypeListCodeLastUpdateDateLastUpdateLoginLastUpdatedByLocationTypeLocationTypeCodeMaximumPassengersMileageDeductionMileagePolicyIdPassengerRulePassengerRuleCodePolicyNamePolicyRolePolicyRoleCodeStandardDeductionCodeStatusStatusCodeUnitOfMeasureUnitOfMeasureCodeVehicleCategoryListCodeVehicleTypeListCodeZoneTypeZoneTypeCodeexpenseMileagePolicyLines 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
- /jointVentureBasicGeneratedDistributions Get all distributions for joint venture generated transactions
- /expenseEntertainmentPolicies Get all expense entertainment policies
- /taxExemptions Get all tax exemptions
- /jointVentureBasicSLADistributions Get all joint venture subledger distributions
- /ledgerBalances Get all account balances
- 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