RETAIL_CTX_PKG Stores the Application User Context in Upper Case, Which May Conflict With Actual User Setup in ReSA Tables

(Doc ID 2055443.1)

Last updated on NOVEMBER 21, 2017

Applies to:

Oracle Retail Sales Audit - Version 14.1 and later
Information in this document applies to any platform.


RETAIL_CTX_PKG is performing an 'UPPER' operation when storing the application user in the session context.  This can cause problems if the user name in Retail Sales Audit (ReSA) tables contains lowercase characters.   The ODI user should match the user setup in all other places (i.e., if the user name in SA_USER contains lowercase characters, the OID user name needs to be the same or the dashboard will not work).

Steps to Reproduce:

  1. Create ReSA user containing lowercase letters (such as 'resa_su').
  2. Try to use "Assigned Store Day" filter.
  3. Note that the results do not show any data, as the context retrieved will be in CAPS (although user name is in lowercase letters).



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