Skip to content
Documentation
Contact
← Back to documentation
Technical Reference

Oracle Fusion Cloud ERP

Enterprise resource planning suite covering financials, procurement, project accounting, supply chain, and more.

CategoryAccounting
Authenticationcustom
Version0.1.0
Published scopes0 published scopes
Last updatedSeptember 21, 2026

Overview

Connect Oracle Fusion Cloud ERP with Flows360

Enterprise resource planning suite covering financials, procurement, project accounting, supply chain, and more.

Use the Oracle Fusion Cloud ERP connector to include its declared actions and events in Flows360 workflows without duplicating the integration logic inside each consuming system. This pinned connector version currently exposes 23 actions and no declared triggers.

Available actions

  • Create Invoice
  • Get Invoice
  • Find Invoices
  • Update Invoice
  • Delete Invoice
  • Validate Invoice
  • Cancel Invoice
  • Create Receivables Invoice
  • Plus 15 additional declared actions.

Available triggers

  • No triggers are declared in this pinned package.

The capability list above is generated from the exact reviewed connector package so the public description stays aligned with the version Flows360 operates.

Technical guide

Technical reference

Package identity

  • Connector: Oracle Fusion Cloud ERP
  • Package: @activepieces/piece-oracle-fusion-cloud-erp@0.1.0
  • Exact artifact digest: sha256:4e569814ad20c2e1922a7e178c978c62d1985542be003ff5e54fde890c6004a7
  • Runtime: Activepieces-compatible deterministic worker
  • Source: the exact reviewed Activepieces source

Authentication

CUSTOM AUTH. Connection values are tenant-specific and remain in the consuming Studio instance; CDK stores definitions and field metadata, not customer credential values.

Action contracts

  • Create Invoice (create_invoice), Creates a new payables invoice in Oracle Fusion Cloud ERP. Classification: read.
  • Get Invoice (get_invoice), Retrieves details of a specific payables invoice by ID. Classification: read.
  • Find Invoices (find_invoices), Search for payables invoices with optional filters. Classification: read.
  • Update Invoice (update_invoice), Updates an existing payables invoice. Note: Only certain attributes can be updated and cascade defaulting does not apply. Classification: read.
  • Delete Invoice (delete_invoice), Deletes a payables invoice from Oracle Fusion Cloud ERP. Classification: read.
  • Validate Invoice (validate_invoice), Validates a payables invoice in Oracle Fusion Cloud ERP. Classification: read.
  • Cancel Invoice (cancel_invoice), Cancels a payables invoice in Oracle Fusion Cloud ERP. Classification: read.
  • Create Receivables Invoice (create_receivables_invoice), Creates a new receivables (AR) invoice in Oracle Fusion Cloud ERP. Classification: read.
  • Get Receivables Invoice (get_receivables_invoice), Retrieves details of a specific receivables invoice by ID. Classification: read.
  • Find Receivables Invoices (find_receivables_invoices), Search for receivables invoices with optional filters. Classification: read.
  • Update Receivables Invoice (update_receivables_invoice), Updates an existing receivables invoice. Note: Only InvoiceStatus, PaymentTerms, and TransactionDate can be updated. Classification: read.
  • Delete Receivables Invoice (delete_receivables_invoice), Deletes a receivables invoice from Oracle Fusion Cloud ERP. Classification: read.
  • Create Payment (create_payment), Creates a new manual payment in Oracle Fusion Cloud ERP. Classification: read.
  • Get Payment (get_payment), Retrieves details of a specific payment by Check ID. Classification: read.
  • Find Payments (find_payments), Search for payments with optional filters. Classification: read.
  • Update Payment (update_payment), Updates descriptive and global flexfields for a payment. Classification: read.
  • Stop Payment (stop_payment), Initiates a stop payment request for a payment. Classification: read.
  • Void Payment (void_payment), Voids a payment by setting the void date. Classification: read.
  • Get Journal Batch (get_journal_batch), Retrieves details of a specific journal batch by ID. Classification: read.
  • Find Journal Batches (find_journal_batches), Search for journal batches with optional filters. Classification: read.
  • Update Journal Batch (update_journal_batch), Updates batch completion status and reversal attributes. Note: Only status and reversal attributes can be updated. Classification: read.
  • Delete Journal Batch (delete_journal_batch), Deletes a journal batch from Oracle Fusion Cloud ERP. Classification: read.
  • Custom API Call (custom_api_call), Make a custom API call to a specific endpoint Classification: read.

