// fusionrest agent · financials

Joint Venture Subledger Transactions

jointVentureSLATransactions Based on 26C

Change, delete and look up Joint Venture Subledger Transactions, with transaction account and transaction changes. Actions include clear ownership assignment. No create.

The record key jointVentureSLATransactionsUniqID is a generated hash. Take it from the record's links (rel self) in a GET response; never build it yourself.

Oracle documents an Effective-Of header and an effectiveDate parameter for this resource, used for date-effective reads and changes.

/fscmRestApi/resources/11.13.18.05/jointVentureSLATransactions
Operations
GET (list)GET (one)PATCH (update)DELETE1 action
Record key
jointVentureSLATransactionsUniqID
Required on create
no create on this resource
At a glance
67 fields2 finders3 children
Extra parameters
?effectiveDate=Effective-Of:
I want to…List the latest 25Count recordsGet one recordUpdate one

Try it

Response fields ·
Filters (q)

Only attributes Oracle marks as searchable are offered.

Finder
Include children (expand)
Paging and options
limit
Endpoint and headers
GET /fscmRestApi/resources/11.13.18.05/jointVentureSLATransactions?fields=account,accountDescription,accountedCreditAmount,accountedDebitAmount,accountingClass&limit=25&onlyData=true
Response shape (placeholders)
{
  "items": [
    {
      "account": "<string>",
      "accountDescription": "<string>",
      "accountedCreditAmount": 0,
      "accountedDebitAmount": 0,
      "accountingClass": "<string, max 80>"
    }
  ],
  "count": 25,
  "hasMore": true,
  "limit": 25,
  "offset": 0
}

Shapes and placeholders, not real data. Replace https://<your-pod> and the login with your own: this site never sees them. Based on Oracle's 26C REST specification.

Fields 67

AttributeTypeUse
accounttextRead-onlySearchable
accountDescriptiontextRead-only
accountedCreditAmountnumberRead-onlySearchable
accountedDebitAmountnumberRead-onlySearchable
accountingClasstext · max 80Read-onlySearchable
accountingClassCodetext · max 30Read-onlySearchable
accountingDatedateRead-onlySearchable
applicationIdnumberRead-onlySearchable
assignmentRuletext · max 30Read-onlySearchable
billWhenPaidFlagyes/no · max 1 · default falseRead-onlySearchable
businessUnittext · max 240Read-onlySearchable
carriedInterestAgreementtext · max 30Read-onlySearchable
carriedInterestAgreementDescriptiontext · max 240Read-onlySearchable
carriedInterestSourceOwnerDefinitiontext · max 30Read-onlySearchable
changeReasontext · max 80Updatable
changeReasonDetailstext · max 240Updatable
chartOfAccountsIdnumberRead-onlySearchable
createdBytext · max 64Read-onlySearchable
createdByJointVentureFlagyes/no · max 1Read-onlySearchable
creationDatedate-timeRead-onlySearchable
currencyCodetext · max 15Read-onlySearchable
distributionOnlyFlagyes/no · max 1 · default falseUpdatableSearchable
enteredCreditAmountnumberRead-onlySearchable
enteredCurrencyCodetext · max 15Read-onlySearchable
enteredDebitAmountnumberRead-onlySearchable
eventTypetext · max 80Read-onlySearchable
expenditureBusinessUnittext · max 240UpdatableSearchable
expenditureItemDatedateUpdatableSearchable
expenditureOrganizationtext · max 240UpdatableSearchable
expenditureTypetext · max 240UpdatableSearchable
expenditureTypeDescriptiontext · max 80Read-onlySearchable
headerIdnumberRead-onlySearchable
jointVentureDescriptiontext · max 240Read-onlySearchable
jointVentureShortNametext · max 30Read-onlySearchable
journalDescriptiontext · max 1996Read-onlySearchable
lastUpdateDatedate-timeRead-onlySearchable
lastUpdatedBytext · max 64Read-onlySearchable
ledgerNametext · max 30Read-onlySearchable
lineNumbernumberRead-onlySearchable
originalOwnerDefinitionShortNametext · max 30Read-onlySearchable
originalStakeholderDescriptiontext · max 240Read-onlySearchable
originalStakeholderShortNametext · max 30Read-onlySearchable
originalTransactionPaymentStatustextUpdatableSearchable
overrideExpenditureTypetext · max 240Read-onlySearchable
overrideTasktext · max 255Read-onlySearchable
ownerDefinitionShortNametext · max 30UpdatableSearchable
partyNametextRead-only
partyNumbertextRead-only
partySiteNametextRead-only
partySiteNumbertextRead-only
partyTypeCodetext · max 1Read-onlySearchable
periodNametext · max 15Read-onlySearchable
projectNametext · max 240Read-onlySearchable
projectNumbertext · max 25UpdatableSearchable
sourcetext · max 512Read-onlySearchable
sourceReferenceNumbertext · max 50Read-onlySearchable
sourceTabletext · max 30Read-onlySearchable
stakeholderDescriptiontextUpdatableSearchable
stakeholderShortNametextUpdatableSearchable
statisticalAmountnumberRead-onlySearchable
taskNametext · max 255Read-onlySearchable
taskNumbertext · max 100UpdatableSearchable
transactionChangesExistFlagyes/no · max 255Read-only
transactionDatedateUpdatableSearchable
transactionIdnumberRead-onlySearchable
transactionStatustext · max 80UpdatableSearchable
transactionTypetext · max 80Read-onlySearchable

Names, types, labels and flags from Oracle's REST specification (26C). Flexfield and custom attributes vary by pod: check /describe for yours.

Finders 2

Predefined searches: ?finder=Name;variable=value,variable2=value2. Pick one in Try it to build the call.

Check a payload

Checked in your browser only; nothing you paste is sent anywhere. Checks names and flags, not values.

Children 3

Child resources sit under one record: /fscmRestApi/resources/11.13.18.05/jointVentureSLATransactions/{jointVentureSLATransactionsUniqID}/child/<name>. Add them to a GET with expand.

Actions 1

Actions use Content-Type: application/vnd.oracle.adf.action+json. A path with a {key} runs on one record.

Use in AI Agent Studio

More in For Builders.

Pitfalls