Supported operations
| GET /cashExternalTransactions |
| GET /cashExternalTransactions/{id} |
| PATCH /cashExternalTransactions/{id} |
| POST /cashExternalTransactions |
Finders (10)
Finders are named, pre-built queries with bound parameters. They can search values plain
q filters cannot reach.
| Finder | Bind variables |
|---|---|
| ExternalCashTransactionsFinder | — |
| PrimaryKey | — |
| findByTransactionBankAccountId | — |
| findByTransactionCurrencyCode | — |
| findByTransactionDate | — |
| findByTransactionId | — |
| findByTransactionReference | — |
| findByTransactionSource | — |
| findByTransactionStatus | — |
| findByTransactionType | — |
Example finder request
GET /fscmRestApi/resources/11.13.18.05/cashExternalTransactions?finder=ExternalCashTransactionsFinder Queryable q fields (36)
Only these fields can appear in a q filter expression on
/cashExternalTransactions. Filtering on any other field returns
400 Bad Request.
Example q request
GET /fscmRestApi/resources/11.13.18.05/cashExternalTransactions?q=AccntServicerReference='<value>'&onlyData=true&limit=25
| Field | Type | Operators |
|---|---|---|
| AccntServicerReference | string | = != |
| AccountingFlag | boolean | = != |
| AddendaTxt | string | = != |
| Amount | number | = != |
| AssetAccountCombination | string | = != |
| BankAccountName | string | = != |
| BankConversionRate | number | = != |
| BankConversionRateType | string | = != |
| BankTransactionId | string | = != |
| BusinessUnitName | string | = != |
| CheckNumber | string | = != |
| ClearedDate | string | = != |
| ClearingSystemReference | string | = != |
| CreatedBy | string | = != |
| CreationDate | string | = != |
| CurrencyCode | string | = != |
| CustomerReference | string | = != |
| Description | string | = != |
| EndToEndId | string | = != |
| ExternalTransactionId | integer | = != |
| InstructionIdentification | string | between |
| LastUpdateDate | string | = != |
| LastUpdateLogin | string | = != |
| LastUpdatedBy | string | = != |
| LegalEntityName | string | = != |
| OffsetAccountCombination | string | = != |
| ReconReference | string | = != |
| ReferenceText | string | = != |
| Source | string | = != |
| Status | string | = != |
| StructuredPaymentReference | string | = != |
| TransactionDate | string | = != |
| TransactionId | integer | = != |
| TransactionType | string | = != |
| TransferId | integer | = != |
| ValueDate | string | = != |
Child resources (2)
Each child is reachable at
/cashExternalTransactions/{id}/child/<name>
and most can also be inlined with expand.
attachmentscashExternalTransactionDFF Response fields (38)
Top-level attributes returned for each row. Use
fields= to request a subset and shrink the payload.
AccntServicerReferenceAccountingFlagAddendaTxtAmountAssetAccountCombinationBankAccountNameBankConversionRateBankConversionRateTypeBankTransactionIdBusinessUnitNameCheckNumberClearedDateClearingSystemReferenceCreatedByCreationDateCurrencyCodeCustomerReferenceDescriptionEndToEndIdExternalTransactionIdInstructionIdentificationLastUpdateDateLastUpdateLoginLastUpdatedByLegalEntityNameOffsetAccountCombinationReconReferenceReferenceTextSourceStatusStructuredPaymentReferenceTransactionDateTransactionIdTransactionTypeTransferIdValueDateattachmentscashExternalTransactionDFF 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
- /jointVentureGLDistributions Get all joint venture general ledger distributions
- /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