JL_ENR Table Contains SYSDATE of the Point-Of-Service/Back Office Server Instead of the SYSDATE of the POS Register (Doc ID 2010895.1)

Last updated on NOVEMBER 17, 2015

Applies to:

Oracle Retail Point-of-Service - Version 13.3.3 and later
Information in this document applies to any platform.


Transaction is created in the JL_ENR table with the SYSDATE of the POS/BO Server instead of the SYSDATE of the POS Register.  This creates issues when searching for EJ as EJ has the date of the POS/BO Server and not of the actual transaction; this also causes mismatch on date between TR_TRN and JL_ENR for the same transaction.

Steps to reproduce:
1. Point-Of-Service/Back Office Server is installed in US-CST (United States - Central) time zone
2. POS register is installed in US-EST (United States - Eastern) time zone; this is an hour ahead of where POS/BO Server is installed
3. Create a transaction on POS Register
4. Check JL_ENR and transaction will have time of POS/BO Sever instead of POS register


Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms