Supported operations
| GET /expensePerDiemPolicies |
| GET /expensePerDiemPolicies/{id} |
Queryable q fields (111)
Only these fields can appear in a q filter expression on
/expensePerDiemPolicies. Filtering on any other field returns
400 Bad Request.
Example q request
GET /fscmRestApi/resources/11.13.18.05/expensePerDiemPolicies?q=AccomDeductCalcMeth='<value>'&onlyData=true&limit=25
| Field | Type | Operators |
|---|---|---|
| AccomDeductCalcMeth | string | = != |
| AccomDeductCalcMethCode | string | = != |
| AccomDeductionFlag | boolean | = != |
| AccomEligibEndHour | integer | = != |
| AccomEligibEndMinute | integer | = != |
| AccomEligibStartHour | integer | = != |
| AccomEligibStartMinute | integer | = != |
| AccomFreeOnlyFlag | boolean | = != |
| AccomMinDurationHours | integer | = != |
| AccomMinDurationMinutes | integer | = != |
| AccomMinNightHoursStay | integer | = != |
| AccomMinTripDuratFlag | boolean | = != |
| AccomRateCalcMethod | string | = != |
| AccomRateCalcMethodCode | string | = != |
| AccomReqMealsEligibFlag | boolean | = != |
| AllowActualExpenseFlag | boolean | = != |
| AllowRateConversionFlag | boolean | = != |
| BreakfastEligEndHour | integer | = != |
| BreakfastEligEndMinute | integer | = != |
| BreakfastEligStartHour | integer | = != |
| BreakfastEligStartMinute | integer | = != |
| CreatedBy | string | = != |
| CreationDate | string | = != |
| Currency | string | = != |
| CurrencyCode | string | = != |
| CurrencyOption | string | = != |
| CurrencyOptionCode | string | = != |
| DayTravelEligibHours | integer | = != |
| Description | string | = != |
| DinnerEligEndHour | integer | = != |
| DinnerEligEndMinute | integer | = != |
| DinnerEligStartHour | integer | = != |
| DinnerEligStartMinute | integer | = != |
| EnabledAccomTypeFlag | boolean | = != |
| EnabledLocationFlag | boolean | = != |
| EnabledLongTermFlag | boolean | = != |
| EnabledRoleFlag | boolean | = != |
| EnabledSeasonRateFlag | boolean | = != |
| EnabledWeekendHolidFlag | boolean | = != |
| FreeMealDeduction | string | = != |
| FreeMealDeductionCode | string | = != |
| HolidayCalcMethod | string | = != |
| HolidayCalcMethodCode | string | = != |
| LastUpdateDate | string | = != |
| LastUpdateLogin | string | = != |
| LastUpdatedBy | string | = != |
| LocationType | string | = != |
| LocationTypeCode | string | = != |
| LongTermCalcMeth | string | = != |
| LongTermCalcMethod | string | = != |
| LunchEligEndHour | integer | = != |
| LunchEligEndMinute | integer | = != |
| LunchEligStartHour | integer | = != |
| LunchEligStartMinute | integer | = != |
| MealDeductionFlag | boolean | = != |
| MealInclIncidentalFlag | boolean | = != |
| MealRateType | string | = != |
| MealRateTypeCode | string | = != |
| MealsAmountLimit | number | = != |
| MealsCalcMethod | string | = != |
| MealsCalcMethodCode | string | = != |
| MealsDeductCalcMeth | string | = != |
| MealsDeductCalcMethCode | string | = != |
| MealsDeduction | string | = != |
| MealsDeductionCode | string | = != |
| MealsRateSource | string | = != |
| MealsRateSourceCode | string | = != |
| MinDistanceFromHome | number | = != |
| MinDistanceFromOffice | number | = != |
| MinDurationHours | integer | = != |
| MinDurationMinutes | integer | = != |
| MinTripDuratFlag | boolean | = != |
| MinimumReimbursement | number | = != |
| ObjectVersionNumber | integer | = != |
| OthersCalcMethod | string | = != |
| OthersCalcMethodCode | string | = != |
| OthersEligibCriteria | string | = != |
| OthersEligibCriteriaCode | string | = != |
| PerDiemPolicyId | integer | = != |
| PerdiemPolicyType | string | = != |
| PolicyName | string | = != |
| PolicyRole | string | = != |
| PolicyRoleCode | string | = != |
| RateFormulaMethod | string | = != |
| RateFormulaMethodCode | string | = != |
| RateIncludeAccomFlag | boolean | = != |
| RateIncludeMealsFlag | boolean | = != |
| RateIncludeOtherFlag | boolean | = != |
| RateMultiplier | string | = != |
| RateMultiplierCode | string | = != |
| RatesSource | string | = != |
| RatesSourceCode | string | = != |
| RoleCalcMethod | string | = != |
| SpecificFirstLastDayFlag | boolean | = != |
| Status | string | = != |
| StatusMeaning | string | = != |
| TimeAllowSameDayFlag | boolean | = != |
| TimeBasedRateModelFlag | boolean | = != |
| TimeCalcMethod | string | = != |
| TimeCalcMethodCode | string | = != |
| TimePeriod | string | = != |
| TimePeriodCode | string | = != |
| TimeSameDayCalcMeth | string | = != |
| TimeSameDayCalcMethod | string | = != |
| TimeSameDayRule | string | < |
| TimeSameDayRuleCode | string | = != |
| WeekendDay1Code | string | = != |
| WeekendDay2Code | string | = != |
| WithinEmployeeCityFlag | boolean | = != |
| ZoneType | string | = != |
| ZoneTypeCode | string | = != |
Child resources (2)
Each child is reachable at
/expensePerDiemPolicies/{id}/child/<name>
and most can also be inlined with expand.
expensePerDiemPolLinesexpensePerDiemPolValues Response fields (113)
Top-level attributes returned for each row. Use
fields= to request a subset and shrink the payload.
AccomDeductCalcMethAccomDeductCalcMethCodeAccomDeductionFlagAccomEligibEndHourAccomEligibEndMinuteAccomEligibStartHourAccomEligibStartMinuteAccomFreeOnlyFlagAccomMinDurationHoursAccomMinDurationMinutesAccomMinNightHoursStayAccomMinTripDuratFlagAccomRateCalcMethodAccomRateCalcMethodCodeAccomReqMealsEligibFlagAllowActualExpenseFlagAllowRateConversionFlagBreakfastEligEndHourBreakfastEligEndMinuteBreakfastEligStartHourBreakfastEligStartMinuteCreatedByCreationDateCurrencyCurrencyCodeCurrencyOptionCurrencyOptionCodeDayTravelEligibHoursDescriptionDinnerEligEndHourDinnerEligEndMinuteDinnerEligStartHourDinnerEligStartMinuteEnabledAccomTypeFlagEnabledLocationFlagEnabledLongTermFlagEnabledRoleFlagEnabledSeasonRateFlagEnabledWeekendHolidFlagFreeMealDeductionFreeMealDeductionCodeHolidayCalcMethodHolidayCalcMethodCodeLastUpdateDateLastUpdateLoginLastUpdatedByLocationTypeLocationTypeCodeLongTermCalcMethLongTermCalcMethodLunchEligEndHourLunchEligEndMinuteLunchEligStartHourLunchEligStartMinuteMealDeductionFlagMealInclIncidentalFlagMealRateTypeMealRateTypeCodeMealsAmountLimitMealsCalcMethodMealsCalcMethodCodeMealsDeductCalcMethMealsDeductCalcMethCodeMealsDeductionMealsDeductionCodeMealsRateSourceMealsRateSourceCodeMinDistanceFromHomeMinDistanceFromOfficeMinDurationHoursMinDurationMinutesMinTripDuratFlagMinimumReimbursementObjectVersionNumberOthersCalcMethodOthersCalcMethodCodeOthersEligibCriteriaOthersEligibCriteriaCodePerDiemPolicyIdPerdiemPolicyTypePolicyNamePolicyRolePolicyRoleCodeRateFormulaMethodRateFormulaMethodCodeRateIncludeAccomFlagRateIncludeMealsFlagRateIncludeOtherFlagRateMultiplierRateMultiplierCodeRatesSourceRatesSourceCodeRoleCalcMethodSpecificFirstLastDayFlagStatusStatusMeaningTimeAllowSameDayFlagTimeBasedRateModelFlagTimeCalcMethodTimeCalcMethodCodeTimePeriodTimePeriodCodeTimeSameDayCalcMethTimeSameDayCalcMethodTimeSameDayRuleTimeSameDayRuleCodeWeekendDay1CodeWeekendDay2CodeWithinEmployeeCityFlagZoneTypeZoneTypeCodeexpensePerDiemPolLinesexpensePerDiemPolValues 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
- /jointVentures Get all joint ventures
- /jointVentureSLADistributions Get all joint venture subledger distributions
- /payablesPayments Get all payments
- /journalBatches Get all batches
- /cashExternalTransactions Get all external transactions
- 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