Supported operations
| DELETE /jointVentureGLDistributions/{id} |
| GET /jointVentureGLDistributions |
| GET /jointVentureGLDistributions/{id} |
| PATCH /jointVentureGLDistributions/{id} |
Finders (2)
Finders are named, pre-built queries with bound parameters. They can search values plain
q filters cannot reach.
| Finder | Bind variables |
|---|---|
| PrimaryKey | — |
| jointVentureGLDistributionSearch | — |
Example finder request
GET /fscmRestApi/resources/11.13.18.05/jointVentureGLDistributions?finder=PrimaryKey Queryable q fields (73)
Only these fields can appear in a q filter expression on
/jointVentureGLDistributions. Filtering on any other field returns
400 Bad Request.
Example q request
GET /fscmRestApi/resources/11.13.18.05/jointVentureGLDistributions?q=accountingDate='<value>'&onlyData=true&limit=25
| Field | Type | Operators |
|---|---|---|
| accountingDate | string | = != |
| agreement | string | = != |
| agreementDescription | string | = != |
| assignmentRule | string | = != |
| batchId | integer | = != |
| businessUnitName | string | = != |
| changeReason | string | = != |
| changeReasonDetails | string | = != |
| contributionAmount | number | = != |
| contributionId | integer | = != |
| contributionRequest | string | = != |
| costCenterSegmentValue | string | = != |
| createdBy | string | = != |
| createdByJointVentureFlag | boolean | = != |
| creationDate | string | = != |
| currencyCode | string | = != |
| customerName | string | = != |
| directBilledStakeholderName | string | = != |
| distributedAccountInformation | string | = != |
| distributedCreditAmount | number | = != |
| distributedDebitAmount | number | = != |
| distributedEnteredCreditAmount | number | = != |
| distributedEnteredDebitAmount | number | = != |
| distributionId | integer | = != |
| distributionLineNumber | integer | = != |
| distributionLineType | string | = != |
| distributionOnlyFlag | boolean | = != |
| distributionStatus | string | = != |
| distributionType | string | = != |
| enteredCurrencyCode | string | = != |
| generalLedgerCategory | string | = != |
| headerId | integer | = != |
| invoicingPartnerName | string | = != |
| jointVentureClassification | string | = != |
| jointVentureDescription | string | = != |
| jointVentureName | string | = != |
| lastUpdateDate | string | = != |
| lastUpdatedBy | string | = != |
| ledgerCategoryCode | string | = != |
| ledgerName | string | = != |
| originalDirectBilledStakeholderName | string | = != |
| originalDistributedCreditAmount | number | between |
| originalDistributedDebitAmount | number | between |
| originalDistributedEnteredCreditAmount | number | between |
| originalDistributedEnteredDebitAmount | number | between |
| originalOwnershipDefinitionName | string | = != |
| originalStakeholder | string | = != |
| ownershipDefinitionEndDate | string | = != |
| ownershipDefinitionName | string | = != |
| ownershipDefinitionStartDate | string | = != |
| ownershipEffectiveEndDate | string | = != |
| ownershipEffectiveStartDate | string | = != |
| percentageOfInterest | number | = != |
| periodName | string | = != |
| reassignedStakeholder | string | = != |
| roundAmountFlag | boolean | = != |
| sourceOwnershipDefinition | string | = != |
| stakeholderName | string | = != |
| stakeholderReportingHeaderId | integer | = != |
| stakeholderReportingLedger | string | = != |
| stakeholderReportingStatus | string | = != |
| statisticalAmount | number | = != |
| supplierName | string | = != |
| targetTransactionId | integer | = != |
| transactionCreditAmount | number | = != |
| transactionDate | string | = != |
| transactionDebitAmount | number | = != |
| transactionDescription | string | = != |
| transactionEnteredCreditAmount | number | = != |
| transactionEnteredDebitAmount | number | = != |
| transactionId | integer | = != |
| trxDate | string | = != |
| trxNumber | string | = != |
Child resources (3)
Each child is reachable at
/jointVentureGLDistributions/{id}/child/<name>
and most can also be inlined with expand.
AccountdistributionDFFpartnerOffsetAccount Response fields (83)
Top-level attributes returned for each row. Use
fields= to request a subset and shrink the payload.
AccountaccountDescriptionaccountingDateagreementagreementDescriptionassignmentRulebatchIdbusinessUnitNamechangeReasonchangeReasonDetailscontributionAmountcontributionIdcontributionRequestcostCenterDescriptioncostCenterSegmentValuecreatedBycreatedByJointVentureFlagcreationDatecurrencyCodecustomerNamedirectBilledStakeholderNamedistributedAccountInformationdistributedCreditAmountdistributedDebitAmountdistributedEnteredCreditAmountdistributedEnteredDebitAmountdistributionDFFdistributionIddistributionLineNumberdistributionLineTypedistributionOnlyFlagdistributionStatusdistributionTypeenteredCurrencyCodegeneralLedgerCategoryheaderIdinvoiceTransactionTypeinvoicingPartnerNamejointVentureClassificationjointVentureDescriptionjointVentureNamelastUpdateDatelastUpdatedByledgerCategoryCodeledgerNameoriginalDirectBilledStakeholderNameoriginalDistributedCreditAmountoriginalDistributedDebitAmountoriginalDistributedEnteredCreditAmountoriginalDistributedEnteredDebitAmountoriginalOwnershipDefinitionNameoriginalStakeholderownershipDefinitionEndDateownershipDefinitionNameownershipDefinitionStartDateownershipEffectiveEndDateownershipEffectiveStartDatepartnerOffsetAccountpartnerOffsetAccountInformationpercentageOfInterestperiodNamereassignedStakeholderroundAmountFlagsourceOwnershipDefinitionsplitLinesExistFlagstakeholderNamestakeholderReportingDatestakeholderReportingHeaderIdstakeholderReportingLedgerstakeholderReportingStatusstatisticalAmountsupplierNametargetTransactionHeaderAccounttargetTransactionIdtransactionCreditAmounttransactionDatetransactionDebitAmounttransactionDescriptiontransactionEnteredCreditAmounttransactionEnteredDebitAmounttransactionIdtrxDatetrxNumber 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
- /cashExternalTransactions Get all external transactions
- /jointVentureTransactions Get all joint venture transactions
- /cashBankAccounts Get all bank accounts
- /payablesPayments Get all payments
- /jointVentureGeneratedDistributions Get all distributions for joint venture generated 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