1. Create Customer Records in Oracle ERP Cloud
  2. About This Recipe

1 About This Recipe

Use this recipe to create or update a customer record in Oracle ERP Cloud through a REST request from an external application.

Note:

This recipe is available as REST — Oracle ERP Cloud | Create Customer Records in the Integration Store. Oracle provides this recipe as a sample only. The recipe is meant only for guidance, and is not warranted to be error-free. No support is provided for this recipe.

Overview

This recipe creates or updates a customer record along with account and profile details in Oracle ERP Cloud when it receives a REST request with the customer data from an external application. It contains an app-driven orchestration integration, which uses the standard REST Adapter and the Oracle ERP Cloud Adapter.

To use the recipe, you must install the recipe and configure the connections and other resources within the recipe. Subsequently, you can activate the integration flow and send a REST request with the customer data to the integration's endpoint URL from an external application. When triggered, the integration flow checks if the customer already exists based on the SourceSystemReferenceID field. If the customer exists, the recipe updates the customer record, or else it creates a new customer record and corresponding account, and customer profile based on the request payload data. The customer profile is created if the customerProfileType field exists in the payload.

Note:

  • If the account creation fails after the customer record has been created, you can use the same payload in the subsequent runs to update the customer record with the account details.
  • You can also create multiple accounts for a customer record. If a customer record has an account already associated with it, the incoming payload is checked. If the customerAccountName field in the payload is different from the existing account, a new account is created for the customer record.

System and Access Requirements

  • Oracle Integration, Version 21.2.1.0.0 or higher

  • Oracle ERP Cloud

  • An account on Oracle ERP Cloud with the Administrator role

Assumptions