[BIP] "xdo_user_name" Value Changed to Case Sensitive (Doc ID 2259707.1)

Last updated on MAY 01, 2017

Applies to:

BI Publisher (formerly XML Publisher) - Version 11.1.1.9.0 to 12c [Release 11.1 to 12.0]
Information in this document applies to any platform.

Symptoms

One uses "xdo_user_name" in List of Value SQL statement when creates the data model in BI Publisher 11.1.1.9 or 12c. The value of "xdo_user_name" changed to case sensitive that is different with BI Publisher 11.1.1.7.

ACTUAL BEHAVIOUR
---------------

xdo_user_name returns the value which the user used to login BI Publisher.

For example:

The user login BI Publisher with James_Smith, the value returns James_Smith.


EXPECTED BEHAVIOUR
-----------------------

xdo_user_name returns the value always in lower case.

For Example:

The user login BI Publisher with James_Smith, the value returns james_smith.

 

Changes

 Upgrade from 11.1.1.7 to 11.1.1.9 or 12c

Cause

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