2 Before You Install the Recipe

You must perform the following configuration tasks on your Oracle ERP Cloud and Microsoft SQL Server instances in order to successfully connect to these external systems using Oracle Integration and import purchase 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 Microsoft SQL Server Database

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

In addition, log in to your Microsoft SQL Server Management Studio and add tables according to the following information. See Create Tables (Database Engine).

1. Create Customer table with the following columns.

   Column	Datatype
   BuyerId	varchar(255) Note: Select this variable as the Primary Key (PK) and Not Null (NN).
   PersonName	varchar(255)
   Gender	varchar(255)
   Email	varchar(255)
   WorkPhone	varchar(255)
   Address1	varchar(255)
   Address2	varchar(255)
   Building	varchar(255)
   City	varchar(255)
   Province	varchar(255)
   PostalCode	varchar(255)
   Country	varchar(255)

2. Similarly, create another table named PurchaseOrder, and add the following columns.

   Column	Datatype
   POHeaderId	varchar(255) Note: Select this variable as the Primary Key (PK) and Not Null (NN).
   OrderNumber	varchar(255)
   ProcurementBU	varchar(255)
   BuyerId	varchar(255)
   Buyer	varchar(255)
   Ordered	varchar(255)
   Supplier	varchar(255)
   SupplierId	varchar(255)
   Currency	varchar(255)
   DiscountAmount	varchar(255)
   TotalTax	varchar(255)
   Total	varchar(255)

3. Create another table named PurchaseOrderDetail, and add the following columns.

   Column	Datatype
   POHeaderId	varchar(255) Note: Select this variable as the Primary Key (PK) and Not Null (NN).
   OrderNumber	varchar(255)
   POLineId	varchar(255)
   LineNumber	varchar(255)
   LineType	varchar(255)
   Quantity	varchar(255)
   Item	varchar(255)
   SupplierId	varchar(255)
   ItemId	varchar(255)
   ItemDescription	varchar(255)
   Price	varchar(255)