Supported operations
| DELETE /jointVentureSLATransactions/{id} |
| GET /jointVentureSLATransactions |
| GET /jointVentureSLATransactions/{id} |
| PATCH /jointVentureSLATransactions/{id} |
Finders (3)
Finders are named, pre-built queries with bound parameters. They can search values plain
q filters cannot reach.
| Finder | Bind variables |
|---|---|
| PrimaryKey | — |
| findByStatusNotComplete | — |
| jointVentureTransactionFinder | — |
Example finder request
GET /fscmRestApi/resources/11.13.18.05/jointVentureSLATransactions?finder=PrimaryKey Queryable q fields (56)
Only these fields can appear in a q filter expression on
/jointVentureSLATransactions. Filtering on any other field returns
400 Bad Request.
Example q request
GET /fscmRestApi/resources/11.13.18.05/jointVentureSLATransactions?q=account='<value>'&onlyData=true&limit=25
| Field | Type | Operators |
|---|---|---|
| account | string | = != |
| accountedCreditAmount | number | = != |
| accountedDebitAmount | number | = != |
| accountingClassCode | string | = != |
| accountingDate | string | = != |
| applicationId | integer | = != |
| assignmentRule | string | = != |
| billWhenPaidFlag | boolean | = != |
| businessUnit | string | = != |
| carriedInterestAgreement | string | = != |
| carriedInterestAgreementDescription | string | = != |
| carriedInterestSourceOwnerDefinition | string | = != |
| chartOfAccountsId | integer | = != |
| createdBy | string | = != |
| createdByJointVentureFlag | boolean | = != |
| creationDate | string | = != |
| currencyCode | string | = != |
| distributionOnlyFlag | boolean | = != |
| enteredCreditAmount | number | = != |
| enteredCurrencyCode | string | = != |
| enteredDebitAmount | number | = != |
| expenditureBusinessUnit | string | = != |
| expenditureItemDate | string | = != |
| expenditureOrganization | string | = != |
| expenditureType | string | = != |
| expenditureTypeDescription | string | = != |
| headerId | integer | = != |
| jointVentureDescription | string | = != |
| jointVentureShortName | string | = != |
| journalDescription | string | = != |
| lastUpdateDate | string | = != |
| lastUpdatedBy | string | = != |
| ledgerName | string | = != |
| lineNumber | integer | = != |
| originalOwnerDefinitionShortName | string | = != |
| originalStakeholderDescription | string | = != |
| originalStakeholderShortName | string | = != |
| originalTransactionPaymentStatus | string | = != |
| overrideExpenditureType | string | = != |
| overrideTask | string | = != |
| ownerDefinitionShortName | string | = != |
| partyTypeCode | string | = != |
| periodName | string | = != |
| projectName | string | = != |
| projectNumber | string | = != |
| source | string | = != |
| sourceTable | string | = != |
| stakeholderDescription | string | = != |
| stakeholderShortName | string | = != |
| statisticalAmount | number | = != |
| taskName | string | = != |
| taskNumber | string | = != |
| transactionDate | string | = != |
| transactionId | integer | = != |
| transactionStatus | string | = != |
| transactionType | string | = != |
Child resources (3)
Each child is reachable at
/jointVentureSLATransactions/{id}/child/<name>
and most can also be inlined with expand.
transactionAccounttransactionChangestransactionDFF Response fields (67)
Top-level attributes returned for each row. Use
fields= to request a subset and shrink the payload.
accountaccountDescriptionaccountedCreditAmountaccountedDebitAmountaccountingClassCodeaccountingDateapplicationIdassignmentRulebillWhenPaidFlagbusinessUnitcarriedInterestAgreementcarriedInterestAgreementDescriptioncarriedInterestSourceOwnerDefinitionchangeReasonchangeReasonDetailschartOfAccountsIdcreatedBycreatedByJointVentureFlagcreationDatecurrencyCodedistributionOnlyFlagenteredCreditAmountenteredCurrencyCodeenteredDebitAmountexpenditureBusinessUnitexpenditureItemDateexpenditureOrganizationexpenditureTypeexpenditureTypeDescriptionheaderIdjointVentureDescriptionjointVentureShortNamejournalDescriptionlastUpdateDatelastUpdatedByledgerNamelineNumberoriginalOwnerDefinitionShortNameoriginalStakeholderDescriptionoriginalStakeholderShortNameoriginalTransactionPaymentStatusoverrideExpenditureTypeoverrideTaskownerDefinitionShortNamepartyNamepartyNumberpartySiteNamepartySiteNumberpartyTypeCodeperiodNameprojectNameprojectNumbersourcesourceTablestakeholderDescriptionstakeholderShortNamestatisticalAmounttaskNametaskNumbertransactionAccounttransactionChangestransactionChangesExistFlagtransactionDFFtransactionDatetransactionIdtransactionStatustransactionType 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
- /jointVentureGeneratedDistributions Get all distributions for joint venture generated transactions
- /payablesOptions Get payables options for all business units
- /cashBankAccounts Get all bank accounts
- /jointVentureTransactions Get all joint venture transactions
- /jointVentureOverheadDistributions Get all overhead distributions
- 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