Table of Contents

Oracle Fusion Cloud ERP

Active
This application does not need additional settings. So you can make connectionUnique, active service acces point to a network. There are different types of connections (API key, Oauth…). More only by using your login credentials or by following the instructions below .

Oracle Fusion Cloud ERP

With Oracle Fusion Cloud ERP modulesThe module is an application or tool within the Boost.space system. The entire system is built on this concept of modularity. (module - Contacts) More in Boost.spaceCentralization and synchronization platform, where you can organize and manage your data. More IntegratorPart of the Boost.space system, where you can create your connections and automate your processes. More, you can watch, search for, create, retrieve, update, and delete recordsOne row in the Boost.space database. These are individual rows under spaces in each module. For example single products, but not their variants. More.

	Note
	To use the Oracle Fusion Cloud ERP app in Boost.space Integrator, you must have the Boost.space Integrator Enterprise planCombination of a license (enabled features) and tier (numeric limits) and a subscription period (monthly / yearly).. All Enterprise apps are currently labeled as `premium tier 3` in Boost.space Integrator.

Refer to the Oracle Fusion Cloud ERP API documentation for a list of available endpoints.

Connect Oracle Fusion Cloud ERP to Boost.space Integrator

To establish the connection, you must enter your Oracle Cloud service server name and login credentials. This information can be found in the Oracle Cloud service welcome email sent to your Oracle Cloud service administrator.

Log in to your Boost.space Integrator account, add an Oracle Fusion Cloud ERP moduleThe module is an application or tool within the Boost.space system. The entire system is built on this concept of modularity. (module - Contacts) More to your scenarioA specific connection between applications in which data can be transferred. Two types of scenarios: active/inactive. More, and click Create a connection.
Optional: In the Connection name field, enter a name for the connection.
In the Server Name field, enter the URL of your Oracle Cloud service. For example, servername.fa.us2.oraclecloud.com.
In the Username and Password fields, enter your Oracle Cloud service login credentials. Your account must have the necessary userCan use the system on a limited basis based on the rights assigned by the admin. More permissions to be able to access the relevant records in Boost.space Integrator.
Set the connection’s Scope by selecting the relevant recordOne row in the Boost.space database. These are individual rows under spaces in each module. For example single products, but not their variants. More types.

Note: If you receive a data.collection is too big errorService is unavailable due to a failure, a service responds with unexpected data or the validation of input data fails. More, limit the Scope selection to specific record types.
Click Save.

You have successfully established the connection. You can now edit your scenario and add more Oracle Fusion Cloud ERP modules. If your connection requires reauthorization at any point, follow the connection renewal steps here.

	Caution
	The connection may take up to 5 minutes to establish. Please leave the connection window open until the connection is successful.

Records

Watch Records

TriggersEvery scenario has a trigger, an event that starts your scenario. A scenario must have a trigger. There can only be one trigger for each scenario. When you create a new scenario, the first module you choose is your trigger for that scenario. Create a trigger by clicking on the empty module of a newly created scenario or moving the... when records are created.

Connection	Establish a connection to your Oracle Fusion Cloud ERP account.
Record Type Category	Select the category of the record type to watch for. Available record types and categories are based on the scopes selected when creating the connection and your Oracle user rights at that time. If your user rights change, go to your Connections page and click Verify next to your connection to update this list. If you receive an error stating `This action is not supported in this category`, the selected record type category is not compatible with this module. Please choose a different record type category to watch for.
Record Type	Select the record type to watch for. If no record types are shown, you do not have the user rights for the record type category selected above. The selected record type must contain a ‘datetime’ parameter. If it does not, you will receive an error prompting you to choose a different record type.
Parent ID	Enter the parent ID or `@context.key` value of the records you want to watch for. Different record types use different parameters as ID.
Date Field	Select which of the record’s date fields will triggerEvery scenario has a trigger, an event that starts your scenario. A scenario must have a trigger. There can only be one trigger for each scenario. When you create a new scenario, the first module you choose is your trigger for that scenario. Create a trigger by clicking on the empty module of a newly created scenario or moving the... the module. It must be type: `datetime`.
LabelA label is a “tag” that can be added to items within a module. It's a flexible tool used to categorize and organize data, making it easier to customize workflows and processes. More Field	Select the label to show when configuring Choose where to start > Choose manually in the module setup.
Fields	Select the record fields to be returned. To improve performance, limit the amount of fields selected.
Limit	Enter the maximum number of results to be worked with during one execution cycleA cycle is the operation and commit/rollback phases of scenario execution. A scenario may have one or more cycles (one is the default)..

Search Records

Retrieves a list of records filtered by criteria.

Connection	Establish a connection to your Oracle Fusion Cloud ERP account.
Record Type Category	Select the category of the record type to search for. Available record types and categories are based on the scopes selected when creating the connection and your Oracle user rights at that time. If your user rights change, go to your Connections page and click Verify next to your connection to update this list. If you receive an error stating `This action is not supported in this category`, the selected record type category is not compatible with this module. Please choose a different record type category to search for.
Record Type	Select the record type to search for. If no record types are shown, you do not have the user rights for the record type category selected above.
Parent ID	Enter the parent ID of the records you want to search for. When mappingMapping links the modules in your scenario. When you map an item, you connected the data retrieved by one module to another module to perform the desired action. For example, you can map the email address and subject lines from the Email > Watch emails module to Google Sheets > Add a row and create a spreadsheet of email addresses..., use the `@context.key` value. Different record types use different parameters as ID.
Query Builder	Select whether to use the Builder (filter by selecting from list) or Custom (enter a query string) method to specify filters.
Filter	Create filters to narrow down the search records returned.
Query String	Enter a query string according to the Oracle Fusion Cloud documentation.
Order By	Map or enter the direction in which fields should be returned.
Fields	Select or map the record fields to be returned. To improve performance, limit the amount of fields selected.
Effective Date	Enter the effective date of the records to return. For more information about supported date formats, see the expected date information here.
Limit	Enter the maximum number of results to be worked with during one execution cycle.

