Removing Language Selection From Login Page

1.Logon with Functional Administrator responsibility.

2.Click on 'Personalization' Tab.

3.Enter /oracle/apps/fnd/sso/login/webui in document path and click on 'Go' button.

4.Click on 'Pencil' icon under 'Personalize Page' for /oracle/apps/fnd/sso/login/webui/LangImagesRN.

5.make sure that 'Include' for Site is checked then click on 'apply'.

6.Look for “Table Layout‟ and click on 'Pencil' icon in ‟Personalize' column.

7.Change 'rendered' property value to 'false' at Site level from LOV and click on Apply.

How to display all oracle hidden parameters

Oracle has many hidden parameters.
You will not find them in V$PARAMETER or see them with SHOW PARAMETERS command as these are hidden.
All these parameter start with _ (Underscore).

SELECT NAME, VALUE, DECODE (isdefault, 'TRUE', 'Y', 'N') AS "Default",
DECODE (isem, 'TRUE', 'Y', 'N') AS sesmod,
DECODE (isym,'IMMEDIATE', 'I','DEFERRED', 'D','FALSE', 'N') AS sysmod,
DECODE (imod,'MODIFIED', 'U','SYS_MODIFIED', 'S','N') AS modified,
DECODE (iadj, 'TRUE', 'Y', 'N') AS adjusted,
description
FROM ( --GV$SYSTEM_PARAMETER
SELECT x.inst_id AS INSTANCE, x.indx + 1, ksppinm AS NAME, ksppity,
ksppstvl AS VALUE, ksppstdf AS isdefault,
DECODE (BITAND (ksppiflg / 256, 1),1, 'TRUE','FALSE') AS isem,
DECODE (BITAND (ksppiflg / 65536, 3),1, 'IMMEDIATE',2, 'DEFERRED','FALSE') AS isym,
DECODE (BITAND (ksppstvf, 7),1, 'MODIFIED','FALSE') AS imod,
DECODE (BITAND (ksppstvf, 2), 2, 'TRUE', 'FALSE') AS iadj,
ksppdesc AS description
FROM x$ksppi x, x$ksppsv y
WHERE x.indx = y.indx
AND SUBSTR (ksppinm, 1, 1) = '_'
AND x.inst_id = USERENV ('Instance'))
ORDER BY NAME;

How to apply a new patch when adpatch is already running

Reference: Metalink Note: 175485.1

Using the adctrl utility, shutdown the workers.
a. adctrl
b. Select option 3 “Tell worker to shutdown/quit”

c. Backup tables
sqlplus applsys/
create table FND_INSTALL_PROCESSES_3480000as select * from FND_INSTALL_PROCESSES;
create table AD_DEFERRED_JOBS_3480000as select * from AD_DEFERRED_JOBS;

drop table FND_INSTALL_PROCESSES;
drop table AD_DEFERRED_JOBS;

d.From OS:
cd $APPL_TOP/admin/
mv restart restart_
mkdir restart

e.Apply the new patch.
Once patch completed.
cd $APPL_TOP/admin/
mv restart_ restart.

f.recreate the tables
sqlplus applsys/
create table FND_INSTALL_PROCESSESas select * from FND_INSTALL_PROCESSES_3480000;
create table AD_DEFERRED_JOBSas select * from AD_DEFERRED_JOBS_3480000;
create synonym AD_DEFERRED_JOBS for APPLSYS.AD_DEFERRED_JOBS;
create synonym FND_INSTALL_PROCESSES FOR APPLSYS.FND_INSTALL_PROCESSES;

Now Restart adpatch, it will resume where it stopped previously