Joint Ventures
jointVentures Based on 26C
Create, change, delete and look up Joint Ventures, with distributable project rules, excluded subledgers and joint venture cost centers.
- Operations
- GET (list)GET (one)POST (create)PATCH (update)DELETE
- Record key
jointVentureId- Required on create
jointVentureShortName- At a glance
- 131 fields3 finders19 children
Try it
Only attributes Oracle marks as searchable are offered.
GET /fscmRestApi/resources/11.13.18.05/jointVentures?fields=approvedDate,approvedFlag,billWhenPaidFlag,billableAssetAccountSet,businessUnitName&limit=25&onlyData=true
{
"items": [
{
"approvedDate": "2026-01-31",
"approvedFlag": false,
"billWhenPaidFlag": false,
"billableAssetAccountSet": "<string, max 30>",
"businessUnitName": "<string>"
}
],
"count": 25,
"hasMore": true,
"limit": 25,
"offset": 0
}Shapes and placeholders, not real data. Replace https://<your-pod> and the login with your own: this site never sees them. Based on Oracle's 26C REST specification.
Fields 131
| Attribute | Type | Use |
|---|---|---|
approvedDate | date | Optional on createUpdatableSearchable |
approvedFlag | yes/no · max 1 · default false | Optional on createUpdatableSearchable |
billWhenPaidFlag | yes/no · max 1 · default false | Optional on createUpdatableSearchable |
billableAssetAccountSet | text · max 30 | Optional on createUpdatableSearchable |
businessUnitName | text | Optional on createUpdatableSearchable |
chartOfAccountsInstanceName | text · max 60 | Read-onlySearchable |
classification | text | Optional on createUpdatableSearchable |
costCenterSegment | number | Read-only |
createdBy | text · max 64 | Read-onlySearchable |
creationDate | date-time | Read-onlySearchable |
currencyCode | text | Read-onlySearchable |
defaultLedger | text | Read-onlySearchable |
defaultOwnershipDefinitionName | text · max 30 | Optional on createUpdatableSearchable |
distributableAccountSet | text · max 30 | Optional on createUpdatableSearchable |
distributionOnlyAccountSet | text · max 30 | Optional on createUpdatableSearchable |
emailAddress | text · max 100 | Optional on createUpdatableSearchable |
excludeJointVentureTransactionsFlag | yes/no · max 1 | Optional on createUpdatableSearchable |
inceptionDate | date | Optional on createUpdatableSearchable |
includeCostReversalFlag | yes/no · max 1 · default false | Optional on createUpdatableSearchable |
includeRevenueInPartnerContributionsFlag | yes/no · max 1 · default false | Optional on createUpdatableSearchable |
includeRevenueReversalFlag | yes/no · max 1 · default false | Optional on createUpdatableSearchable |
invoiceNettingDocumentOption | text · max 80 | Optional on createUpdatableSearchable |
invoiceNettingEnabledFlag | yes/no · max 1 · default false | Optional on createUpdatableSearchable |
jibOutputFormat | text | Optional on createUpdatableSearchable |
jibTemplateName | text · max 100 | Optional on createUpdatableSearchable |
jointVentureDescription | text · max 240 | Optional on createUpdatableSearchable |
jointVentureId | number | Read-onlySearchable |
jointVentureShortName | text · max 30 | Required on createSearchable |
jointVentureStatus | text | Optional on createUpdatableSearchable |
lastUpdateDate | date-time | Read-onlySearchable |
lastUpdatedBy | text · max 64 | Read-onlySearchable |
ledgerPeriodSet | text · max 15 | Read-onlySearchable |
ledgerPeriodType | text · max 15 | Read-onlySearchable |
legalEntity | text | Optional on createUpdatableSearchable |
liabilityAccount | text · max 255 | Optional on createUpdatableSearchable |
minimumAPInvoiceAmount | number · default 0 | Optional on createUpdatableSearchable |
minimumARInvoiceAmount | number · default 0 | Optional on createUpdatableSearchable |
projectSet | text · max 30 | Optional on createUpdatable |
receivableAccount | text | Optional on createUpdatableSearchable |
segment10Flag | yes/no · max 1 · default false | Optional on createUpdatableSearchable |
segment10Label | text | Read-only |
segment10ValueSetCode | text | Read-only |
segment11Flag | yes/no · max 1 · default false | Optional on createUpdatableSearchable |
segment11Label | text | Read-only |
segment11ValueSetCode | text | Read-only |
segment12Flag | yes/no · max 1 · default false | Optional on createUpdatableSearchable |
segment12Label | text | Read-only |
segment12ValueSetCode | text | Read-only |
segment13Flag | yes/no · max 1 · default false | Optional on createUpdatableSearchable |
segment13Label | text | Read-only |
segment13ValueSetCode | text | Read-only |
segment14Flag | yes/no · max 1 · default false | Optional on createUpdatableSearchable |
segment14Label | text | Read-only |
segment14ValueSetCode | text | Read-only |
segment15Flag | yes/no · max 1 · default false | Optional on createUpdatableSearchable |
segment15Label | text | Read-only |
segment15ValueSetCode | text | Read-only |
segment16Flag | yes/no · max 1 · default false | Optional on createUpdatableSearchable |
segment16Label | text | Read-only |
segment16ValueSetCode | text | Read-only |
segment17Flag | yes/no · max 1 · default false | Optional on createUpdatableSearchable |
segment17Label | text | Read-only |
segment17ValueSetCode | text | Read-only |
segment18Flag | yes/no · max 1 · default false | Optional on createUpdatableSearchable |
segment18Label | text | Read-only |
segment18ValueSetCode | text | Read-only |
segment19Flag | yes/no · max 1 · default false | Optional on createUpdatableSearchable |
segment19Label | text | Read-only |
segment19ValueSetCode | text | Read-only |
segment1Flag | yes/no · max 1 · default false | Optional on createUpdatableSearchable |
segment1Label | text | Read-only |
segment1ValueSetCode | text | Read-only |
segment20Flag | yes/no · max 1 · default false | Optional on createUpdatableSearchable |
segment20Label | text | Read-only |
segment20ValueSetCode | text | Read-only |
segment21Flag | yes/no · max 1 · default false | Optional on createUpdatableSearchable |
segment21Label | text | Read-only |
segment21ValueSetCode | text | Read-only |
segment22Flag | yes/no · max 1 · default false | Optional on createUpdatableSearchable |
segment22Label | text | Read-only |
segment22ValueSetCode | text | Read-only |
segment23Flag | yes/no · max 1 · default false | Optional on createUpdatableSearchable |
segment23Label | text | Read-only |
segment23ValueSetCode | text | Read-only |
segment24Flag | yes/no · max 1 · default false | Optional on createUpdatableSearchable |
segment24Label | text | Read-only |
segment24ValueSetCode | text | Read-only |
segment25Flag | yes/no · max 1 · default false | Optional on createUpdatableSearchable |
segment25Label | text | Read-only |
segment25ValueSetCode | text | Read-only |
segment26Flag | yes/no · max 1 · default false | Optional on createUpdatableSearchable |
segment26Label | text | Read-only |
segment26ValueSetCode | text | Read-only |
segment27Flag | yes/no · max 1 · default false | Optional on createUpdatableSearchable |
segment27Label | text | Read-only |
segment27ValueSetCode | text | Read-only |
segment28Flag | yes/no · max 1 · default false | Optional on createUpdatableSearchable |
segment28Label | text | Read-only |
segment28ValueSetCode | text | Read-only |
segment29Flag | yes/no · max 1 · default false | Optional on createUpdatableSearchable |
segment29Label | text | Read-only |
segment29ValueSetCode | text | Read-only |
segment2Flag | yes/no · max 1 · default false | Optional on createUpdatableSearchable |
segment2Label | text | Read-only |
segment2ValueSetCode | text | Read-only |
segment30Flag | yes/no · max 1 · default false | Optional on createUpdatableSearchable |
segment30Label | text | Read-only |
segment30ValueSetCode | text | Read-only |
segment3Flag | yes/no · max 1 · default false | Optional on createUpdatableSearchable |
segment3Label | text | Read-only |
segment3ValueSetCode | text | Read-only |
segment4Flag | yes/no · max 1 · default false | Optional on createUpdatableSearchable |
segment4Label | text | Read-only |
segment4ValueSetCode | text | Read-only |
segment5Flag | yes/no · max 1 · default false | Optional on createUpdatableSearchable |
segment5Label | text | Read-only |
segment5ValueSetCode | text | Read-only |
segment6Flag | yes/no · max 1 · default false | Optional on createUpdatableSearchable |
segment6Label | text | Read-only |
segment6ValueSetCode | text | Read-only |
segment7Flag | yes/no · max 1 · default false | Optional on createUpdatableSearchable |
segment7Label | text | Read-only |
segment7ValueSetCode | text | Read-only |
segment8Flag | yes/no · max 1 · default false | Optional on createUpdatableSearchable |
segment8Label | text | Read-only |
segment8ValueSetCode | text | Read-only |
segment9Flag | yes/no · max 1 · default false | Optional on createUpdatableSearchable |
segment9Label | text | Read-only |
segment9ValueSetCode | text | Read-only |
structureInstanceNumber | number | Read-only |
transactionsExistFlag | yes/no | Read-only |
Names, types, labels and flags from Oracle's REST specification (26C). Flexfield and custom attributes vary by pod: check /describe for yours.
Finders 3
Predefined searches: ?finder=Name;variable=value,variable2=value2. Pick one in Try it to build the call.
findByName·jointVentureShortNamefindByStatus·jointVentureStatusCodejointVentureFinder·approvedDateapprovedFlagbusinessUnitNamechartOfAccountsInstanceNamejointVentureDescriptionjointVentureShortNamejointVentureStatussearchAllText
Check a payload
Checked in your browser only; nothing you paste is sent anywhere. Checks names and flags, not values.
Children 19
Child resources sit under one record: /fscmRestApi/resources/11.13.18.05/jointVentures/{jointVentureId}/child/<name>. Add them to a GET with expand.
attachmentsGET · POST · PATCH · DELETE Attachments · 32 fields · 1 findersAsyncTrackerIdAttachedDocumentIdCategoryNameContentRepositoryFileSharedCreatedByCreatedByUserNameCreationDateDatatypeCodeDescriptionDmDocumentIdDmFolderPathDmVersionNumberDownloadInfoErrorStatusCodeErrorStatusMessageExpirationDateFileContentsFileNameFileUrlFileWebImageLastUpdateDateLastUpdatedByLastUpdatedByUserNamePostProcessingActionTitleUploadedFileContentTypeUploadedFileLengthUploadedFileNameUploadedTextUriUrlUserNamedistributableProjectRulesGET · POST · PATCH · DELETE Distributable Project Rules · 11 fields · 9 finderscreatedBycreationDatedistributableProjectRuleIdexpenditureTypeexpenditureTypeDescriptionlastUpdateDatelastUpdatedByprojectprojectNametasktaskNamedistributableProjectDFFGET · POST · PATCH Distributable Project Rule Descriptive Flexfields · 3 fields · 1 findersDistributableProjectValueId__FLEX_Context__FLEX_Context_DisplayValueexcludedSubledgersGET · POST · DELETE Excluded Subledgers · 8 fields · 1 findersapplicationapplicationDescriptionapplicationShortNamecreatedBycreationDateexcludedSubledgerIdlastUpdateDatelastUpdatedByjointVentureCostCentersGET · POST · DELETE Cost Centers · 5 fieldscostCenterIdcostCenterSegmentDescriptioncostCenterSegmentValuecreatedBycreationDatecostCenterDFFGET · POST · PATCH Cost Center Descriptive Flexfields · 3 fieldsCostCenterId__FLEX_Context__FLEX_Context_DisplayValuedistributableValueSetsGET · POST · PATCH · DELETE Distributable Value Sets · 65 fieldscreatedBycreationDatedistributableValuesIdlastUpdateDatelastUpdatedBysegment10Descriptionsegment10Valuesegment11Descriptionsegment11Valuesegment12Descriptionsegment12Valuesegment13Descriptionsegment13Valuesegment14Descriptionsegment14Valuesegment15Descriptionsegment15Valuesegment16Descriptionsegment16Valuesegment17Descriptionsegment17Valuesegment18Descriptionsegment18Valuesegment19Descriptionsegment19Valuesegment1Descriptionsegment1Valuesegment20Descriptionsegment20Valuesegment21Descriptionsegment21Valuesegment22Descriptionsegment22Valuesegment23Descriptionsegment23Valuesegment24Descriptionsegment24Valuesegment25Descriptionsegment25Valuesegment26Descriptionsegment26Valuesegment27Descriptionsegment27Valuesegment28Descriptionsegment28Valuesegment29Descriptionsegment29Valuesegment2Descriptionsegment2Valuesegment30Descriptionsegment30Valuesegment3Descriptionsegment3Valuesegment4Descriptionsegment4Valuesegment5Descriptionsegment5Valuesegment6Descriptionsegment6Valuesegment7Descriptionsegment7Valuesegment8Descriptionsegment8Valuesegment9Descriptionsegment9ValuedistributableValueSetDFFGET · POST · PATCH Distributable Value Set Descriptive Flexfields · 3 fields · 1 findersDistributableValuesId__FLEX_Context__FLEX_Context_DisplayValuejointVentureDFFGET · POST · PATCH Joint Venture Descriptive Flexfieds · 3 fieldsJointVentureId__FLEX_Context__FLEX_Context_DisplayValuemessagesGET Joint Venture Messages · 3 fieldsdetailerrorCoderesourceTypeownershipDefinitionsGET · POST · PATCH · DELETE Ownership Definitions · 29 fields · 1 findersactiveFlagagreementcarriedInterestSourceOwnershipFlagchangeReasonchangeReasonAdditionalTextcreatedBycreationDatedefaultOwnershipDefinitionFlagdistributionExisteffectiveEndDateeffectiveStartDateexternalStakeholderExistsFlaginternalStakeholderExistsFlagjointVentureDescriptionjointVentureNamelastUpdateDatelastUpdatedByownershipChangeFlagownershipChangeTypeownershipDefinitionDescriptionownershipDefinitionIdownershipDefinitionShortNameownershipDefinitionStatusownershipVersionsourceOwnershipDefinitionsourceOwnershipDefinitionDescriptionstakeholderGroupstakeholderGroupDescriptiontotalPercentageattachmentsGET · POST · PATCH · DELETE Attachments · 32 fields · 1 findersAsyncTrackerIdAttachedDocumentIdCategoryNameContentRepositoryFileSharedCreatedByCreatedByUserNameCreationDateDatatypeCodeDescriptionDmDocumentIdDmFolderPathDmVersionNumberDownloadInfoErrorStatusCodeErrorStatusMessageExpirationDateFileContentsFileNameFileUrlFileWebImageLastUpdateDateLastUpdatedByLastUpdatedByUserNamePostProcessingActionTitleUploadedFileContentTypeUploadedFileLengthUploadedFileNameUploadedTextUriUrlUserNameownershipDefinitionDFFGET · POST · PATCH Ownership Definition Descriptive Flexfields · 3 fieldsOwnershipPercentageId__FLEX_Context__FLEX_Context_DisplayValueownershipPercentagesGET · POST · PATCH · DELETE Ownership Percentages · 13 fields · 1 finderscreatedBycreationDatedistributionOnlyFlaginternalStakeholderFlaginvoicingPartnerIdlastUpdateDatelastUpdatedByownershipDefinitionNameownershipPercentageIdpercentageOfInterestroundingPartnerFlagstakeholderDescriptionstakeholderNameownershipPercentageDFFGET · POST · PATCH Ownership Percentage Descriptive Flexfields · 3 fieldsOwnershipLineId__FLEX_Context__FLEX_Context_DisplayValuestakeholderReportingBooksGET · POST · PATCH · DELETE Stakeholder Reporting Books · 10 fields · 6 finderscreatedBycreationDatelastUpdateDatelastUpdatedBysourceLedgersourceLedgerDescriptionstakeholderLedgerstakeholderLedgerDescriptionstakeholderReportingBookIdstatusstakeholdersGET · POST · PATCH · DELETE Stakeholders · 27 fields · 2 findersclassificationcostCenterSegmentValuecreatedBycreationDatedistributionOnlyFlagincludeCostReversalFlagincludeRevenueReversalFlaginternalStakeholderFlaginvoiceNettingDocumentOptioninvoiceNettingEnabledFlaginvoicingPartnerNamejibOutputFormatjibTemplateNamelastUpdateDatelastUpdatedByoverrideInvoiceNettingFlagpartyAddresspartyEmailpartyNamepartyNumberpartyPhonepreferredCurrencyCodestakeholderDescriptionstakeholderIdstakeholderShortNamestakeholderStatusstakeholderTypeCodeattachmentsGET · POST · PATCH · DELETE Attachments · 32 fields · 1 findersAsyncTrackerIdAttachedDocumentIdCategoryNameContentRepositoryFileSharedCreatedByCreatedByUserNameCreationDateDatatypeCodeDescriptionDmDocumentIdDmFolderPathDmVersionNumberDownloadInfoErrorStatusCodeErrorStatusMessageExpirationDateFileContentsFileNameFileUrlFileWebImageLastUpdateDateLastUpdatedByLastUpdatedByUserNamePostProcessingActionTitleUploadedFileContentTypeUploadedFileLengthUploadedFileNameUploadedTextUriUrlUserNamestakeholderDFFGET · POST · PATCH Stakeholder Descriptive Flexfields · 3 fieldsStakeholderId__FLEX_Context__FLEX_Context_DisplayValue
Use in AI Agent Studio
- Point a Business Object or REST tool at
/fscmRestApi/resources/11.13.18.05/jointVenturesand ask only for the fields the agent needs withfields=. Big responses cost tokens and slow the agent. - Prefer a finder such as
findByNamefor the agent's main search: its variables become clean tool parameters. - Narrow with
q=on searchable fields and a smalllimit; for a count usetotalResults=true&limit=1. - Call once and pass the result on to later steps rather than calling the same endpoint again.
- This resource can change data. Put a human approval step before any create, update, delete or action call.
More in For Builders.
Pitfalls
- Attribute names are case-sensitive in
q,fieldsand bodies:approvedDate, notapproveddate. - 73 fields are read-only: sending them in POST or PATCH fails or is ignored. The builder leaves them out.
- Send dates as
YYYY-MM-DD; date-time fields take ISO 8601 with a time zone. - A list returns 25 rows unless you set
limit; readhasMoreand moveoffsetto page through. - Text fields have maximum lengths (shown in the field table). Longer values are rejected.