Update current view snapshot hangs

Update current view snapshot hangs while inserting the records into AD_PATCH_HIST_TEMP table.
Issue resolved by gathering the statistics on some of the AD_ tables.
exec fnd_stats.gather_table_stats('APPLSYS','AD_SNAPSHOT_FILES');exec fnd_stats.gather_table_stats('APPLSYS','AD_SNAPSHOT_BUGFIXES');exec fnd_stats.gather_table_stats('APPLSYS','AD_SNAPSHOTS');exec fnd_stats.gather_table_stats('APPLSYS','AD_FILE_VERSIONS');exec fnd_stats.gather_table_stats('APPLSYS','AD_CHECK_FILE_TEMP');exec fnd_stats.gather_table_stats('APPLSYS','AD_PATCH_HIST_TEMP');exec fnd_stats.gather_table_stats('APPLSYS','AD_SNAPSHOT_FILES_TEMP');exec fnd_stats.gather_table_stats('APPLSYS','AD_FILES');

Finding the concurrent request filling up APPLPTMP

My friend pinged me and told that there is a .tmp file in the APPLPTMP which is rapidly growing and filling up the mount point. Below is the query we used to find the culprit.

SELECT a.request_id FROM apps.fnd_concurrent_requests a, apps.fnd_concurrent_processes b WHERE a.controlling_manager = b.concurrent_process_id and b.plsql_out='o0155932.tmp';

The webpage you are viewing is trying to close the window. Do you want to close this window?

On one of our 11.5.10.2 instance, users started receiving the message "The webpage you are viewing is trying to close the window. Do you want to close this window?" whenever the user session is timeout. Once the user relogin, it will again taking him back to login screen. The user has to close all his work and relogin everytime.

Solution : This is the settings issue in the Java Plug-in. Goto

Control Panel -> Java -> Advanced -> Java Plug-in -> Uncheck "Enable the next-generation Java Plug-in". And restart the browser

APP-FND-01516 : Invalid application username,password or database

Yesterday on one of the 11.5.10.2 instance users started receiving APP-FND-01516 : Invalid application username,password or database.

Issue : Application file system was 100% full and some cleanup helped us to get back on track

Finding ATG RUP Level

SELECT bug_number,
last_update_date,
Decode (bug_number, 2728236, 'OWF.G INCLUDED IN 11.5.9',
3031977, 'POST OWF.G ROLLUP 1 - 11.5.9.1',
3061871, 'POST OWF.G ROLLUP 2 - 11.5.9.2',
3124460, 'POST OWF.G ROLLUP 3 - 11.5.9.3',
3126422,
'11.5.9 Oracle E-Business Suite Consolidated Update 1',
3171663,
'11.5.9 Oracle E-Business Suite Consolidated Update 2',
3316333, 'POST OWF.G ROLLUP 4 - 11.5.9.4.1',
3314376, 'POST OWF.G ROLLUP 5 - 11.5.9.5',
3409889,
'POST OWF.G ROLLUP 5 Consolidated Fixes For OWF.G RUP 5',
3492743, 'POST OWF.G ROLLUP 6 - 11.5.9.6',
3868138, 'POST OWF.G ROLLUP 7 - 11.5.9.7',
3262919, 'FMWK.H',
3262159, 'FND.H INCLUDE OWF.H',
3258819, 'OWF.H INCLUDED IN 11.5.10',
3438354, '11i.ATG_PF.H INCLUDE OWF.H',
3140000,
'ORACLE APPLICATIONS RELEASE 11.5.10 MAINTENANCE PACK',
3240000,
'11.5.10 ORACLE E-BUSINESS SUITE CONSOLIDATED UPDATE 1',
3460000,
'11.5.10 ORACLE E-BUSINESS SUITE CONSOLIDATED UPDATE 2',
3480000,
'ORACLE APPLICATIONS RELEASE 11.5.10.2 MAINTENANCE PACK',
4017300,
'ATG_PF:11.5.10 Consolidated Update (CU1) for ATG Product Family',
4125550,
'ATG_PF:11.5.10 Consolidated Update (CU2) for ATG Product Family',
5121512,
'AOL USER RESPONSIBILITY SECURITY FIXES VERSION 1',
6008417, 'AOL USER RESPONSIBILITY SECURITY FIXES 2b',
6047864,
'REHOST JOC FIXES (BASED ON JOC 10.1.2.2) FOR APPS 11i',
4334965, '11i.ATG_PF.H RUP3',
4676589, '11i.ATG_PF.H.RUP4',
5473858, '11i.ATG_PF.H.RUP5',
5903765, '11i.ATG_PF.H.RUP6',
6241631, '11i.ATG_PF.H.RUP7',
4440000, 'Oracle Applications Release 12 Maintenance Pack',
5082400, '12.0.1 Release Update Pack (RUP1)',
5484000, '12.0.2 Release Update Pack (RUP2)',
6141000, '12.0.3 Release Update Pack (RUP3)',
6435000, '12.0.4 RELEASE UPDATE PACK (RUP4)',
5907545, 'R12.ATG_PF.A.DELTA.1',
5917344, 'R12.ATG_PF.A.DELTA.2',
6077669, 'R12.ATG_PF.A.DELTA.3',
6272680, 'R12.ATG_PF.A.DELTA.4',
7237006, 'R12.ATG_PF.A.DELTA.6',
6728000, '12.0.6 RELEASE UPDATE PACK (RUP6)',
7303030, '12.1.1 Maintenance Pack',
7651091, 'Oracle Applications Technology Release Update Pack 2 for 12.1 (R12.ATG_PF.B.DELTA.2)',
7303033, 'Oracle E-Business Suite 12.1.2 Release Update Pack (RUP2)',
8919491, 'Oracle E-Business Suite Applications Technology Release 12.1.3 (R12.ATG_PF.B.delta.3)',
bug_number) bug,
aru_release_name
FROM ad_bugs b
WHERE b.bug_number IN ( '2728236', '3031977', '3061871', '3124460',
'3126422', '3171663', '3316333', '3314376',
'3409889', '3492743', '3262159', '3262919',
'3868138', '3258819', '3438354', '3240000',
'3460000', '3140000', '3480000', '4017300',
'4125550', '6047864', '6008417', '5121512',
'4334965', '4676589', '5473858', '5903765',
'6241631', '4440000', '5082400', '5484000',
'6141000', '6435000', '5907545', '5917344',
'6077669', '6272680', '7237006', '6728000',
'7303030', '7651091', '7303033', '8919491' )
ORDER BY bug_number,
last_update_date,
aru_release_name;

ORA-29861: domain index is marked LOADING/FAILED/UNUSABLE

Today while running the Maintain Multi-lingual tables through adadmin for the post language enablement step, it failed for the script JTFNLINS.sql with the below error.

MESG--------------------------------------------------------------------------------LANGUAGE=AMERICANPACKAGE=JTF_NOTES_PKGSQLERRM=ORA-29861: domain index is marked LOADING/FAILED/UNUSABLE
select to_date('ERROR') *ERROR at line 1:ORA-01858: a non-numeric character was found where a numeric was expected

After little research on metalink, found that the domain index JTF_NOTES_TL_C1 is causing the issue.

Resolution:
- Drop index JTF.JTF_NOTES_TL_C1 force;
- sqlplus apps/apps @$JTF_TOP/patch/115/sql/jtfntsci.sql JTF JTF

- Restart the failed adadmin job through adctrl or execute the script JTFNLINS.sql manually