Oracle Fusion FSCM endpoint reference

Joint Venture Overhead Transactions REST API

Get all overhead transactions

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

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

Supported operations

DELETE /jointVentureOverheadTransactions/{id}
GET /jointVentureOverheadTransactions
GET /jointVentureOverheadTransactions/{id}
PATCH /jointVentureOverheadTransactions/{id}

Queryable q fields (35)

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

Example q request

GET /fscmRestApi/resources/11.13.18.05/jointVentureOverheadTransactions?q=accountingDate='<value>'&onlyData=true&limit=25
Field Type Operators
accountingDate string = !=
accountingPeriod string = !=
basisSource string = !=
carriedInterestAgreement string = !=
carriedInterestAgreementDescription string = !=
carriedInterestSourceOwnerDefinition string = !=
createdBy string = !=
creationDate string = !=
creditAmount number = !=
currencyCode string = !=
debitAmount number = !=
distributionOnlyFlag boolean = !=
headerId integer = !=
jointVenture string = !=
jointVentureDescription string = !=
journalDescription string = !=
lastUpdateDate string = !=
lastUpdatedBy string = !=
ledger string = !=
lineNumber integer = !=
method string = !=
methodDescription string = !=
methodType string = !=
originalOwnershipDefinition string = !=
originalStakeholder string = !=
originalStakeholderDescription string = !=
ownershipDefinition string = !=
partnerOffsetAccount string = !=
periodBasis string = !=
stakeholder string = !=
stakeholderDescription string = !=
transactionDate string = !=
transactionId integer = !=
transactionStatus string = !=
transactionType string = !=

Child resources (2)

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

transactionChangestransactionDFF

Response fields (40)

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

accountingDateaccountingPeriodbasisSourcecarriedInterestAgreementcarriedInterestAgreementDescriptioncarriedInterestSourceOwnerDefinitionchangeReasonchangeReasonDetailscreatedBycreationDatecreditAmountcurrencyCodedebitAmountdistributionOnlyFlagheaderIdjointVenturejointVentureDescriptionjournalDescriptionlastUpdateDatelastUpdatedByledgerlineNumbermethodmethodDescriptionmethodTypeoriginalOwnershipDefinitionoriginalStakeholderoriginalStakeholderDescriptionownershipDefinitionpartnerOffsetAccountperiodBasisstakeholderstakeholderDescriptiontransactionChangestransactionChangesExistFlagtransactionDFFtransactionDatetransactionIdtransactionStatustransactionType

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