Supported operations
| DELETE /jointVentureSourceTransactions/{id} |
| GET /jointVentureSourceTransactions |
| GET /jointVentureSourceTransactions/{id} |
| PATCH /jointVentureSourceTransactions/{id} |
| POST /jointVentureSourceTransactions |
Queryable q fields (36)
Only these fields can appear in a q filter expression on
/jointVentureSourceTransactions. Filtering on any other field returns
400 Bad Request.
Example q request
GET /fscmRestApi/resources/11.13.18.05/jointVentureSourceTransactions?q=account='<value>'&onlyData=true&limit=25
| Field | Type | Operators |
|---|---|---|
| account | string | = != |
| accountingDate | string | = != |
| accountingPeriod | string | = != |
| amount | number | = != |
| basisSource | string | = != |
| createdBy | string | = != |
| creationDate | string | = != |
| creditAmount | number | = != |
| currencyCode | string | = != |
| debitAmount | number | = != |
| directBilledStakeholder | string | = != |
| directBilledStakeholderDescription | string | = != |
| distributionType | string | = != |
| expenditureType | string | = != |
| expenditureTypeDescription | string | = != |
| headerId | integer | = != |
| jointVenture | string | = != |
| jointVentureDescription | string | = != |
| journalDescription | string | = != |
| lastUpdateDate | string | = != |
| lastUpdatedBy | string | = != |
| ledger | string | = != |
| lineNumber | integer | = != |
| method | string | = != |
| methodDescription | string | = != |
| notes | string | = != |
| ownershipDefinition | string | = != |
| project | string | = != |
| projectNumber | string | = != |
| structureInstanceNumber | integer | = != |
| task | string | = != |
| taskNumber | string | = != |
| transactionDate | string | = != |
| transactionId | integer | = != |
| transactionStatus | string | = != |
| transactionType | string | = != |
Child resources (2)
Each child is reachable at
/jointVentureSourceTransactions/{id}/child/<name>
and most can also be inlined with expand.
attachmentssourceTransactionDFF Response fields (38)
Top-level attributes returned for each row. Use
fields= to request a subset and shrink the payload.
accountaccountingDateaccountingPeriodamountattachmentsbasisSourcecreatedBycreationDatecreditAmountcurrencyCodedebitAmountdirectBilledStakeholderdirectBilledStakeholderDescriptiondistributionTypeexpenditureTypeexpenditureTypeDescriptionheaderIdjointVenturejointVentureDescriptionjournalDescriptionlastUpdateDatelastUpdatedByledgerlineNumbermethodmethodDescriptionnotesownershipDefinitionprojectprojectNumbersourceTransactionDFFstructureInstanceNumbertasktaskNumbertransactionDatetransactionIdtransactionStatustransactionType 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
- /debitAuthorizations Get all debit authorizations
- /jointVentureOptions Get all joint venture options
- /expenseMiscPolicies Get all expense miscellaneous policies
- /jointVentureOverheadTransactions Get all overhead transactions
- /withholdingTaxLines Get all withholding 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