Oracle Fusion FSCM endpoint reference

Joint Venture Transactions REST API

Get all joint venture transactions

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

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

Supported operations

DELETE /jointVentureTransactions/{id}
GET /jointVentureTransactions
GET /jointVentureTransactions/{id}
PATCH /jointVentureTransactions/{id}

Queryable q fields (88)

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

Example q request

GET /fscmRestApi/resources/11.13.18.05/jointVentureTransactions?q=account='<value>'&onlyData=true&limit=25
Field Type Operators
account string = !=
accountDescription string = !=
accountSegment1 string = !=
accountSegment10 string = !=
accountSegment11 string = !=
accountSegment12 string = !=
accountSegment13 string = !=
accountSegment14 string = !=
accountSegment15 string = !=
accountSegment16 string = !=
accountSegment17 string = !=
accountSegment18 string = !=
accountSegment19 string = !=
accountSegment2 string = !=
accountSegment20 string = !=
accountSegment21 string = !=
accountSegment22 string = !=
accountSegment23 string = !=
accountSegment24 string = !=
accountSegment25 string = !=
accountSegment26 string = !=
accountSegment27 string = !=
accountSegment28 string = !=
accountSegment29 string = !=
accountSegment3 string = !=
accountSegment30 string = !=
accountSegment4 string = !=
accountSegment5 string = !=
accountSegment6 string = !=
accountSegment7 string = !=
accountSegment8 string = !=
accountSegment9 string = !=
accountedCredit number = !=
accountedDebit number = !=
accountingClassCode string = !=
accountingCurrency string = !=
accountingDate string = !=
accountingPeriod string = !=
agreement string = !=
agreementDescription string = !=
assignmentRule string = !=
assignmentRuleDescription string = !=
basisSource string = !=
businessUnit string = !=
createdBy string = !=
createdByJointVentureFlag boolean = !=
creationDate string = !=
directBilledStakeholder string = !=
directBilledStakeholderDescription string = !=
distributionOnlyFlag boolean = !=
distributionType string = !=
enteredCredit number = !=
enteredCurrency string = !=
enteredDebit number = !=
expenditureBusinessUnit string = !=
expenditureItemDate string = !=
expenditureOrganization string = !=
expenditureType string = !=
expenditureTypeDescription string = !=
headerId integer = !=
jointVenture string = !=
jointVentureDescription string = !=
lastUpdateDate string = !=
lastUpdatedBy string = !=
ledger string = !=
lineNumber integer = !=
method string = !=
methodDescription string = !=
methodEndDate string = !=
methodStartDate string = !=
netAccounted number = !=
netEntered number = !=
notes string = !=
originalDirectBilledStakeholder string = !=
originalDirectBilledStakeholderDescription string = !=
originalOwnershipDefinition string = !=
ownershipDefinition string = !=
project string = !=
projectNumber string = !=
source string = !=
status string = !=
task string = !=
taskNumber string = !=
transactionDate string = !=
transactionDescription string = !=
transactionId integer = !=
transactionSource string = !=
transactionType string = !=

Child resources (1)

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

transactionChanges

Response fields (91)

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

accountaccountDescriptionaccountSegment1accountSegment10accountSegment11accountSegment12accountSegment13accountSegment14accountSegment15accountSegment16accountSegment17accountSegment18accountSegment19accountSegment2accountSegment20accountSegment21accountSegment22accountSegment23accountSegment24accountSegment25accountSegment26accountSegment27accountSegment28accountSegment29accountSegment3accountSegment30accountSegment4accountSegment5accountSegment6accountSegment7accountSegment8accountSegment9accountedCreditaccountedDebitaccountingClassCodeaccountingCurrencyaccountingDateaccountingPeriodagreementagreementDescriptionassignmentRuleassignmentRuleDescriptionbasisSourcebusinessUnitchangeReasonchangeReasonDetailscreatedBycreatedByJointVentureFlagcreationDatedirectBilledStakeholderdirectBilledStakeholderDescriptiondistributionOnlyFlagdistributionTypeenteredCreditenteredCurrencyenteredDebitexpenditureBusinessUnitexpenditureItemDateexpenditureOrganizationexpenditureTypeexpenditureTypeDescriptionheaderIdjointVenturejointVentureDescriptionlastUpdateDatelastUpdatedByledgerlineNumbermethodmethodDescriptionmethodEndDatemethodStartDatenetAccountednetEnterednotesoriginalDirectBilledStakeholderoriginalDirectBilledStakeholderDescriptionoriginalOwnershipDefinitionownershipDefinitionprojectprojectNumbersourcestatustasktaskNumbertransactionChangestransactionDatetransactionDescriptiontransactionIdtransactionSourcetransactionType

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