How to change User Name or Login name of Oracle EBS users

How to change User Name or Login name of Oracle EBS users

If you want to implement Single Sign On (SSO) Or you need to standardize username to match oracle username with Active Directory usernames, oracle provided a simple API to accomplish this task. However it works fine when done from ERP Application front end but to update all the user names is a tedious job or we can use some tools like data loader to change the usernames from the front end.

Using APPS.FND_USER_PKG API to change the username as well as update the related WF tables.

1. Collect the list of users

Identify the active users from fnd_user excluding seeded users.

SQL> SELECT user_name
FROM fnd_user
WHERE end_date IS NOT NULL
AND user_name NOT IN
('SYSADMIN',
'AUTOINSTALL',
'GUEST',
'IEXADMIN',
'OP_SYSADMIN',
'ASGUEST',
'IRC_EXT_GUEST',
'IRC_EMP_GUEST',
'PORTAL30',
'PORTAL30_SSO',
'XML_USER');

2. Modify the user name

Execute the below procedure to change the user name.

SQL> BEGIN
fnd_user_pkg.change_user_name (x_old_user_name => 'OLDUSERNAME',
x_new_user_name => 'NEWUSERNAME'
);

COMMIT;
END;
/

3. Update WF_NOTIFICATIONS.receipient_role with new user names.

After changing the username, users cannot find their old notifications in the worklist.

Execute the below procedure to update the user name.

SQL> exec WF_MAINTENANCE.PropagateChangedName('OLDUSERNAME','NEWUSERNAME');

(4) Execute the following query to find out if the usernames in WF_NOTIFICATIONS were changed

SQL> select notification_id, begin_date, end_date, mail_status, status,recipient_role
from wf_notifications
where recipient_role in ('OLDUSERNAME');

Above query should not supposed to return any rows for old user names.

5. Verify the change

SQL> select user_name, end_date from fnd_user where user_name='NEWUSERNAME';
USER_NAME |END_DATE
------------------|---------
NEWUSERNAME |

SQL> select user_name, role_name from wf_local_user_roles where user_name='NEWUSERNAME';
USER_NAME |ROLE_NAME
-----------------------|-------------------------------------
NEWUSERNAME |FND_RESP|SQLGL|MS_GL|STANDARD
NEWUSERNAME |FND_RESP|SYSADMIN|SYSTECH|STANDARD
NEWUSERNAME |FND_RESP|SYSADMIN|SYSTEM_ADMINISTRATOR|STANDARD

The new user name is being accepted at login. Checked few old transactions created by the user for verification.

How to Allow in R12 to Open Multiple Forms in the Same Session

How to open multiple forms with the same responsibility in the same session for Release 12.

Under 'Tools' menu, uncheck the Close Other Forms option to allow multiple Forms windows in one Forms session. Navigate to Tools->Close Other Forms.

Upgrade and Migrate to Oracle Database 12c - and Consolidate with Oracle Multitenant - Featuring Mike Dietrich

Event Registration (EVENT: 750382 - SESSION: 1)

ORACLE-BASE - Online Move Datafile in Oracle Database 12c Release 1 (12.1)

ORACLE-BASE - Online Move Datafile in Oracle Database 12c Release 1 (12.1)

Context Value Management Failed

Context Value Management Failed

Issue: Incorrect Custom top defied using OAM Manage Custom Parameters

Auto config throws the following error:
File system template : /u01/oracle/PROD/apps/apps_st/appl/ad/12.0.0/admin/template/adxmlctx.tmp
Checking for customizations to Context template
Customizations found : Yes
Action to be taken : Customizations to be appended to the template

StackTrace:
oracle.xml.parser.v2.XMLDOMException: invalid character " in name
at oracle.xml.util.XMLUtil.validateName(XMLUtil.java:447)
at oracle.xml.parser.v2.XMLDocument.createElement(XMLDocument.java:706)
at oracle.apps.ad.context.AppsContext.addTmplCust(AppsContext.java:1012)
at oracle.apps.ad.tools.configuration.FileSysDBCtxMerge.updTmplwithDBup(FileSysDBCtxMerge.java:328)
at oracle.apps.ad.tools.configuration.FileSysDBCtxMerge.updateFileSysTemplate(FileSysDBCtxMerge.java:270)
at oracle.apps.ad.tools.configuration.FileSysDBCtxMerge.updateFileSysFiles(FileSysDBCtxMerge.java:209)
at oracle.apps.ad.context.CtxValueMgt.mergeCustomInFiles(CtxValueMgt.java:1790)
at oracle.apps.ad.context.CtxValueMgt.processCtxFile(CtxValueMgt.java:1608)
at oracle.apps.ad.context.CtxValueMgt.main(CtxValueMgt.java:763)

ERROR: Context Value Management Failed.
Terminate.

Solution:
Backup FND_OAM_CONTEXT_CUSTOM and FND_OAM_CONTEXT_FILES tables

create table FND_OAM_CONTEXT_CUSTOM_bak as select * from FND_OAM_CONTEXT_CUSTOM


create table FND_OAM_CONTEXT_FILES_bak as select * from FND_OAM_CONTEXT_FILES

truncate table applsys.FND_OAM_CONTEXT_CUSTOM

truncate table applsys.FND_OAM_CONTEXT_FILES

Run autoconfig on the db tier.

Run autoconfig on the apps tier

Retest

Fusion Middleware Administrator's Guide - Contents

Fusion Middleware Administrator's Guide - Contents

Fusion Middleware Administering the Application Adapters for Oracle WebCenter - Contents

Fusion Middleware Administering the Application Adapters for Oracle WebCenter - Contents