My Oracle Support Banner

Demantra Does Not Allow Users Accounts With A Dash (Doc ID 759105.1)

Last updated on FEBRUARY 18, 2019

Applies to:

Oracle Demantra Demand Management - Version 7.1.1 and later
Information in this document applies to any platform.
This problem can occur on any platform.


Our Single Sign On instance integrated with Demantra 7.1.1 contains Oracle user accounts
containing a '-' (dash) creates issues with the Demantra applications

The process for creating Demantra users in a SSO instance is to assign either the Demand Analyst
or Demand Management Systems Administrator responsibility to the user and a seeded api
(DEMANTRA.API_CREATE_ORA_DEM_USER) creates the Demantra user.
It creates the user with the '-' in the demantra.user_id table and the user works with the SSO

In Demantra the '-' cannot be used in a user account, causes an error if the user is opened in
User maintenance screen and users with a '-' do not show up in the list of users to assign tasks

All elements of the Demantra application should allow the same characters as the master EBS SSO

The issue can be reproduced at will with the following steps:
1. In a SSO/Demantra integrated instance create an Oracle username containing a '-'.
2. Assign either the Demand Analyst or the Demand Management System Administrator responsibility.
3. A user will be created by the seeded API in Demantra.
4. Go into Demantra Business Modeler --> Add/Edit User and try to modify AND save changes to
the user with the '-'. It won't allow you to save the user or go into the Send Task
functionality (in the Demantra CW) and the user with the dash doesn't appear as a choice

The issue has the following business impact:
Due to this issue, users cannot modify a user created through EBS SSO.


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.