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

End Date all users in EBS 11i after cloning

End Date all users in EBS 11i after cloning

select count(*) from fnd_user;

create table fnd_user_bkp as select * from fnd_user;


DECLARE
CURSOR cur1
IS
SELECT user_name
FROM fnd_user
WHERE user_name NOT IN ('SYSADMIN', 'GUEST')
AND (end_date IS NULL OR TRUNC(end_date) > TRUNC (SYSDATE));
BEGIN
FOR all_user IN cur1
LOOP
fnd_user_pkg.updateuser (x_user_name => all_user.user_name,
x_owner => 'SYSADMIN',
x_end_date => SYSDATE
);
COMMIT;
END LOOP;
END;


How to End-Date/Delete an Applications User (Doc ID 1064798.1)