System Date Saved as a Business Date in JL_ENR after Cancelling Transaction by POS Client Shutdown

(Doc ID 2257215.1)

Last updated on APRIL 21, 2017

Applies to:

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


In Oracle Retail Point-of-Service (ORPOS) version 14.1.2, System date saved as a business date in JL_ENR after cancelling transaction by ORPOS client shutdown.
When user starts a retail transaction on POS and then kills POS client process without finalizing the transaction, e-journal record related to this transaction is wrongly exported to the database after POS client restart.

DC_DY_BSN column in JL_ENR table contains system date instead of business date.


Steps to reproduce the issue:

  1. Turn on POS client;
  2. Log in to POS;
  3. Add an item to the transaction;
  4. Terminate POS client process;
  5. Turn on POS client again;
  6. Wait till the canceled transaction and its e-journal are exported;
  7. Check DC_DY_BSN column in JL_ENR table - entry related to canceled transaction have current system date instead of business date.


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