Oracle Fusion Cloud - Actions

The Oracle Fusion Cloud connector supports the following actions.

Create record action

The Create record action creates a new record for a specified object in Oracle Fusion Cloud. For example, it can create a receivable invoice for a specific customer account.

All attributes and child objects appear as input fields after you set up the connection and select the object you plan to create. Provide the required fields and populate required child objects (manually or using lists) to create the record.

Add main attributes under Receivable Invoice

Pass a list to create Invoice lines (child object) under Receivable Invoice

Create records action (batch)

The Create records batch action creates new records for a specified object in Oracle Fusion Cloud in batches. For example, it can create multiple receivable invoices for a specific customer account.

All attributes and child objects appear as input fields after you set up the connection and select the object. Provide the required fields and populate required child objects (manually or using lists) to create the records.

Input

Input field	Description
Object	Select the object type of the records you plan to create.
Records	Expand this section to fill in information related to the records you plan to create.
Records source list	Input a list datapill.

Additional input fields are available based on the object you select.

Output

Output field	Description
Items	A list of the created records.

Additional output fields are available based on the object you select.

Get record action

The Get record action retrieves a specific record by its internal ID. For example, to fetch a product, provide the Inventory item ID. The required field appears automatically after the object is selected.

Get product in Oracle Fusion Cloud

Use the Expand field to retrieve related child and grandchild objects. By default, the response includes only the record and its child objects. To include grandchild objects, use the Expand field to select them. For example, under Receivable credit memo, include attachments (grandchild) for each credit memo line (child).

Expand field under Receivables credit memo

Search records action

The Search records action allows searching by specifying attribute values directly. Use And or Or to combine attributes:

• And: Returns records matching all specified attributes.
• Or: Returns records matching at least one specified attribute.

In this example, the And operation is used to search for invoices where the currency is USD and the amount is 30000.

Invoice search using Search records action

Users can also define the Limit and Offset to paginate through results. The Expand field is available to retrieve related objects, similar to the Get record action.

Search records using advanced query action

The Search records using advanced query action allows querying records using three key inputs:

• Query: Defines the WHERE clause, similar to SQL. Learn more (opens new window).
• Finder: Uses predefined queries associated with the object. Learn more (opens new window).
• Fields: Specifies fields to include in the output to reduce payload size.

Additional options:

• Limit and Offset: Paginate through large datasets.
• Order by: Sort by one or more fields using field:order format (for example, amount:asc,date:desc).

Receivables customer workspace activities search using advanced query action

Receivables customer account activities search using advanced query action – Output

Update record action

The Update record action updates an existing record. Select the object to populate its input fields. The primary key of the object is required to identify the record to update.

For example, to update a receivables invoice, select Receivables invoice and provide the Customer transaction ID. Use the Search records action to retrieve the ID, then map it into the update input.

Receivables invoices update action

To update a child object, provide the IDs of both the main object and the child object. For example, provide the Line number ID to update an invoice line.

Invoices child object update

Update records action (batch)

The Update records batch action updates existing records in batches. Select the object to populate its input fields.

Input

Input field	Description
Object	Select the object type of the records you plan to update.
Records	Expand this section to fill in information related to the records you plan to update.
Records source list	Input a list datapill.

Additional input fields are available based on the object you select.

Output

Output field	Description
Items	A list of the updated records.

Additional output fields are available based on the object you select.

Upsert record action

The Upsert record action creates or updates a record. If the primary key (for example, Invoice ID) is present, the record is updated. If not, a new record is created.

Receivables invoice object upsert

The same logic applies to child objects:

• If the primary key is present, update the record.
• If not, insert the record into the existing or new parent object.

Common use cases:

• Add new invoice lines to an existing invoice
• Update a specific invoice line
• Update an invoice with new currency rates
• Insert or update products from a Google Sheet based on Inventory item ID

Delete record action

The Delete record action deletes an existing record. Select an object and then provide its primary key to identify the record to delete.

Receivables invoice object delete