Creating User in Oracle Retail Price Management

Creating User in Oracle Retail Price Management - RPM

Step 1

Create a same user as RETAIL.USER in LDAP directory:

http://servername:7005/odsm/faces/odsm.jspx

userid:- orcladmin

passwd:- Retail

Note- Above put your credentials for LDAP super user orcladmin

 

Go to dc=com, dc=oracle, cn=users

Step2

Create like a new user by right click on RETAIL.USER

I am creating a user "rpmuser1" similar like Retail.User

Step 3

Insert a new record with the newly created user:

insert into rsm_user_role (id, user_id, role_id, start_date_time, end_date_time) select rsm_user_role_seq.nextval, 'rpmuser1', -1001, nvl(get_vdate,sysdate) - 365, null from dual;

Done.....