Trigger contracts

  • No trigger delivery contracts are declared.

Verification

Deterministic execution evidence is recorded for the pinned artifact, including 1 exercised action entrypoint and 0 exercised trigger entrypoints.

Capability summary

Authenticationcustom
Supported objects23
Supported actions23
TriggersNone published

Authentication

Authentication method: custom

Authentication profiles

connection · custom
  • Server URL Required
  • Username Required
  • Password Required · protected credential

Supported objects

ObjectReadWriteNotes
Create Invoice Yes No Creates a new payables invoice in Oracle Fusion Cloud ERP.
Get Invoice Yes No Retrieves details of a specific payables invoice by ID.
Find Invoices Yes No Search for payables invoices with optional filters.
Update Invoice Yes No Updates an existing payables invoice. Note: Only certain attributes can be updated and cascade defaulting does not apply.
Delete Invoice Yes No Deletes a payables invoice from Oracle Fusion Cloud ERP.
Validate Invoice Yes No Validates a payables invoice in Oracle Fusion Cloud ERP.
Cancel Invoice Yes No Cancels a payables invoice in Oracle Fusion Cloud ERP.
Create Receivables Invoice Yes No Creates a new receivables (AR) invoice in Oracle Fusion Cloud ERP.
Get Receivables Invoice Yes No Retrieves details of a specific receivables invoice by ID.
Find Receivables Invoices Yes No Search for receivables invoices with optional filters.
Update Receivables Invoice Yes No Updates an existing receivables invoice. Note: Only InvoiceStatus, PaymentTerms, and TransactionDate can be updated.
Delete Receivables Invoice Yes No Deletes a receivables invoice from Oracle Fusion Cloud ERP.
Create Payment Yes No Creates a new manual payment in Oracle Fusion Cloud ERP.
Get Payment Yes No Retrieves details of a specific payment by Check ID.
Find Payments Yes No Search for payments with optional filters.
Update Payment Yes No Updates descriptive and global flexfields for a payment.
Stop Payment Yes No Initiates a stop payment request for a payment.
Void Payment Yes No Voids a payment by setting the void date.
Get Journal Batch Yes No Retrieves details of a specific journal batch by ID.
Find Journal Batches Yes No Search for journal batches with optional filters.
Update Journal Batch Yes No Updates batch completion status and reversal attributes. Note: Only status and reversal attributes can be updated.
Delete Journal Batch Yes No Deletes a journal batch from Oracle Fusion Cloud ERP.
Custom API Call Yes No Make a custom API call to a specific endpoint

Supported actions

Create Invoice · Read

Creates a new payables invoice in Oracle Fusion Cloud ERP.

create_invoice · Risk: low · Retry: safe

Inputs

  • invoiceNumber · string · Required, Unique invoice number from the supplier.
  • businessUnit · string · Required, The business unit name for the invoice.
  • supplier · string · Required, The supplier name on the invoice.
  • supplierSite · string · Required, The supplier site from where goods/services are rendered.
  • invoiceAmount · number · Required, The total invoice amount.
  • invoiceCurrency · string · Required, Currency code (e.g., USD, EUR).
  • paymentCurrency · string · Required, Currency used for payment.
  • invoiceDate · string · Required, Invoice date in YYYY-MM-DD format.
  • accountingDate · string · Required, Accounting date in YYYY-MM-DD format.
  • termsDate · string · Required, Date used with payment terms to calculate due dates (YYYY-MM-DD).
  • paymentMethodCode · string · Required, Payment method code (e.g., CHECK, EFT).
  • paymentTerms · string · Optional, Payment terms used to calculate due dates.
  • description · string · Optional, Description of the invoice.
  • invoiceGroup · string · Optional, Group name for reporting and payment purposes.
  • invoiceType · string · Optional, Type of invoice.
  • requester · string · Optional, Name of the person who requested the goods or services.
Get Invoice · Read

Retrieves details of a specific payables invoice by ID.

get_invoice · Risk: low · Retry: safe

Inputs

  • invoiceId · string · Required, The unique identifier of the invoice (InvoiceId or invoicesUniqID).
Find Invoices · Read

Search for payables invoices with optional filters.

find_invoices · Risk: low · Retry: safe

