Oracle Fusion FSCM endpoint reference

Joint Venture Operational Measures REST API

Get all operational measures for the joint venture journal

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

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

Supported operations

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

Queryable q fields (22)

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

Example q request

GET /fscmRestApi/resources/11.13.18.05/jointVentureOperationalMeasures?q=createdBy='<value>'&onlyData=true&limit=25
Field Type Operators
accountingHeaderId integer = !=
createdBy string = !=
creationDate string = !=
documentNumber string = !=
jointVenture string = !=
jointVentureDescription string = !=
lastUpdateDate string = !=
lastUpdatedBy string = !=
measureDate string = !=
measureLineNumber integer = !=
measureLineType string = !=
measureStatus string = !=
measureType string = !=
measureTypeDescription string = !=
measureValue number = !=
measureValueType string = !=
operationalMeasureId integer = !=
primarySegment string = !=
reference string = !=
segmentValue string = !=
segmentValueDescription string = !=
unitOfMeasure string = !=

Child resources (1)

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

operationalMeasureDFF

Response fields (23)

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

accountingHeaderIdcreatedBycreationDatedocumentNumberjointVenturejointVentureDescriptionlastUpdateDatelastUpdatedBymeasureDatemeasureLineNumbermeasureLineTypemeasureStatusmeasureTypemeasureTypeDescriptionmeasureValuemeasureValueTypeoperationalMeasureDFFoperationalMeasureIdprimarySegmentreferencesegmentValuesegmentValueDescriptionunitOfMeasure

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