My Oracle Support Banner

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 DECEMBER 04, 2019

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).





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.