Supported operations
| DELETE /jointVentureGeneratedDistributions/{id} |
| GET /jointVentureGeneratedDistributions |
| GET /jointVentureGeneratedDistributions/{id} |
| PATCH /jointVentureGeneratedDistributions/{id} |
Queryable q fields (79)
Only these fields can appear in a q filter expression on
/jointVentureGeneratedDistributions. Filtering on any other field returns
400 Bad Request.
Example q request
GET /fscmRestApi/resources/11.13.18.05/jointVentureGeneratedDistributions?q=account='<value>'&onlyData=true&limit=25
| Field | Type | Operators |
|---|---|---|
| account | string | = != |
| accountingDate | string | = != |
| accountingPeriod | string | = != |
| agreement | string | = != |
| agreementDescription | string | = != |
| basisSource | string | = != |
| businessUnit | string | = != |
| changeReason | string | = != |
| changeReasonDetails | string | = != |
| contributionAmount | number | = != |
| contributionId | integer | = != |
| contributionRequest | string | = != |
| costCenterSegmentValue | string | = != |
| createdBy | string | = != |
| createdByJointVentureFlag | boolean | = != |
| creationDate | string | = != |
| customer | string | = != |
| directBilledStakeholder | string | = != |
| distributedCredit | number | = != |
| distributedDebit | number | = != |
| distributionId | integer | = != |
| distributionOnlyFlag | boolean | = != |
| distributionType | string | = != |
| expenditureType | string | = != |
| expenditureTypeDescription | string | = != |
| invoicingPartner | string | = != |
| jointVenture | string | = != |
| jointVentureClassification | string | = != |
| jointVentureDescription | string | = != |
| lastUpdateDate | string | = != |
| lastUpdatedBy | string | = != |
| ledger | string | = != |
| ledgerCategoryCode | string | = != |
| lineNumber | integer | = != |
| lineType | string | = != |
| method | string | = != |
| methodDescription | string | = != |
| methodEndDate | string | = != |
| methodStartDate | string | = != |
| methodType | string | = != |
| notes | string | = != |
| originalDirectBilledStakeholder | string | = != |
| originalDistributedCredit | number | between |
| originalDistributedDebit | number | between |
| originalDistributedEnteredCredit | number | between |
| originalDistributedEnteredDebit | number | between |
| originalOwnershipDefinition | string | = != |
| originalOwnershipDefinitionEndDate | string | = != |
| originalOwnershipDefinitionStartDate | string | = != |
| originalStakeholder | string | = != |
| ownershipDefinition | string | = != |
| ownershipDefinitionEndDate | string | = != |
| ownershipDefinitionStartDate | string | = != |
| party | string | = != |
| percentageOfInterest | number | = != |
| periodBasis | string | = != |
| project | string | = != |
| projectCostingStatus | string | = != |
| projectNumber | string | = != |
| reassignedStakeholder | string | = != |
| roundAmountFlag | boolean | = != |
| stakeholder | string | = != |
| stakeholderReportingHeaderId | integer | = != |
| stakeholderReportingLedger | string | = != |
| stakeholderReportingStatus | string | = != |
| status | string | = != |
| supplier | string | = != |
| targetTransactionId | integer | = != |
| task | string | = != |
| taskNumber | string | = != |
| transactionCredit | number | = != |
| transactionCurrency | string | = != |
| transactionDate | string | = != |
| transactionDebit | number | = != |
| transactionDescription | string | = != |
| transactionId | integer | = != |
| transactionType | string | = != |
| trxDate | string | = != |
| trxNumber | string | = != |
Child resources (1)
Each child is reachable at
/jointVentureGeneratedDistributions/{id}/child/<name>
and most can also be inlined with expand.
distributionDFF Response fields (87)
Top-level attributes returned for each row. Use
fields= to request a subset and shrink the payload.
accountaccountDescriptionaccountingDateaccountingPeriodagreementagreementDescriptionbasisSourcebusinessUnitchangeReasonchangeReasonDetailscontributionAmountcontributionIdcontributionRequestcostCenterDescriptioncostCenterSegmentValuecreatedBycreatedByJointVentureFlagcreationDatecustomerdirectBilledStakeholderdistributedCreditdistributedDebitdistributionDFFdistributionIddistributionOnlyFlagdistributionTypeexpenditureTypeexpenditureTypeDescriptioninvoiceTransactionTypeinvoicingPartnerjointVenturejointVentureClassificationjointVentureDescriptionlastUpdateDatelastUpdatedByledgerledgerCategoryCodelineNumberlineTypemethodmethodDescriptionmethodEndDatemethodStartDatemethodTypenotesoriginalDirectBilledStakeholderoriginalDistributedCreditoriginalDistributedDebitoriginalDistributedEnteredCreditoriginalDistributedEnteredDebitoriginalOwnershipDefinitionoriginalOwnershipDefinitionEndDateoriginalOwnershipDefinitionStartDateoriginalStakeholderownershipDefinitionownershipDefinitionEndDateownershipDefinitionStartDatepartnerOffsetAccountpartypercentageOfInterestperiodBasisprojectprojectCostingStatusprojectNumberreassignedStakeholderroundAmountFlagsplitLinesExistFlagstakeholderstakeholderReportingDatestakeholderReportingHeaderIdstakeholderReportingLedgerstakeholderReportingStatusstatussuppliertargetTransactionHeaderAccounttargetTransactionIdtasktaskNumbertransactionCredittransactionCurrencytransactionDatetransactionDebittransactionDescriptiontransactionIdtransactionTypetrxDatetrxNumber 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
- /jointVentureSLATransactions Get all joint venture subledger transactions
- /cashBankAccounts Get all bank accounts
- /payablesOptions Get payables options for all business units
- /jointVentureTransactions Get all joint venture transactions
- /cashExternalTransactions Get all external transactions
- Oracle Fusion API guide
- Why the q parameter fails and how to fix it
- Finders: named queries in Oracle Fusion REST APIs
- All endpoint reference pages