Thursday, January 28, 2016

verify user with role UMX|APPS Schema Connect

Set Up Necessary Oracle E-Business Suite Users
Set up a necessary Oracle E-Business Suite user with role UMX|APPS Schema Connect. Refer to Section 2.1.3 Set Up Necessary Oracle E-Business Suite Users in My Oracle Support Knowledge Document 974949.1, titled Oracle E-Business Suite Software Development Kit for Java Readme.
After setting up the user, logon locally to Oracle E-Business Suite as the user with role UMX|Apps Schema Connect.
http://.:/OA_HTML/AppsLocalLogin.jsp
If this user has just been created, you will be prompted on logon to Oracle E-Business Suite to reset the password. Reset the password.
Verify that you can successfully logon locally with the new password as the user with role UMX|Apps Schema Connect.

Solution:

SQL> desc wf_user_roles
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 USER_NAME                                 NOT NULL VARCHAR2(320)
 ROLE_NAME                                 NOT NULL VARCHAR2(320)
 USER_ORIG_SYSTEM                                   VARCHAR2(30)
 USER_ORIG_SYSTEM_ID                                NUMBER
 ROLE_ORIG_SYSTEM                                   VARCHAR2(30)
 ROLE_ORIG_SYSTEM_ID                                NUMBER
 START_DATE                                         DATE
 EXPIRATION_DATE                                    DATE
 ASSIGNMENT_TYPE                                    VARCHAR2(1)
 PARENT_ORIG_SYSTEM                                 VARCHAR2(30)
 PARENT_ORIG_SYSTEM_ID                              NUMBER
 PARTITION_ID                                       NUMBER
 ASSIGNMENT_REASON                                  VARCHAR2(4000)

SQL> select USER_NAME,ROLE_NAME from wf_user_roles where USER_NAME='EBSADMIN';

USER_NAME
--------------------------------------------------------------------------------
ROLE_NAME
--------------------------------------------------------------------------------
EBSADMIN
EBSADMIN

EBSADMIN
FND_RESP0:20419

EBSADMIN
FND_RESP1:20420


USER_NAME
--------------------------------------------------------------------------------
ROLE_NAME
--------------------------------------------------------------------------------
EBSADMIN
FND_RESP|FND|APPLICATION_DEVELOPER|STANDARD

EBSADMIN
FND_RESP|FND|APPLICATION_DIAGNOSTICS|STANDARD

EBSADMIN
FND_RESP|SYSADMIN|SYSTEM_ADMINISTRATOR|STANDARD


USER_NAME
--------------------------------------------------------------------------------
ROLE_NAME
--------------------------------------------------------------------------------
EBSADMIN
UMX|APPS_SCHEMA_CONNECT

EBSADMIN
UMX|ODF_DIAGNOSTICS_SUPER_USER_ROLE


If the 'Apps Schema Connect Role' role is not present in the wf_user_roles for the ASADMIN user, then run the 'Workflow Directory Services User/Role Validation' concurrent program to grant the role.