Installation and Upgrade > Windchill ESI > Installing and Configuring Windchill ESI in an ORACLE Applications Environment > Using the Middleware Installation and Configuration Utility > Using the Middleware Installation and Configuration Utility (MICU) > Performing Post Installation Steps > Updating the ESIORALookups.properties file for Oracle Applications
  
Updating the ESIORALookups.properties file for Oracle Applications
The ESIORALookups.properties file resides in the <<TIBCO HOME>>/esi/bin directory. If the existing file is customized ensure that you duplicate these customizations in the installed file from the original (backed up) file. By default the following line is commented
:
#Part.Effectivity_Control.*.* = Unit
If you want to publish a Unit Effective Part, or a BOM with components that have either serial or lot number effectivity values, uncomment the line shown above and comment the following line:
Part.Effectivity_Control.*.* = Date
By default the following property in the file has a value of HJ0051:
ECO.ReviseItem.Part.FromEndItemUnitNo = HJ0051
This value can be changed to any unit number defined in the ERP system. This value can be obtained from the Oracle Applications system and is used to satisfy certain CN revise item requirements. There is no effect on Windchill business object mapping.
Depending on whether or not serial or lot number effectivity values sent from Windchill are to be published by TIBCO to Oracle Applications you must comment or uncomment the following lines:
Unit.Effectivity.Priority.* = SERL
#Unit.Effectivity.Priority.* = LOT
* 
Serial or lot number effectivity is published to Oracle Applications as unit effectivity. The above property is set to SERL by default, meaning the business logic would publish serial effectivity to Oracle Applications by default.