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

Last updated on MARCH 28, 2016

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.

Symptoms

Our 11.5.10.2 Single Sign On instance integrated with Demantra 7.1.1 contains Oracle user accounts
containing a '-' (dash) creates issues with teh 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
Oracle/Demantra.


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

EXPECTED BEHAVIOR
All elements of the Demantra application should allow the same characters as the master EBS SSO
system.

STEPS
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

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

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