Inputs

  • invoiceNumber · string · Optional, Filter by invoice number.
  • supplier · string · Optional, Filter by supplier name.
  • businessUnit · string · Optional, Filter by business unit.
  • validationStatus · string · Optional, Filter by validation status.
  • limit · number · Optional, Maximum number of records to return (default: 25, max: 500).
  • offset · number · Optional, Number of records to skip for pagination.
Update Invoice · Read

Updates an existing payables invoice. Note: Only certain attributes can be updated and cascade defaulting does not apply.

update_invoice · Risk: low · Retry: safe

Inputs

  • invoiceId · string · Required, The unique identifier of the invoice to update.
  • description · string · Optional, Updated description for the invoice.
  • paymentTerms · string · Optional, Updated payment terms.
  • payGroup · string · Optional, Updated pay group.
  • invoiceGroup · string · Optional, Updated invoice group.
  • paymentMethodCode · string · Optional, Updated payment method code.
  • remittanceMessageOne · string · Optional, Remittance message for payment processing.
  • remittanceMessageTwo · string · Optional, Additional remittance message.
  • remittanceMessageThree · string · Optional, Additional remittance message.
Delete Invoice · Read

Deletes a payables invoice from Oracle Fusion Cloud ERP.

delete_invoice · Risk: low · Retry: safe

Inputs

  • invoiceId · string · Required, The unique identifier of the invoice to delete.
Validate Invoice · Read

Validates a payables invoice in Oracle Fusion Cloud ERP.

validate_invoice · Risk: low · Retry: safe

Inputs

  • invoiceId · string · Required, The unique identifier of the invoice to validate.
Cancel Invoice · Read

Cancels a payables invoice in Oracle Fusion Cloud ERP.

cancel_invoice · Risk: low · Retry: safe

Inputs

  • invoiceId · string · Required, The unique identifier of the invoice to cancel.
Create Receivables Invoice · Read

Creates a new receivables (AR) invoice in Oracle Fusion Cloud ERP.

create_receivables_invoice · Risk: low · Retry: safe

Inputs

  • businessUnit · string · Required, The business unit under which the invoice is created.
  • transactionType · string · Required, The transaction type assigned to the invoice.
  • transactionSource · string · Optional, The transaction source assigned to the invoice.
  • transactionNumber · string · Optional, The transaction number assigned to the invoice. If not provided, it will be auto-generated.
  • transactionDate · string · Optional, The date when the invoice was created (YYYY-MM-DD).
  • accountingDate · string · Optional, The accounting date assigned to the invoice (YYYY-MM-DD).
  • billToCustomerNumber · string · Required, The account number of the bill-to customer.
  • billToCustomerName · string · Optional, The name of the bill-to customer.
  • billToSite · string · Optional, The number that identifies the bill-to customer site.
  • invoiceCurrencyCode · string · Optional, The currency code of the invoice (e.g., USD, EUR).
  • paymentTerms · string · Optional, The payment terms assigned to the invoice.
  • dueDate · string · Optional, The date when the invoice is due (YYYY-MM-DD).
  • purchaseOrder · string · Optional, The purchase order number on the invoice.
  • comments · string · Optional, Comments that accompany the invoice.
  • invoiceStatus · string · Optional, The completion status of the invoice. Must be Complete when creating.
  • shipToCustomerNumber · string · Optional, The registry identifier of the ship-to customer.
  • shipToCustomerName · string · Optional, The name of the customer who receives the goods or services.
  • legalEntityIdentifier · string · Optional, The unique identifier of the legal entity.
  • crossReference · string · Optional, The reference field default value from the transaction source.
Get Receivables Invoice · Read

Retrieves details of a specific receivables invoice by ID.

get_receivables_invoice · Risk: low · Retry: safe

Inputs

  • customerTransactionId · string · Required, The unique identifier of the receivables invoice.
Find Receivables Invoices · Read

Search for receivables invoices with optional filters.

find_receivables_invoices · Risk: low · Retry: safe

Inputs

  • transactionNumber · string · Optional, Filter by transaction number.
  • billToCustomerNumber · string · Optional, Filter by bill-to customer account number.
  • invoiceStatus · string · Optional, Filter by invoice status.
  • billingDateFrom · string · Optional, Filter invoices with billing date on or after this date (YYYY-MM-DD).
  • billingDateTo · string · Optional, Filter invoices with billing date on or before this date (YYYY-MM-DD).
  • limit · number · Optional, Maximum number of records to return (default: 25, max: 500).
  • offset · number · Optional, Number of records to skip for pagination.
