6966581 Demantra Does Not Allow Users Accounts With A Dash
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.
Our 18.104.22.168 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
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms