Configure the Lookup Tables

Edit the lookup tables and enter the necessary values. On the Configuration Editor page, select a lookup table, and 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:

Parameter	Description
RequisitioningBU	The value of the Requisition Business Unit used in the requisition creation as configured in SCM. Example value: US Business Unit Only one BU is considered in the design.
Approver	The email address of the purchase requisition approver user as configured in SCM Procurement. Only one Approver is considered in the design.
EnteredBy	The email address of the purchase order requisition creation user as configured in SCM Procurement. 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 Only one procurement BU is considered in the design.
StatusCode	The status code of Purchase Requisitions being Imported. Example value: APPROVED 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:

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

ORACLE-BRT-Micros_ERP_SupplierDetails

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

Parameter	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 used to create 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 sent by the IM B2B Order export. Used to cross reference the corresponding ERPLocationName during the Purchase Requisition Import. This is the Customer Number that 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 is 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.

A 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.