Oracle Fusion FSCM endpoint reference

Joint Venture Options REST API

Get all joint venture options

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

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

Supported operations

GET /jointVentureOptions
GET /jointVentureOptions/{id}
PATCH /jointVentureOptions/{id}
POST /jointVentureOptions

Queryable q fields (40)

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

Example q request

GET /fscmRestApi/resources/11.13.18.05/jointVentureOptions?q=createdBy='<value>'&onlyData=true&limit=25
Field Type Operators
applicationId integer = !=
carriedInterestEnabledFlag boolean = !=
createdBy string = !=
creationDate string = !=
defaultGeneralLedgerTransactionDate string = !=
defaultGeneralLedgerTransactionDateDescription string = !=
defaultSubledgerAccountingTransactionDate string = !=
defaultSubledgerAccountingTransactionDateDescription string = !=
emailBody string = !=
emailSubject string = !=
excludeNonDistributableTransactionsFlag boolean = !=
generalLedgerTransactionDateReference string = !=
lastUpdateDate string = !=
lastUpdatedBy string = !=
overrideTaskNumber string = !=
primarySegmentLabelCode string = !=
primarySegmentLabelDescription string = !=
projectAttribute string = !=
stakeholderReportingEnabledFlag boolean = !=
subledgerAccountingExpenditureBusinessUnitIdReference string = !=
subledgerAccountingExpenditureBusinessUnitIdReferenceDescription string = !=
subledgerAccountingExpenditureBusinessUnitIdReferenceName string = !=
subledgerAccountingExpenditureItemDateReference string = !=
subledgerAccountingExpenditureItemDateReferenceDescription string = !=
subledgerAccountingExpenditureItemDateReferenceName string = !=
subledgerAccountingExpenditureOrganizationIdReference string = !=
subledgerAccountingExpenditureOrganizationIdReferenceDescription string = !=
subledgerAccountingExpenditureOrganizationIdReferenceName string = !=
subledgerAccountingExpenditureTypeIdReference string = !=
subledgerAccountingExpenditureTypeIdReferenceDescription string = !=
subledgerAccountingExpenditureTypeIdReferenceName string = !=
subledgerAccountingProjectIdReference string = !=
subledgerAccountingProjectIdReferenceDescription string = !=
subledgerAccountingProjectIdReferenceName string = !=
subledgerAccountingReferenceDescription string = !=
subledgerAccountingReferenceName string = !=
subledgerAccountingTaskIdReference string = !=
subledgerAccountingTaskIdReferenceDescription string = !=
subledgerAccountingTaskIdReferenceName string = !=
subledgerAccountingTransactionDateReference string = !=

Child resources (1)

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

optionsDFF

Response fields (47)

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

applicationIdcarriedInterestEnabledFlagcreatedBycreationDatedefaultGeneralLedgerTransactionDatedefaultGeneralLedgerTransactionDateDescriptiondefaultSubledgerAccountingTransactionDatedefaultSubledgerAccountingTransactionDateDescriptionemailBodyemailSubjectexcludeNonDistributableTransactionsFlaggeneralLedgerReferenceDescriptiongeneralLedgerTransactionDateReferencelastUpdateDatelastUpdatedByoptionsDFFoverrideExpenditureTypeoverrideExpenditureTypeDescriptionoverrideTaskNumberprimarySegmentLabelCodeprimarySegmentLabelDescriptionprimarySegmentLabelNameprojectAttributeprojectAttributeAPINameprojectAttributeSegmentstakeholderReportingEnabledFlagsubledgerAccountingExpenditureBusinessUnitIdReferencesubledgerAccountingExpenditureBusinessUnitIdReferenceDescriptionsubledgerAccountingExpenditureBusinessUnitIdReferenceNamesubledgerAccountingExpenditureItemDateReferencesubledgerAccountingExpenditureItemDateReferenceDescriptionsubledgerAccountingExpenditureItemDateReferenceNamesubledgerAccountingExpenditureOrganizationIdReferencesubledgerAccountingExpenditureOrganizationIdReferenceDescriptionsubledgerAccountingExpenditureOrganizationIdReferenceNamesubledgerAccountingExpenditureTypeIdReferencesubledgerAccountingExpenditureTypeIdReferenceDescriptionsubledgerAccountingExpenditureTypeIdReferenceNamesubledgerAccountingProjectIdReferencesubledgerAccountingProjectIdReferenceDescriptionsubledgerAccountingProjectIdReferenceNamesubledgerAccountingReferenceDescriptionsubledgerAccountingReferenceNamesubledgerAccountingTaskIdReferencesubledgerAccountingTaskIdReferenceDescriptionsubledgerAccountingTaskIdReferenceNamesubledgerAccountingTransactionDateReference

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