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