Supported operations
| DELETE /jointVentureBasicGeneratedDistributions/{id} |
| GET /jointVentureBasicGeneratedDistributions |
| GET /jointVentureBasicGeneratedDistributions/{id} |
| PATCH /jointVentureBasicGeneratedDistributions/{id} |
Queryable q fields (60)
Only these fields can appear in a q filter expression on
/jointVentureBasicGeneratedDistributions. Filtering on any other field returns
400 Bad Request.
Example q request
GET /fscmRestApi/resources/11.13.18.05/jointVentureBasicGeneratedDistributions?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 | = != |
| createdByJointVentureFlag | boolean | = != |
| creationDate | string | = != |
| directBilledStakeholder | string | = != |
| distributedCredit | number | = != |
| distributedDebit | number | = != |
| distributionId | integer | = != |
| distributionOnlyFlag | boolean | = != |
| distributionType | string | = != |
| expenditureType | string | = != |
| expenditureTypeDescription | string | = != |
| jointVenture | string | = != |
| jointVentureDescription | string | = != |
| lastUpdateDate | string | = != |
| lastUpdatedBy | string | = != |
| ledger | string | = != |
| lineNumber | integer | = != |
| lineType | string | = != |
| method | string | = != |
| methodDescription | string | = != |
| notes | string | = != |
| originalDistributedCredit | number | between |
| originalDistributedDebit | number | between |
| originalDistributedEnteredCredit | number | between |
| originalDistributedEnteredDebit | number | between |
| originalStakeholder | string | = != |
| ownershipDefinition | string | = != |
| ownershipDefinitionEndDate | string | = != |
| ownershipDefinitionStartDate | string | = != |
| percentageOfInterest | number | = != |
| project | string | = != |
| projectCostingStatus | string | = != |
| projectNumber | string | = != |
| reassignedStakeholder | string | = != |
| roundAmountFlag | boolean | = != |
| stakeholder | string | = != |
| stakeholderReportingHeaderId | integer | = != |
| stakeholderReportingLedger | string | = != |
| stakeholderReportingStatus | string | = != |
| status | string | = != |
| 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
/jointVentureBasicGeneratedDistributions/{id}/child/<name>
and most can also be inlined with expand.
distributionDFF Response fields (63)
Top-level attributes returned for each row. Use
fields= to request a subset and shrink the payload.
accountingDateaccountingPeriodagreementagreementDescriptionbasisSourcebusinessUnitchangeReasonchangeReasonDetailscontributionIdcreatedBycreatedByJointVentureFlagcreationDatedirectBilledStakeholderdistributedCreditdistributedDebitdistributionDFFdistributionIddistributionOnlyFlagdistributionTypeexpenditureTypeexpenditureTypeDescriptioninvoiceTransactionTypejointVenturejointVentureDescriptionlastUpdateDatelastUpdatedByledgerlineNumberlineTypemethodmethodDescriptionnotesoriginalDistributedCreditoriginalDistributedDebitoriginalDistributedEnteredCreditoriginalDistributedEnteredDebitoriginalStakeholderownershipDefinitionownershipDefinitionEndDateownershipDefinitionStartDatepercentageOfInterestprojectprojectCostingStatusprojectNumberreassignedStakeholderroundAmountFlagstakeholderstakeholderReportingDatestakeholderReportingHeaderIdstakeholderReportingLedgerstakeholderReportingStatusstatustasktaskNumbertransactionCredittransactionCurrencytransactionDatetransactionDebittransactionDescriptiontransactionIdtransactionTypetrxDatetrxNumber 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
- /taxExemptions Get all tax exemptions
- /jointVentureBasicSLADistributions Get all joint venture subledger distributions
- /ledgerBalances Get all account balances
- /jointVentureGLTransactions Get all joint venture general ledger transactions
- /expenseMileagePolicies Get all expense mileage policy line records
- 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