2 Before You Install the Recipe

You must perform the following configuration tasks on your Oracle ERP Cloud and MySQL instances in order to successfully connect to these external systems using Oracle Integration and import sales order details.

Configure Oracle ERP Cloud

To access the Oracle ERP Cloud instance from Oracle Integration, you’ll require a separate user account on Oracle ERP Cloud.

Log in to your Oracle ERP Cloud instance as an Administrator and perform the following tasks.

1. Create a user account for Oracle Integration. Make a note of the user name and password you set for the account. You’ll use the credentials of this user account to connect to Oracle ERP Cloud from Oracle Integration.
2. Assign the following roles to the user account. For more information on these roles, see Assign Required Roles to an Integration User.
   • Integration Specialist
   • Oracle ERP Cloud-specific data access to the integration user

Configure the MySQL Database

To access the MySQL database from Oracle Integration and import order details, you must perform certain configurations on your MySQL instance. See Prerequisites for Creating a Connection.

In addition, create a database schema and add tables according to the following information:

1. Log in to your MySQL Workbench instance as an Administrator.
2. Click File and select Create Schema.
3. Specify the name of the schema as oic_schema and click Apply.
4. In the Apply SQL Script to Database window, click Apply to run the SQL command.
5. Click Finish. You can view the new schema with no tables on the left pane.
6. Expand oic_schema on the left pane. Right-click Tables, and select Create Table….
7. Specify the name of the table as erp_salesorder.
8. Double-click the empty table to add the following columns.

   Column	Datatype
   ERP_ORDER_NUMBER	VARCHAR(40) Note: Select this variable as the Primary Key (PK) and Not Null (NN).
   CreationDate	DATETIME
   Contact_FirstName	VARCHAR(40)
   Contact_LastName	VARCHAR(40)
   OrderTotal	VARCHAR(40)
   CustomerName	VARCHAR(40)
   CustomerId	VARCHAR(40)
   CurrencyCode	VARCHAR(40)

9. Similarly, create another table named erp_salesorder_lines, and add the following columns.

   Column	Datatype
   ERP_ORDER_NUMBER	VARCHAR(40) Note: Select this variable as the Primary Key (PK) and Not Null (NN).
   ProductQty	VARCHAR(45) Note: Select this variable as the Primary Key (PK) and Not Null (NN).
   ProductName	VARCHAR(45) Note: Select this variable as the Primary Key (PK) and Not Null (NN).
   ProductDescription	VARCHAR(100) Note: Select this variable as the Primary Key (PK) and Not Null (NN).

10. Click Apply.