Update Receivables Invoice · Read

Updates an existing receivables invoice. Note: Only InvoiceStatus, PaymentTerms, and TransactionDate can be updated.

update_receivables_invoice · Risk: low · Retry: safe

Inputs

  • customerTransactionId · string · Required, The unique identifier of the receivables invoice to update.
  • invoiceStatus · string · Optional, The completion status of the invoice.
  • paymentTerms · string · Optional, The payment terms assigned to the invoice.
  • transactionDate · string · Optional, The date when the invoice was created (YYYY-MM-DD).
Delete Receivables Invoice · Read

Deletes a receivables invoice from Oracle Fusion Cloud ERP.

delete_receivables_invoice · Risk: low · Retry: safe

Inputs

  • customerTransactionId · string · Required, The unique identifier of the receivables invoice to delete.
Create Payment · Read

Creates a new manual payment in Oracle Fusion Cloud ERP.

create_payment · Risk: low · Retry: safe

Inputs

  • businessUnit · string · Required, The business unit name for the payment.
  • paymentNumber · number · Required, The check number printed on physical check.
  • paymentDate · string · Required, The date when the payment is made (YYYY-MM-DD).
  • paymentCurrency · string · Required, The currency in which payment is made (e.g., USD).
  • paymentMethodCode · string · Required, The payment method code (e.g., CHECK, EFT).
  • payee · string · Optional, The party name to whom payment is made.
  • payeeSite · string · Optional, The supplier site name to whom payment is made.
  • paymentProcessProfile · string · Optional, The payment process profile name.
  • paymentDocument · string · Optional, The name of the payment document.
  • paymentDescription · string · Optional, The user description for the payment.
  • disbursementBankAccountName · string · Optional, The name of the internal bank account from where the payment is made.
  • remitToAccountNumber · string · Optional, The supplier's bank account number for electronic payment.
  • conversionRateType · string · Optional, The type of conversion rate used for foreign currency payments.
  • conversionRate · number · Optional, The conversion rate for foreign currency payments.
  • addressLine1 · string · Optional, The first address line of party to whom the payment is made.
  • city · string · Optional, The city name of the party to whom the payment is made.
  • state · string · Optional, The state name of the party to whom the payment is made.
  • country · string · Optional, The country name of the party to whom the payment is made.
  • zip · string · Optional, The postal code of the party to whom the payment is made.
Get Payment · Read

Retrieves details of a specific payment by Check ID.

get_payment · Risk: low · Retry: safe

Inputs

  • checkId · string · Required, The unique identifier of the payment.
Find Payments · Read

Search for payments with optional filters.

find_payments · Risk: low · Retry: safe

Inputs

  • paymentNumber · number · Optional, Filter by payment number.
  • payee · string · Optional, Filter by payee name.
  • businessUnit · string · Optional, Filter by business unit.
  • paymentStatus · string · Optional, Filter by payment status.
  • paymentDateFrom · string · Optional, Filter payments on or after this date (YYYY-MM-DD).
  • paymentDateTo · string · Optional, Filter payments on or before this date (YYYY-MM-DD).
  • limit · number · Optional, Maximum number of records to return (default: 25, max: 500).
  • offset · number · Optional, Number of records to skip for pagination.
Update Payment · Read

Updates descriptive and global flexfields for a payment.

update_payment · Risk: low · Retry: safe

Inputs

  • checkId · string · Required, The unique identifier of the payment to update.
  • paymentDescription · string · Optional, Updated description for the payment.
  • voidDate · string · Optional, The date when the payment is voided (YYYY-MM-DD).
  • voidAccountingDate · string · Optional, The date when the voided payment is accounted (YYYY-MM-DD).
Stop Payment · Read

Initiates a stop payment request for a payment.

stop_payment · Risk: low · Retry: safe

Inputs

  • checkId · string · Required, The unique identifier of the payment to stop.
  • stopReason · string · Optional, The reason for stopping the payment.
  • stopReference · string · Optional, A reference for the stop payment request.
Void Payment · Read

Voids a payment by setting the void date.

void_payment · Risk: low · Retry: safe

Inputs

  • checkId · string · Required, The unique identifier of the payment to void.
  • voidDate · string · Optional, The date when the payment is voided (YYYY-MM-DD). Defaults to today.
  • voidAccountingDate · string · Optional, The date when the voided payment is accounted (YYYY-MM-DD).