Troubleshooting

Oracle search limitations:

[400] Bad Request. Failed to build ViewCriteria from expression...

[500] Internal Server Error.

Due to Oracle limitations, certain record type categories cannot be searched for.

Required fields:

[400] Bad Request. Provide a valid value for [input field].

The input field displayed in the error message is required. Return to the module inputs, enter a value into the required field, and run the module again.

Create a Record

Creates a new record.

Connection	Establish a connection to your Oracle Fusion Cloud ERP account.
Record Type Category	Select the category of the record type to create. Available record types and categories are based on the scopes selected when creating the connection and your Oracle user rights at that time. If your user rights change, go to your Connections page and click Verify next to your connection to update this list. If you receive an error stating `This action is not supported in this category`, the selected record type category is not compatible with this module. Please choose a different record type category to create.
Record Type	Select the record type to create. If no record types are shown, you do not have the user rights for the record type category selected above.
Parent ID	Enter the parent ID of the record you want to create. When mapping, use the `@context.key` value. Different record types use different parameters as ID.
Record Details	Enter or map the information of the record you want to create into the fields that appear. The fields are dependent upon the selected Record Type.

Troubleshooting

Required fields:

[400] Bad Request. Provide a valid value for [input field].

The input field displayed in the error message is required. Return to the module inputs, enter a value into the required field, and run the module again.

Get a Record

Retrieves the details of a record by its ID.

Connection	Establish a connection to your Oracle Fusion Cloud ERP account.
Record Type Category	Select the category of the record type to retrieve details of. Available record types and categories are based on the scopes selected when creating the connection and your Oracle user rights at that time. If your user rights change, go to your Connections page and click Verify next to your connection to update this list. If you receive an error stating `This action is not supported in this category`, the selected record type category is not compatible with this module. Please choose a different record type category to retrieve.
Record Type	Select the record type to retrieve details of. If no record types are shown, you do not have the user rights for the record type category selected above.
Parent ID	Enter the parent ID of the records you want to retrieve details of. When mapping, use the `@context.key` value. Different record types use different parameters as ID.
ID	Enter the ID of the records you want to retrieve details of. When mapping, use the `@context.key` value. Different record types use different parameters as ID.
Expand	Enter the name of a child record to include the details of. To specify multiple child record types, use a `,` as a separator. For example: `Employees,Localizations`. To specify nested child records types, use the format `Child.NestedChild`. For example: `Employees.Managers`. If a nested child is provided, the relevant child will be processed implicitly – Employees.Managers is the same as Employees,Employees.Managers.

Update a Record

Updates a record by its ID.

Connection	Establish a connection to your Oracle Fusion Cloud ERP account.
Record Type Category	Select the category of the record type to update. Available record types and categories are based on the scopes selected when creating the connection and your Oracle user rights at that time. If your user rights change, go to your Connections page and click Verify next to your connection to update this list. If you receive an error stating `This action is not supported in this category`, the selected record type category is not compatible with this module. Please choose a different record type category to update.
Record Type	Select the record type to update. If no record types are shown, you do not have the user rights for the record type category selected above.
Parent ID	Enter the parent ID of the record you want to update. When mapping, use the `@context.key` value. Different record types use different parameters as ID.
ID	Enter the ID of the record you want to update. When mapping, use the `@context.key` value. Different record types use different parameters as ID.
Record Details	Enter or map the information you want to update in the fields that appear. The fields are dependent upon the selected Record Type.

Delete a Record

Deletes a record by its ID.

Connection	Establish a connection to your Oracle Fusion Cloud ERP account.
Record Type Category	Select the category of the record type to delete. Available record types and categories are based on the scopes selected when creating the connection and your Oracle user rights at that time. If your user rights change, go to your Connections page and click Verify next to your connection to update this list. If you receive an error stating `This action is not supported in this category`, the selected record type category is not compatible with this module. Please choose a different record type category to delete.
Record Type	Select the record type to delete. If no record types are shown, you do not have the user rights for the record type category selected above.
Parent ID	Enter the parent ID of the record you want to delete. When mapping, use the `@context.key` value. Different record types use different parameters as ID.
ID	Enter the ID of the record you want to delete. When mapping, use the `@context.key` value. Different record types use different parameters as ID.

Other

Make an API Call

Performs an arbitrary authorized API Call.

Connection	Establish a connection to your Oracle Fusion Cloud ERP account.
URL	Enter a path relative to `https://<servername>/`. For example: `/fscmRestApi/resources/11.13.18.05/invoices`. Refer to the Oracle Fusion Cloud ERP API documentation for a list of available endpoints.
Method	Select or map the HTTP method you want to use: GET to retrieve information for an entry. POST to create a new entry. PUT to update/replace an existing entry. PATCH to make a partial entry update. DELETE to delete an entry.
Headers	Enter or map the desired request headers. You don’t have to add authorization headers; we already did that for you.
Query String	Enter or map the request query string.
Body	Enter the body content for your API call.