// fusionrest agent · financials

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.

/fscmRestApi/resources/11.13.18.05/jointVentures
Operations
GET (list)GET (one)POST (create)PATCH (update)DELETE
Record key
jointVentureId
Required on create
jointVentureShortName
At a glance
131 fields3 finders19 children
I want to…List the latest 25Count recordsGet one recordCreate oneUpdate one

Try it

Response fields ·
Filters (q)

Only attributes Oracle marks as searchable are offered.

Finder
Include children (expand)
Paging and options
limit
Endpoint and headers
GET /fscmRestApi/resources/11.13.18.05/jointVentures?fields=approvedDate,approvedFlag,billWhenPaidFlag,billableAssetAccountSet,businessUnitName&limit=25&onlyData=true
Response shape (placeholders)
{
  "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

AttributeTypeUse
approvedDatedateOptional on createUpdatableSearchable
approvedFlagyes/no · max 1 · default falseOptional on createUpdatableSearchable
billWhenPaidFlagyes/no · max 1 · default falseOptional on createUpdatableSearchable
billableAssetAccountSettext · max 30Optional on createUpdatableSearchable
businessUnitNametextOptional on createUpdatableSearchable
chartOfAccountsInstanceNametext · max 60Read-onlySearchable
classificationtextOptional on createUpdatableSearchable
costCenterSegmentnumberRead-only
createdBytext · max 64Read-onlySearchable
creationDatedate-timeRead-onlySearchable
currencyCodetextRead-onlySearchable
defaultLedgertextRead-onlySearchable
defaultOwnershipDefinitionNametext · max 30Optional on createUpdatableSearchable
distributableAccountSettext · max 30Optional on createUpdatableSearchable
distributionOnlyAccountSettext · max 30Optional on createUpdatableSearchable
emailAddresstext · max 100Optional on createUpdatableSearchable
excludeJointVentureTransactionsFlagyes/no · max 1Optional on createUpdatableSearchable
inceptionDatedateOptional on createUpdatableSearchable
includeCostReversalFlagyes/no · max 1 · default falseOptional on createUpdatableSearchable
includeRevenueInPartnerContributionsFlagyes/no · max 1 · default falseOptional on createUpdatableSearchable
includeRevenueReversalFlagyes/no · max 1 · default falseOptional on createUpdatableSearchable
invoiceNettingDocumentOptiontext · max 80Optional on createUpdatableSearchable
invoiceNettingEnabledFlagyes/no · max 1 · default falseOptional on createUpdatableSearchable
jibOutputFormattextOptional on createUpdatableSearchable
jibTemplateNametext · max 100Optional on createUpdatableSearchable
jointVentureDescriptiontext · max 240Optional on createUpdatableSearchable
jointVentureIdnumberRead-onlySearchable
jointVentureShortNametext · max 30Required on createSearchable
jointVentureStatustextOptional on createUpdatableSearchable
lastUpdateDatedate-timeRead-onlySearchable
lastUpdatedBytext · max 64Read-onlySearchable
ledgerPeriodSettext · max 15Read-onlySearchable
ledgerPeriodTypetext · max 15Read-onlySearchable
legalEntitytextOptional on createUpdatableSearchable
liabilityAccounttext · max 255Optional on createUpdatableSearchable
minimumAPInvoiceAmountnumber · default 0Optional on createUpdatableSearchable
minimumARInvoiceAmountnumber · default 0Optional on createUpdatableSearchable
projectSettext · max 30Optional on createUpdatable
receivableAccounttextOptional on createUpdatableSearchable
segment10Flagyes/no · max 1 · default falseOptional on createUpdatableSearchable
segment10LabeltextRead-only
segment10ValueSetCodetextRead-only
segment11Flagyes/no · max 1 · default falseOptional on createUpdatableSearchable
segment11LabeltextRead-only
segment11ValueSetCodetextRead-only
segment12Flagyes/no · max 1 · default falseOptional on createUpdatableSearchable
segment12LabeltextRead-only
segment12ValueSetCodetextRead-only
segment13Flagyes/no · max 1 · default falseOptional on createUpdatableSearchable
segment13LabeltextRead-only
segment13ValueSetCodetextRead-only
segment14Flagyes/no · max 1 · default falseOptional on createUpdatableSearchable
segment14LabeltextRead-only
segment14ValueSetCodetextRead-only
segment15Flagyes/no · max 1 · default falseOptional on createUpdatableSearchable
segment15LabeltextRead-only
segment15ValueSetCodetextRead-only
segment16Flagyes/no · max 1 · default falseOptional on createUpdatableSearchable
segment16LabeltextRead-only
segment16ValueSetCodetextRead-only
segment17Flagyes/no · max 1 · default falseOptional on createUpdatableSearchable
segment17LabeltextRead-only
segment17ValueSetCodetextRead-only
segment18Flagyes/no · max 1 · default falseOptional on createUpdatableSearchable
segment18LabeltextRead-only
segment18ValueSetCodetextRead-only
segment19Flagyes/no · max 1 · default falseOptional on createUpdatableSearchable
segment19LabeltextRead-only
segment19ValueSetCodetextRead-only
segment1Flagyes/no · max 1 · default falseOptional on createUpdatableSearchable
segment1LabeltextRead-only
segment1ValueSetCodetextRead-only
segment20Flagyes/no · max 1 · default falseOptional on createUpdatableSearchable
segment20LabeltextRead-only
segment20ValueSetCodetextRead-only
segment21Flagyes/no · max 1 · default falseOptional on createUpdatableSearchable
segment21LabeltextRead-only
segment21ValueSetCodetextRead-only
segment22Flagyes/no · max 1 · default falseOptional on createUpdatableSearchable
segment22LabeltextRead-only
segment22ValueSetCodetextRead-only
segment23Flagyes/no · max 1 · default falseOptional on createUpdatableSearchable
segment23LabeltextRead-only
segment23ValueSetCodetextRead-only
segment24Flagyes/no · max 1 · default falseOptional on createUpdatableSearchable
segment24LabeltextRead-only
segment24ValueSetCodetextRead-only
segment25Flagyes/no · max 1 · default falseOptional on createUpdatableSearchable
segment25LabeltextRead-only
segment25ValueSetCodetextRead-only
segment26Flagyes/no · max 1 · default falseOptional on createUpdatableSearchable
segment26LabeltextRead-only
segment26ValueSetCodetextRead-only
segment27Flagyes/no · max 1 · default falseOptional on createUpdatableSearchable
segment27LabeltextRead-only
segment27ValueSetCodetextRead-only
segment28Flagyes/no · max 1 · default falseOptional on createUpdatableSearchable
segment28LabeltextRead-only
segment28ValueSetCodetextRead-only
segment29Flagyes/no · max 1 · default falseOptional on createUpdatableSearchable
segment29LabeltextRead-only
segment29ValueSetCodetextRead-only
segment2Flagyes/no · max 1 · default falseOptional on createUpdatableSearchable
segment2LabeltextRead-only
segment2ValueSetCodetextRead-only
segment30Flagyes/no · max 1 · default falseOptional on createUpdatableSearchable
segment30LabeltextRead-only
segment30ValueSetCodetextRead-only
segment3Flagyes/no · max 1 · default falseOptional on createUpdatableSearchable
segment3LabeltextRead-only
segment3ValueSetCodetextRead-only
segment4Flagyes/no · max 1 · default falseOptional on createUpdatableSearchable
segment4LabeltextRead-only
segment4ValueSetCodetextRead-only
segment5Flagyes/no · max 1 · default falseOptional on createUpdatableSearchable
segment5LabeltextRead-only
segment5ValueSetCodetextRead-only
segment6Flagyes/no · max 1 · default falseOptional on createUpdatableSearchable
segment6LabeltextRead-only
segment6ValueSetCodetextRead-only
segment7Flagyes/no · max 1 · default falseOptional on createUpdatableSearchable
segment7LabeltextRead-only
segment7ValueSetCodetextRead-only
segment8Flagyes/no · max 1 · default falseOptional on createUpdatableSearchable
segment8LabeltextRead-only
segment8ValueSetCodetextRead-only
segment9Flagyes/no · max 1 · default falseOptional on createUpdatableSearchable
segment9LabeltextRead-only
segment9ValueSetCodetextRead-only
structureInstanceNumbernumberRead-only
transactionsExistFlagyes/noRead-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.

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.

Use in AI Agent Studio

More in For Builders.

Pitfalls