Supported operations
| DELETE /jointVentures/{id} |
| GET /jointVentures |
| GET /jointVentures/{id} |
| PATCH /jointVentures/{id} |
| POST /jointVentures |
Finders (4)
Finders are named, pre-built queries with bound parameters. They can search values plain
q filters cannot reach.
| Finder | Bind variables |
|---|---|
| PrimaryKey | — |
| findByName | — |
| findByStatus | — |
| jointVentureFinder | — |
Example finder request
GET /fscmRestApi/resources/11.13.18.05/jointVentures?finder=PrimaryKey Queryable q fields (62)
Only these fields can appear in a q filter expression on
/jointVentures. Filtering on any other field returns
400 Bad Request.
Example q request
GET /fscmRestApi/resources/11.13.18.05/jointVentures?q=approvedDate='<value>'&onlyData=true&limit=25
| Field | Type | Operators |
|---|---|---|
| approvedDate | string | = != |
| approvedFlag | boolean | = != |
| billWhenPaidFlag | boolean | = != |
| billableAssetAccountSet | string | = != |
| businessUnitName | string | = != |
| chartOfAccountsInstanceName | string | = != |
| classification | string | = != |
| createdBy | string | = != |
| creationDate | string | = != |
| currencyCode | string | = != |
| defaultLedger | string | = != |
| defaultOwnershipDefinitionName | string | = != |
| distributableAccountSet | string | = != |
| distributionOnlyAccountSet | string | = != |
| emailAddress | string | = != |
| excludeJointVentureTransactionsFlag | boolean | = != |
| inceptionDate | string | = != |
| jibOutputFormat | string | = != |
| jibTemplateName | string | = != |
| jointVentureDescription | string | = != |
| jointVentureId | integer | = != |
| jointVentureShortName | string | = != |
| jointVentureStatus | string | = != |
| lastUpdateDate | string | = != |
| lastUpdatedBy | string | = != |
| ledgerPeriodSet | string | = != |
| ledgerPeriodType | string | = != |
| legalEntity | string | = != |
| liabilityAccount | string | = != |
| minimumAPInvoiceAmount | number | = != |
| minimumARInvoiceAmount | number | = != |
| receivableAccount | string | = != |
| segment10Flag | boolean | = != |
| segment11Flag | boolean | = != |
| segment12Flag | boolean | = != |
| segment13Flag | boolean | = != |
| segment14Flag | boolean | = != |
| segment15Flag | boolean | = != |
| segment16Flag | boolean | = != |
| segment17Flag | boolean | = != |
| segment18Flag | boolean | = != |
| segment19Flag | boolean | = != |
| segment1Flag | boolean | = != |
| segment20Flag | boolean | = != |
| segment21Flag | boolean | = != |
| segment22Flag | boolean | = != |
| segment23Flag | boolean | = != |
| segment24Flag | boolean | = != |
| segment25Flag | boolean | = != |
| segment26Flag | boolean | = != |
| segment27Flag | boolean | = != |
| segment28Flag | boolean | = != |
| segment29Flag | boolean | = != |
| segment2Flag | boolean | = != |
| segment30Flag | boolean | = != |
| segment3Flag | boolean | = != |
| segment4Flag | boolean | = != |
| segment5Flag | boolean | = != |
| segment6Flag | boolean | = != |
| segment7Flag | boolean | = != |
| segment8Flag | boolean | = != |
| segment9Flag | boolean | = != |
Child resources (8)
Each child is reachable at
/jointVentures/{id}/child/<name>
and most can also be inlined with expand.
attachmentsdistributableProjectRulesjointVentureCostCentersjointVentureDFFmessagesownershipDefinitionsstakeholderReportingBooksstakeholders Response fields (134)
Top-level attributes returned for each row. Use
fields= to request a subset and shrink the payload.
approvedDateapprovedFlagattachmentsbillWhenPaidFlagbillableAssetAccountSetbusinessUnitNamechartOfAccountsInstanceNameclassificationcostCenterSegmentcreatedBycreationDatecurrencyCodedefaultLedgerdefaultOwnershipDefinitionNamedistributableAccountSetdistributableProjectRulesdistributionOnlyAccountSetemailAddressexcludeJointVentureTransactionsFlaginceptionDatejibOutputFormatjibTemplateNamejointVentureCostCentersjointVentureDFFjointVentureDescriptionjointVentureIdjointVentureShortNamejointVentureStatuslastUpdateDatelastUpdatedByledgerPeriodSetledgerPeriodTypelegalEntityliabilityAccountmessagesminimumAPInvoiceAmountminimumARInvoiceAmountownershipDefinitionsprojectSetreceivableAccountsegment10Flagsegment10Labelsegment10ValueSetCodesegment11Flagsegment11Labelsegment11ValueSetCodesegment12Flagsegment12Labelsegment12ValueSetCodesegment13Flagsegment13Labelsegment13ValueSetCodesegment14Flagsegment14Labelsegment14ValueSetCodesegment15Flagsegment15Labelsegment15ValueSetCodesegment16Flagsegment16Labelsegment16ValueSetCodesegment17Flagsegment17Labelsegment17ValueSetCodesegment18Flagsegment18Labelsegment18ValueSetCodesegment19Flagsegment19Labelsegment19ValueSetCodesegment1Flagsegment1Labelsegment1ValueSetCodesegment20Flagsegment20Labelsegment20ValueSetCodesegment21Flagsegment21Labelsegment21ValueSetCodesegment22Flagsegment22Labelsegment22ValueSetCodesegment23Flagsegment23Labelsegment23ValueSetCodesegment24Flagsegment24Labelsegment24ValueSetCodesegment25Flagsegment25Labelsegment25ValueSetCodesegment26Flagsegment26Labelsegment26ValueSetCodesegment27Flagsegment27Labelsegment27ValueSetCodesegment28Flagsegment28Labelsegment28ValueSetCodesegment29Flagsegment29Labelsegment29ValueSetCodesegment2Flagsegment2Labelsegment2ValueSetCodesegment30Flagsegment30Labelsegment30ValueSetCodesegment3Flagsegment3Labelsegment3ValueSetCodesegment4Flagsegment4Labelsegment4ValueSetCodesegment5Flagsegment5Labelsegment5ValueSetCodesegment6Flagsegment6Labelsegment6ValueSetCodesegment7Flagsegment7Labelsegment7ValueSetCodesegment8Flagsegment8Labelsegment8ValueSetCodesegment9Flagsegment9Labelsegment9ValueSetCodestakeholderReportingBooksstakeholdersstructureInstanceNumbertransactionsExistFlag 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
- /jointVentureSLADistributions Get all joint venture subledger distributions
- /payablesPayments Get all payments
- /expensePerDiemPolicies Get all expense per diem policies
- /cashExternalTransactions Get all external transactions
- /jointVentureGLDistributions Get all joint venture general ledger distributions
- Oracle Fusion API guide
- Why the q parameter fails and how to fix it
- Finders: named queries in Oracle Fusion REST APIs
- All endpoint reference pages