3 Install and Configure the Recipe

On your Oracle Integration instance, install the recipe package to deploy and configure the integrations and associated resources.

1. On the Oracle Integration Home page, in the Pick a Recipe/Accelerator section, click View All.

2. Find the recipe package that you want to install.

3. Hover over the recipe, then click Install .

   A message confirms that the recipe was successfully installed, and the recipe card shows INSTALLED.

4. Hover over the recipe again and click Configure  to configure the resources of the recipe.

   The Configuration Editor page opens, displaying all the resources of the recipe package. Configure the following resources before you activate and run the recipe.

• Configure the Oracle MICROS FTP Connection
  
• Configure the Oracle ERP Cloud Connection MICROS
  
• Configure the Oracle REST OIC API Connection
  
• Configure the Lookup Tables
  

Configure the Oracle MICROS FTP Connection

1. In the Configuration Editor, under Connections, hover over the connection, and then click Edit .

2. In the Properties section, enter the following details:

   Field	Information to Enter
   FTP Server Host Address	Enter FTP Server Hostname
   FTP Server Port SFTP Connection	Enter FTP Server Port Number Select “YES” from the drop-down list

3. In the Security section, enter the following details:

   Field	Information to Enter
   Security Policy	Select FTP Server Access Policy
   User Name	Enter the user name for the FTP Server
   Password	Enter the password for the FTP Server username

4. Click Save. If prompted, click Save again.

5. Click Test to test the connection. A confirmation message appears if your test is successful.

6. To return to the Configuration Editor, click Go back .

Configure the Oracle ERP Cloud Connection MICROS

1. In the Configuration Editor, under Connections, hover over the connection, and then click Edit .

2. In the Properties section, enter the Oracle Fusion Cloud SCM host name. For example: https://your_domain_name.fa.DC.oraclecloud.com.

3. In the Security section, enter the following details:

   Field	Information to Enter
   Security Policy	Select Username Password Token.
   Username	Enter the username of the account created for Oracle Integration on Oracle Fusion Cloud SCM. See Configure Oracle Fusion Cloud SCM.
   Password	Enter the password of the account created for Oracle Integration on Oracle Fusion Cloud SCM.

4. Click Save. If prompted, click Save again.

5. Click Test to test the connection. A confirmation message appears if your test is successful.

6. To return to the Configuration Editor, click Go back .

Configure the Oracle REST OIC API Connection

1. In the Configuration Editor, under Connections, hover over the connection, and then click Edit .

2. In the Properties section, enter the following details:

   Field	Information to Enter
   Connection Type	Leave REST API Base URL selected.
   Connection URL	Enter the host name of the Oracle Integration instance in which you’ve installed the recipe.

3. In the Security section, enter the following details:

   Field	Information to Enter
   Security Policy	Select Basic Authentication.
   Username	Enter the user name of the Oracle Integration user account with the Service Invoker role. See System and Access Requirements.
   Password	Enter the password of the Oracle Integration user account with the Service Invoker role.

4. Click Save. If prompted, click Save again.

5. Click Test to test the connection. A confirmation message appears if your test is successful.

6. To return to the Configuration Editor, click Go back .

Configure the Lookup Tables

In the Configuration Editor, click Lookups to view the lookup tables in the recipe. Hover over the lookup table to edit, then click Edit .

This recipe package contains the following lookup tables.

ORACLE-BRT-Micros_FnB_ERPmap

This lookup table contains the information needed to create Requisition Header interface files and Purchase Order Line Requisition interface files to be imported to Fusion Procurement Cloud for creating requisitions. Update the details according to your implementation.

The following table provides the description for each parameter:

Name	Description
RequisitioningBU	The value of the Requisition Business Unit used in the requisition creation as configured in SCM. Example value: US Business Unit Note: Only one BU is considered in the design.
Approver	The email address of the purchase requisition approver user as configured in SCM Procurement. Note: Only one Approver is considered in the design.
EnteredBy	The email address of the purchase order requisition creation user as configured in SCM Procurement. Note: Only one user is considered in the design.
ProcurementBU	The business unit for which the procurement is done in SCM Procurement. Example value: US1 Business Unit Note: Only one procurement BU is considered in the design.
StatusCode	The status code of Purchase Requisitions being Imported. Example value: APPROVED Note: DO NOT modify this value
RequisitionErrorNotificationEmail	The email address to receive notifications on requisition import errors

ORACLE-BRT-Micros_OrderToReq

This lookup table contains the information related to the FTP Server folder and file structure. The following table provides the description for each parameter:

Name	Description
readDir	The directory folder path where the Order files from IM are uploaded to
filePattern	Prefix for Purchase Order file names exported from IM
ERPReqImportZipFilePattern ordConfirmationFnBFilePattern ordConfirmationFnBFolder	Zip File name for ERP requisition import Prefix for Purchase Order Acknowledgement file to be exported to IM by OIC The directory folder path where the Order Acknowledgement files from SCM are uploaded to

ORACLE-BRT-Micros_ERP_SupplierDetails

This lookup table contains the supplier/vendor information to send in the order acknowledgement file to IM.

Name	Description
Name	Supplier Name from SCM which is mapped to the ERP_VendorID field Note: Enter configuration for each supplier
ERP_VendorID	Vendor ID from IM which can be found at: Master Data | Vendors | Select Vendor | B2B General

ORACLE-BRT-Micros_ERP_FB_LocationsMap

This lookup table contains the information that’s used for creating the purchase order requisition Line Interface file to further import files to SCM Procurement to create the order requisition.

Name	Description
FNBLocationID	“Delivery Location ID” send by the IM B2B Order export. Used to cross reference the corresponding ERPLocationName during the Purchase Requisition Import Note: This is the Customer Number which must be configured at IM | Maintenance | Vendor Cost Center Profile | Customer Number
ERPLocationName	The “Deliver-To-Location” name in SCM corresponding to FNBLocationID to be used in Purchase Requisition
ERPLocationOrganization	The “Deliver-To-Organization” name of SCM corresponding to FNBLocationID to be used in Purchase Requisition
ERPRequester_FBResMgr	The “Requester” email corresponding to FNBLocationID to be used in Purchase Requisition, that is the SCM email address of the IM store manager

ORACLE-BRT-Micros_ERP_FB_UnitMap

This lookup table contains the UNIT Cross reference information that’s used while creating the purchase requisition line interface file, to be imported to SCM Procurement.

Name	Description
ERPUOMCode	The UOM Codes of SCM to be used in Purchase Requisition
FnB_OrderUnit	The Order Unit Quantity of IM corresponding to the ERPUOMCode used in Purchase Requisition

Note:

The mapping table is only required for this sample implementation, it is not required if the Oracle Fusion Cloud SCM — Oracle MICROS Inventory Management | Master Data Synchronization recipe has expanded to include synchronizing Units of Measure between the two systems.

An unique number must be manually set at every IM Unit of Measure within the VPCKEINH table / FKEY column, if the integration does not include the automatic creation of Units of Measure. This FKEY number must then be used at FnB_OrderUnit.

ORACLE-BRT-Micros_ErrorNotification_Config

This lookup table contains the information needed to trigger the error handlers. The following table provides the description for each parameter:

Name	Description
OIC	The Oracle Integration Admin email address that must be notified on failures.
ERP	The ERP Admin email address that must be notified on failures.
Micros	The MICROS Admin email address that must be notified on failures.