Oracle Fusion FSCM endpoint reference

Localization Document Sequence Derivations REST API

Get all document sequence derivation records

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

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

Supported operations

DELETE /localizationDocumentSequenceDerivations/{id}
GET /localizationDocumentSequenceDerivations
GET /localizationDocumentSequenceDerivations/{id}
PATCH /localizationDocumentSequenceDerivations/{id}
POST /localizationDocumentSequenceDerivations

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/localizationDocumentSequenceDerivations?finder=PrimaryKey

Queryable q fields (21)

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

Example q request

GET /fscmRestApi/resources/11.13.18.05/localizationDocumentSequenceDerivations?q=ContextDerivationCode='<value>'&onlyData=true&limit=25
Field Type Operators
BusinessUnitId integer = !=
ContextDerivationCode string = !=
DocumentSequenceContext1 string = !=
DocumentSequenceContext10 string = !=
DocumentSequenceContext2 string = !=
DocumentSequenceContext3 string = !=
DocumentSequenceContext4 string = !=
DocumentSequenceContext5 string = !=
DocumentSequenceContext6 string = !=
DocumentSequenceContext7 string = !=
DocumentSequenceContext8 string = !=
DocumentSequenceContext9 string = !=
DocumentSequenceDerivationId integer = !=
DocumentSequenceName string = !=
EffectiveEndDate string = !=
EffectiveStartDate string = !=
PrefixSuffixValue1 string = !=
PrefixSuffixValue2 string = !=
PrefixSuffixValue3 string = !=
PrefixSuffixValue4 string = !=
PrefixSuffixValue5 string = !=

Response fields (28)

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

BusinessUnitIdBusinessUnitNameContextDerivationCodeCreatedByCreationDateDocumentSequenceContext1DocumentSequenceContext10DocumentSequenceContext2DocumentSequenceContext3DocumentSequenceContext4DocumentSequenceContext5DocumentSequenceContext6DocumentSequenceContext7DocumentSequenceContext8DocumentSequenceContext9DocumentSequenceDerivationIdDocumentSequenceNameEffectiveEndDateEffectiveStartDateLastUpdateDateLastUpdateLoginLastUpdatedByObjectVersionNumberPrefixSuffixValue1PrefixSuffixValue2PrefixSuffixValue3PrefixSuffixValue4PrefixSuffixValue5

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