EBS 11.5.10 With Demantra 7.1.1 User Data Is Not Being Written To User_id Table ORA-06550 DEMANTRA.API_CREATE_ORA_DEM_USER (Doc ID 455838.1)

Last updated on SEPTEMBER 09, 2014

Applies to:

Oracle Demantra Demand Management - Version 7.1.1 and later
Information in this document applies to any platform.
***Checked for relevance on 15-May-2012***


Symptoms

On 7.1.1 Demantra with 11.5.10 EBS Integration in Test:
Users have installed Demantra 7.1.1 and have applied the EBS Demantra Integration Patch 5997112
and all pre-requisite patches from the readme including ATP RUP#3 patch 4334965.  However when they assign either of the Demantra Responsibilities (Demand Management System Administrator, Demand Planner) to an EBS user in System Administrator responsibility, the user_id and password are not getting generated in the Demantra Table called user_id.

Because of this, users cannot make the jump from EBS to Demantra. They get to the Demantra login
window, but their user_id/password do not work. Reviewing user_id and passwords in the user_id
table shows these users are not created in this table. Logging in directly to Demantra applications (without jumping to EBS) works for the users setup directly through the Business Modeler.

The message they get when trying to make the jump from EBS to Demantra is:
Invalid Username or Password - Please try again...

The API that is supposed to be called when assigning users the Demantra responsibilities is DEMANTRA.API_CREATE_ORA_DEM_USER.  An example of what this might look like for a particular user when invoked is as follows :

BEGIN DEMANTRA.API_CREATE_ORA_DEM_USER ( 'mictay' , null, 'DPA' , 'Michael' , 'Taylor' , 'Widgets Product Line' , '' , '' , 'generic@xxx.oracle.net' , '0' , null, 'Demand Management' , null, 'ADD'); END;

But if this is run manually in this case it errors out with the following:

ERROR at line 1:
ORA-06550: line 1, column 16:
PLS-00904: insufficient privilege to access object
DEMANTRA.API_CREATE_ORA_DEM_USER
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored


EXPECTED BEHAVIOR
Expect users to be able to make the jump between EBS and Demantra when the appropriate Demantra
responsibilities are assigned to an EBS user and the appropriate userid/pwd will get created in table user_id

STEPS
The issue can be reproduced at will with the following steps:
1. Install Demantra 7.1.1
2. Apply EBS Demantra patch 5997112 and any pre-requisites
3. Assign EBS Users the Demantra Responsibilities in System Administrator responsibility in EBS
4. Try to make the jump from EBS to Demantra with the new responsibilities defined
5. Userid/password window opens for Demantra

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