Oracle Fusion FSCM endpoint reference

Joint Venture Basic Overhead Distributions REST API

Get all overhead distributions

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

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

Supported operations

DELETE /jointVentureBasicOverheadDistributions/{id}
GET /jointVentureBasicOverheadDistributions
GET /jointVentureBasicOverheadDistributions/{id}
PATCH /jointVentureBasicOverheadDistributions/{id}

Queryable q fields (48)

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

Example q request

GET /fscmRestApi/resources/11.13.18.05/jointVentureBasicOverheadDistributions?q=accountingDate='<value>'&onlyData=true&limit=25
Field Type Operators
accountingDate string = !=
accountingPeriod string = !=
agreement string = !=
agreementDescription string = !=
basisSource string = !=
businessUnit string = !=
changeReason string = !=
changeReasonDetails string = !=
contributionId integer = !=
createdBy string = !=
creationDate string = !=
currencyCode string = !=
directBilledStakeholder string = !=
distributedCreditAmount number = !=
distributedDebitAmount number = !=
distributionId integer = !=
distributionLineNumber integer = !=
distributionLineType string = !=
distributionOnlyFlag boolean = !=
distributionStatus string = !=
distributionType string = !=
jointVenture string = !=
jointVentureDescription string = !=
journalDescription string = !=
lastUpdateDate string = !=
lastUpdatedBy string = !=
ledger string = !=
method string = !=
methodDescription string = !=
originalDistributedCreditAmount number between
originalDistributedDebitAmount number between
originalDistributedEnteredCreditAmount number between
originalDistributedEnteredDebitAmount number between
originalStakeholder string = !=
ownershipDefinition string = !=
ownershipDefinitionEndDate string = !=
ownershipDefinitionStartDate string = !=
percentageOfInterest number = !=
reassignedStakeholder string = !=
roundAmountFlag boolean = !=
sourceOwnershipDefinition string = !=
stakeholder string = !=
transactionCreditAmount number = !=
transactionDate string = !=
transactionDebitAmount number = !=
transactionId integer = !=
trxDate string = !=
trxNumber string = !=

Child resources (1)

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

distributionDFF

Response fields (50)

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

accountingDateaccountingPeriodagreementagreementDescriptionbasisSourcebusinessUnitchangeReasonchangeReasonDetailscontributionIdcreatedBycreationDatecurrencyCodedirectBilledStakeholderdistributedCreditAmountdistributedDebitAmountdistributionDFFdistributionIddistributionLineNumberdistributionLineTypedistributionOnlyFlagdistributionStatusdistributionTypeinvoiceTransactionTypejointVenturejointVentureDescriptionjournalDescriptionlastUpdateDatelastUpdatedByledgermethodmethodDescriptionoriginalDistributedCreditAmountoriginalDistributedDebitAmountoriginalDistributedEnteredCreditAmountoriginalDistributedEnteredDebitAmountoriginalStakeholderownershipDefinitionownershipDefinitionEndDateownershipDefinitionStartDatepercentageOfInterestreassignedStakeholderroundAmountFlagsourceOwnershipDefinitionstakeholdertransactionCreditAmounttransactionDatetransactionDebitAmounttransactionIdtrxDatetrxNumber

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