My Oracle Support Banner

System Date Saved as a Business Date in JL_ENR after Cancelling Transaction by POS Client Shutdown (Doc ID 2257215.1)

Last updated on MARCH 16, 2019

Applies to:

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


In Oracle Retail Point-of-Service (ORPOS) version, 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

  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.




To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.