Oracle Fusion FSCM endpoint reference

Expense Entertainment Policies REST API

Get all expense entertainment policies

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

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

Supported operations

GET /expenseEntertainmentPolicies
GET /expenseEntertainmentPolicies/{id}

Queryable q fields (56)

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

Example q request

GET /fscmRestApi/resources/11.13.18.05/expenseEntertainmentPolicies?q=CreatedBy='<value>'&onlyData=true&limit=25
Field Type Operators
AttendeeTypesFlag boolean = !=
CreatedBy string = !=
CreationDate string = !=
Currency string = !=
CurrencyCode string = !=
CurrencyOption string = !=
CurrencyOptionCode string = !=
Description string = !=
DispWarningToUserFlag boolean = !=
EmployeeAttendeeAmount string = !=
EmployeeAttendeeAmountCode string = !=
EmployeeAttendeeInformationFlag boolean = !=
EmployeeRateDeterminant string = !=
EmployeeRateDeterminantFlag boolean = !=
EmployeeRequiredAsAttendeeFlag boolean = !=
EmployerCreation string = !=
EmployerCreationFlag boolean = !=
EnabledRateLimitFlag boolean = !=
EntertainmentPolicyId integer = !=
ErrorTolerance number = !=
IndividAttendeeAmountFlag boolean = !=
LastUpdateDate string = !=
LastUpdateLogin string = !=
LastUpdatedBy string = !=
NonEmployeeAttendeeAddrs string = !=
NonEmployeeAttendeeAddrsCode string = !=
NonEmployeeAttendeeAmount string = !=
NonEmployeeAttendeeAmountCode string = !=
NonEmployeeAttendeeInformationFlag boolean = !=
NonEmployeeAttendeeType string = !=
NonEmployeeAttendeeTypeCode string = !=
NonEmployeeCreation string = !=
NonEmployeeCreationFlag boolean = !=
NonEmployeeJobTitle string = !=
NonEmployeeJobTitleCode string = !=
NonEmployeeRateDeterminant string = !=
NonEmployeeRateDeterminantFlag boolean = !=
NonEmployeeRequiredAttendee string = !=
NonEmployeeRequiredAttendeeFlag boolean = !=
NumberOfAttendeesAmount number = !=
NumberOfAttendeesCurrencyCode string = !=
NumberOfAttendeesFlag boolean = !=
PeriodDay integer = !=
PeriodMonth string = !=
PolicyEnforcement string = !=
PolicyEnforcementCode string = !=
PolicyName string = !=
PolicyViolationFlag boolean = !=
PreventSubmissionFlag boolean = !=
RateLimitType string = !=
RateLimitTypeCode string = !=
SingleInstanceLimitFlag boolean = !=
Status string = !=
StatusCode string = !=
WarningTolerance number = !=
YearlyLimitFlag boolean = !=

Child resources (1)

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

expenseEntertainmentPolicyLines

Response fields (57)

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

AttendeeTypesFlagCreatedByCreationDateCurrencyCurrencyCodeCurrencyOptionCurrencyOptionCodeDescriptionDispWarningToUserFlagEmployeeAttendeeAmountEmployeeAttendeeAmountCodeEmployeeAttendeeInformationFlagEmployeeRateDeterminantEmployeeRateDeterminantFlagEmployeeRequiredAsAttendeeFlagEmployerCreationEmployerCreationFlagEnabledRateLimitFlagEntertainmentPolicyIdErrorToleranceIndividAttendeeAmountFlagLastUpdateDateLastUpdateLoginLastUpdatedByNonEmployeeAttendeeAddrsNonEmployeeAttendeeAddrsCodeNonEmployeeAttendeeAmountNonEmployeeAttendeeAmountCodeNonEmployeeAttendeeInformationFlagNonEmployeeAttendeeTypeNonEmployeeAttendeeTypeCodeNonEmployeeCreationNonEmployeeCreationFlagNonEmployeeJobTitleNonEmployeeJobTitleCodeNonEmployeeRateDeterminantNonEmployeeRateDeterminantFlagNonEmployeeRequiredAttendeeNonEmployeeRequiredAttendeeFlagNumberOfAttendeesAmountNumberOfAttendeesCurrencyCodeNumberOfAttendeesFlagPeriodDayPeriodMonthPolicyEnforcementPolicyEnforcementCodePolicyNamePolicyViolationFlagPreventSubmissionFlagRateLimitTypeRateLimitTypeCodeSingleInstanceLimitFlagStatusStatusCodeWarningToleranceYearlyLimitFlagexpenseEntertainmentPolicyLines

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