My Oracle Support Banner

Null or Wrong Values are Stored in ID_OPR and ID_EM Columns of JL_ENR Table (Doc ID 2583569.1)

Last updated on SEPTEMBER 04, 2019

Applies to:

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

Symptoms

On Oracle Retail Point of Service (ORPOS) database, Null or wrong values are stored in the ID_OPR and ID_EM columns of JL_ENR table in the below two cases.


Steps to reproduce:
Case 1:
1. Go to Admin menu
2. Login with Cashier User, Application prompts for manager override
3. Override with the Admin User.
4. Application shows the Admin Option Screen, Press Esc and comes back to Main Screen.
5. Connect to store database and check the Electronic Journal (EJ) for this activity.
6. Null values are stored in both ID_OPR and ID_EM columns of JL_ENR table

Case 2:
1. Go to POS menu with Cashier User-1 and go to sale screen.
2. Press Esc and comes back to Main Screen.
3. Go to Admin menu
4. Login with Cashier User-2, Application ask for manager override
5. Override with the Admin User.
6. Application shows the Admin Option Screen, Press Esc and comes back to Main Screen.
7. Connect to store database and check the EJ of this activity.
8. Login ID of Cashier User-1 (instead of Cashier User-2) are stored in ID_OPR and ID_EM columns of JL_ENR table

Cause

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
Symptoms
Cause
Solution
References


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