Business Date in Tables TR_TRN and JL_ENR Differ If Server And Register arei in Different Timezones (Doc ID 1341782.1)

Last updated on MAY 02, 2016

Applies to:

Oracle Retail Point-of-Service - Version 13.0.0 and later
Information in this document applies to any platform.
***Checked for relevance on 04-APR-2013***

Symptoms

In Oracle Retail Point-Of-Service (ORPOS)  business date in tables 'TR_TRN' and 'JL_ENR' differ by a day if stores and registers are on different timezones.

Prerequisites:

1. Store must be on CST (Central Standard Time)
2. Register must be on EST (Eastern Standard Time)

Steps To Reproduce:

1. Ring sale Item.
2. Tender transaction with Cash.
3. Verify that business date is off by a day in tables 'TR_TRN' and 'JL_ENR'.

Cause

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