My Oracle Support Banner

OAC: Prompt List Of Values Do Not Show Entries With Trailing Space At The End (Doc ID 2974402.1)

Last updated on NOVEMBER 03, 2023

Applies to:

Oracle Analytics Cloud - Version N/A and later
Information in this document applies to any platform.

Symptoms

Whenever there are two similar values in the database for any column, one without trailing space at the end and one with trailing space at the end. The prompt list of values show only one value ie. the one without the trailing space at the end.

For example: There are two values in the Database for one column ie. 'System Solution Architect' and ‘System Solution Architect ‘. Upon using this column and creating a prompt, observe that only one value is seen in the prompt list of values ie. 'System Solution Architect' (without the trailing space at end)

Steps to reproduce the issue

Changes

NA

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
Changes
Cause
Solution


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