Oracle Fusion FSCM endpoint reference

Expense Dff Segments REST API

Get all descriptive flexfield segments for expenses and expense reports

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

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

Supported operations

GET /expenseDffSegments
GET /expenseDffSegments/{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/expenseDffSegments?finder=PrimaryKey

Queryable q fields (42)

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

Example q request

GET /fscmRestApi/resources/11.13.18.05/expenseDffSegments?q=BiEqualizationTag='<value>'&onlyData=true&limit=25
Field Type Operators
ApplicationId integer = !=
BiEnabledFlag boolean = !=
BiEqualizationTag string = !=
CheckboxCheckedValue string = !=
CheckboxUncheckedValue string = !=
ColumnName string = !=
ContextCode string = !=
CreatedBy string = !=
CreationDate string = !=
DefaultType string = !=
DefaultValue string = !=
DefaultValueDate string = !=
DefaultValueNumber number = !=
DefaultValueTimestamp string = !=
DerivationValue string = !=
Description string = !=
DescriptiveFlexfieldCode string = !=
DisplayHeight integer = !=
DisplayType string = !=
DisplayWidth integer = !=
DynamicURL string = !=
EnabledFlag boolean = !=
InFieldHelpText string = !=
IndexedFlag boolean = !=
LastUpdateDate string = !=
LastUpdateLogin string = !=
LastUpdatedBy string = !=
MultirowUniqueKeyFlag boolean = !=
Name string = !=
Prompt string = !=
RangeType string = !=
ReadOnlyFlag boolean = !=
RequiredFlag boolean = !=
RowIdentifier string = !=
SegmentCode string = !=
SegmentIdentifier string = !=
SequenceNumber integer = !=
ShortPrompt string = !=
ShowValueDescription string = !=
TerminologyHelpText string = !=
UOMClass string = !=
ValueSetId integer = !=

Response fields (42)

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

ApplicationIdBiEnabledFlagBiEqualizationTagCheckboxCheckedValueCheckboxUncheckedValueColumnNameContextCodeCreatedByCreationDateDefaultTypeDefaultValueDefaultValueDateDefaultValueNumberDefaultValueTimestampDerivationValueDescriptionDescriptiveFlexfieldCodeDisplayHeightDisplayTypeDisplayWidthDynamicURLEnabledFlagInFieldHelpTextIndexedFlagLastUpdateDateLastUpdateLoginLastUpdatedByMultirowUniqueKeyFlagNamePromptRangeTypeReadOnlyFlagRequiredFlagRowIdentifierSegmentCodeSegmentIdentifierSequenceNumberShortPromptShowValueDescriptionTerminologyHelpTextUOMClassValueSetId

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