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_ERP_FB_StatusMap

This lookup table contains the values of the Status field responses that need to be passed to Oracle SCM to Oracle MICROS IM Master Data Sync integration. The following table provides the description for each parameter:

Parameter	Description
ERPItemStatus	This field indicates the item status field value of SCM: whether the item is active or inactive. Do not modify this value unless SCM configuration is changed.
FnBItemStatus	This field indicates the corresponding status value to be passed to Oracle MICROS Inventory Management item creation request. Do not modify this value unless Inventory Management configuration is changed.

Parameter

Description

ERPItemStatus

This field indicates the item status field value of SCM: whether the item is active or inactive.

Do not modify this value unless SCM configuration is changed.

FnBItemStatus

This field indicates the corresponding status value to be passed to Oracle MICROS Inventory Management item creation request.

Do not modify this value unless Inventory Management configuration is changed.

Oracle-BRT-Micros_MasterData

This lookup table contains the information required to be sent as the SOAP header while making an API call to the Inventory Management web service. The following table provides the description for each parameter:

Parameter	Description
soapUser	This field contains the user name to authenticate against the Inventory Management web service.
soapPassword	This field contains the password to authenticate against the Inventory Management web service.
soapDomain	This field contains the enterprise short name (for example, ABC).

Oracle-BRT-Micros_ERP_FB_ItemDetailsMap

This lookup table contains the item mappings used in Oracle SCM to Oracle MICROS IM Item Sync integration.

Name	Description
CategoryName	Indicates the category name for an item in SCM. This will then be used to determine the respective ItemGroupNumber to be sent in the IM item creation request payload. Add all categories configured in SCM that are used with IM.
ItemGroupNumber	Indicates the IM item group number mapping against the respective SCM category name. The IM API also offers a web service call to import item groups.
CountInterval	This field contains the Count Interval to be used for the item creation request payload to Inventory Management against a specific CategoryName. Modify this value based on your requirement. Example: D = Daily, requires an Inventory Template called “Daily” with 1 at the INVTEMPLATE.FKEY Database column W = Weekly, requires an Inventory Template called “Weekly” with 2 at the INVTEMPLATE.FKEY Database column M = Monthly, requires an Inventory Template called “Monthly” with 3 at the INVTEMPLATE.FKEY Database column D = Yearly, requires an Inventory Template called “Yearly” with 4 at the INVTEMPLATE.FKEY Database column OnDemand, requires an Inventory Template called “OnDemand” with 5 at the INVTEMPLATE.FKEY Database column Never, must be defined as “Ignore Item in Inventory” at Master Data \| Items
ERPUOMCode	Indicates the Unit Of Measure (UOM) code for an item in SCM. This will then be used to determine the respective FnBBaseOrdqntyUnit to be sent in the IM item creation request payload. Add all UOM configured in the SCM that need to be processed for items.
FnBBaseOrdqntyUnit	Indicates the Inventory Management Unit Number against the respective SCM Unit Of Measure. Add all Unit Numbers configured in Inventory Management that need to be mapped against SCM for items. Note: The FnBBaseOrdqntyUnit relates to the ERPUOM column, but is independent from the Category Name/ItemGroupNumber/CountInterval (it is not related to it). In case of Metric Units: 1 indicates Kilogram 2 indicates Liter 3 indicates Each In case of Imperial Units: 1 indicates Pound 2 indicates Pint 3 indicates Each

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:

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

Parent topic: Install and Configure the Recipe