Supported operations
| DELETE /jointVentureGeneratedTransactions/{id} |
| GET /jointVentureGeneratedTransactions |
| GET /jointVentureGeneratedTransactions/{id} |
| PATCH /jointVentureGeneratedTransactions/{id} |
Queryable q fields (47)
Only these fields can appear in a q filter expression on
/jointVentureGeneratedTransactions. Filtering on any other field returns
400 Bad Request.
Example q request
GET /fscmRestApi/resources/11.13.18.05/jointVentureGeneratedTransactions?q=accountingDate='<value>'&onlyData=true&limit=25
| Field | Type | Operators |
|---|---|---|
| accountingDate | string | = != |
| accountingPeriod | string | = != |
| agreement | string | = != |
| agreementDescription | string | = != |
| basisSource | string | = != |
| businessUnit | string | = != |
| createdBy | string | = != |
| createdByJointVentureFlag | boolean | = != |
| creationDate | string | = != |
| credit | number | = != |
| currency | string | = != |
| debit | number | = != |
| directBilledStakeholder | string | = != |
| directBilledStakeholderDescription | string | = != |
| distributionOnlyFlag | boolean | = != |
| distributionType | string | = != |
| expenditureType | string | = != |
| expenditureTypeDescription | string | = != |
| headerId | integer | = != |
| jointVenture | string | = != |
| jointVentureDescription | string | = != |
| lastUpdateDate | string | = != |
| lastUpdatedBy | string | = != |
| ledger | string | = != |
| lineNumber | integer | = != |
| method | string | = != |
| methodDescription | string | = != |
| methodEndDate | string | = != |
| methodStartDate | string | = != |
| methodType | string | = != |
| notes | string | = != |
| originalDirectBilledStakeholder | string | = != |
| originalDirectBilledStakeholderDescription | string | = != |
| originalOwnershipDefinition | string | = != |
| ownershipDefinition | string | = != |
| partnerOffsetAccount | string | = != |
| periodBasis | string | = != |
| project | string | = != |
| projectNumber | string | = != |
| status | string | = != |
| task | string | = != |
| taskNumber | string | = != |
| transactionDate | string | = != |
| transactionDescription | string | = != |
| transactionId | integer | = != |
| transactionSource | string | = != |
| transactionType | string | = != |
Child resources (2)
Each child is reachable at
/jointVentureGeneratedTransactions/{id}/child/<name>
and most can also be inlined with expand.
transactionChangestransactionDFF Response fields (52)
Top-level attributes returned for each row. Use
fields= to request a subset and shrink the payload.
accountDescriptionaccountingDateaccountingPeriodagreementagreementDescriptionbasisSourcebusinessUnitchangeReasonchangeReasonDetailscreatedBycreatedByJointVentureFlagcreationDatecreditcurrencydebitdirectBilledStakeholderdirectBilledStakeholderDescriptiondistributionOnlyFlagdistributionTypeexpenditureTypeexpenditureTypeDescriptionheaderIdjointVenturejointVentureDescriptionlastUpdateDatelastUpdatedByledgerlineNumbermethodmethodDescriptionmethodEndDatemethodStartDatemethodTypenotesoriginalDirectBilledStakeholderoriginalDirectBilledStakeholderDescriptionoriginalOwnershipDefinitionownershipDefinitionpartnerOffsetAccountperiodBasisprojectprojectNumberstatustasktaskNumbertransactionChangestransactionDFFtransactionDatetransactionDescriptiontransactionIdtransactionSourcetransactionType 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
- /taxRegistrations Get all tax registrations
- /jointVentureBasicOverheadDistributions Get all overhead distributions
- /erpintegrations Get all job details
- /expenseTypes Get all expense type records
- /transactionTaxLines Get all transaction tax lines
- 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