Get Journal Batch · Read

Retrieves details of a specific journal batch by ID.

get_journal_batch · Risk: low · Retry: safe

Inputs

  • jeBatchId · string · Required, The unique identifier of the journal batch.
  • expand · array · Optional, Select child resources to include in the response.
Find Journal Batches · Read

Search for journal batches with optional filters.

find_journal_batches · Risk: low · Retry: safe

Inputs

  • batchName · string · Optional, Filter by batch name.
  • status · string · Optional, Filter by batch status.
  • defaultPeriodName · string · Optional, Filter by accounting period name.
  • userJeSourceName · string · Optional, Filter by journal source name.
  • createdBy · string · Optional, Filter by the user who created the batch.
  • limit · number · Optional, Maximum number of records to return (default: 25, max: 500).
  • offset · number · Optional, Number of records to skip for pagination.
Update Journal Batch · Read

Updates batch completion status and reversal attributes. Note: Only status and reversal attributes can be updated.

update_journal_batch · Risk: low · Retry: safe

Inputs

  • jeBatchId · string · Required, The unique identifier of the journal batch to update.
  • status · string · Optional, The status of the batch.
  • reversalFlag · boolean · Optional, Indicates whether to reverse all journals in the batch.
  • reversalDate · string · Optional, The reversal date for the journals in the batch (YYYY-MM-DD).
  • reversalPeriod · string · Optional, The reversal period for the journals in the batch.
  • reversalMethodMeaning · string · Optional, The reversal method for the journals in the batch.
Delete Journal Batch · Read

Deletes a journal batch from Oracle Fusion Cloud ERP.

delete_journal_batch · Risk: low · Retry: safe

Inputs

  • jeBatchId · string · Required, The unique identifier of the journal batch to delete.
Custom API Call · Read

Make a custom API call to a specific endpoint

custom_api_call · Risk: low · Retry: safe

Inputs

  • url · object · Required
  • method · string · Required
  • headers · object · Optional, Authorization headers are injected automatically from your connection.
  • queryParams · object · Optional, Appended to the URL as ?key=value.
  • body_type · string · Optional
  • body · object · Optional
  • response_is_binary · boolean · Optional, Enable for files like PDFs, images, etc.
  • failsafe · boolean · Optional, On a failed request, output the error instead of failing the step.
  • timeout · number · Optional, Seconds to wait for a response. Empty: up to the flow limit (10 min).
  • followRedirects · boolean · Optional, Follow 3xx redirects instead of returning them as the response.

Setup

Setup

  1. Add the Oracle Fusion Cloud ERP connector to the workflow in the target Flows360 Studio instance.
  2. Create or select the tenant-specific connection required by the connector. Connection secrets remain in the Studio connection boundary and are not copied into CDK documentation.
  3. Provide the connection fields declared by the pinned package:
  • Server URL (serverUrl), required.
  • Username (username), required.
  • Password (password), required; stored as a sensitive connection value.
  1. Select the required action or trigger and complete its declared input fields. Required and optional inputs are defined by the exact package schema.
  2. Test the workflow in the appropriate environment before enabling production scheduling or event delivery.

Limitations

Limitations and operational notes

  • This content describes @activepieces/piece-oracle-fusion-cloud-erp@0.1.0; provider behaviour can change independently and should be revalidated when the provider or connector version changes.
  • Only the 23 actions and 0 triggers declared by this pinned package are represented here.
  • Tenant credentials and connection values are not stored in the public connector record.
  • Provider-side permissions, account entitlements, quotas and rate limits remain subject to the connected provider account and are not inferred when the package does not declare them.
  • Deterministic execution evidence is recorded for the pinned artifact, including 1 exercised action entrypoint and 0 exercised trigger entrypoints.

Troubleshooting

Why canu2019t the connector authenticate?

Check the tenant connection in Studio and confirm every required Oracle Fusion Cloud ERP connection field is present. Re-authorise OAuth-based connections if the provider token or consent has expired. Do not place credential values in CDK content or logs.

Why is an action or trigger unavailable?

Confirm that the workflow is using @activepieces/piece-oracle-fusion-cloud-erp@0.1.0 and compare the requested capability with the declared action and trigger list for this version. A capability that is not declared by the pinned package should not be presented as supported.

What should I check after a provider-side change?

Revalidate authentication, required fields, action/trigger behaviour and provider documentation before publishing refreshed connector content or moving a new package version into production.

github.com