Toubleshooting Doc id's

Oracle APPS related documents
I found the following document list from metalink note # 828157.1, this is complete Oracle APPS library which surely is very useful for every APPS professional.

And here are the document list, which is an asset for every APPS professional.

Document List

Java
----------------------------------------------------------------------------------------------------
Note 418664.1 Overview of Using Java with Oracle E-Business Suite Release 12
Note 455492.1 Using Latest Update of Java 6.0 with Oracle E-Business Suite Release 12
Note 384249.1 Using Latest Update of JDK 5.0 with Oracle E-Business Suite Release 12

Note 300482.1 Overview of Using Java with Oracle E-Business Suite Release 11i
Note 401561.1 Using J2SE Version 6 with Oracle E-Business Suite 11i
Note 304099.1 Using J2SE Version 5.0 with Oracle E-Business Suite 11i, Release 11.5.10
Note 246105.1 Upgrading to J2SE 1.4.2 with Oracle Applications 11i
Note 130091.1 Upgrading Oracle Applications 11i to use JDK 1.3


JRE/Jinitiator
----------------------------------------------------------------------------------------------------
Note 389422.1 Recommended Browsers for Oracle E-Business Suite Release 12
Note 393931.1 Deploying Sun JRE (Native Plug-in) for Windows Clients in Oracle E-Business Suite Release 12

Note 285218.1 Recommended Browsers for Oracle Applications 11i
Note 290807.1 Deploying Sun JRE (Native Plug-in) for Windows Clients in Oracle E-Business Suite 11i
Note 124606.1 Upgrading JInitiator with Oracle E-Business Suite 11i


Forms
----------------------------------------------------------------------------------------------------
Note 437878.1 Upgrading OracleAS 10g Forms and Reports in Oracle E-Business Suite Release 12
Note 750359.1 Upgrading to Previous Version of OracleAS 10g Forms and Reports in Oracle E-Business Suite Release 12
Note 384241.1 Using Forms Socket Mode with Oracle E-Business Suite Release 12
Note 438652.1 R12 Forms Runtime Diagnostics (FRD), Tracing And Logging For Forms In Oracle Applications
Upgrading OracleAS 10g Forms and Reports in Oracle E-Business Suite Release 12 (Doc ID 437878.1)
Troubleshooting WebForms Tuning / Performance /Time out Problems [ID 294749.1]

Note 125767.1 Upgrading Developer 6i with Oracle Applications 11i
Note 232313.1 Information on Previous Versions of Developer 6i Patchsets
Note 150168.1 Obtaining Forms Runtime Diagnostics (FRD) In Oracle Applications 11i
Note 760250.1 Diagnosing Forms Mouse Focus Problems Using JRE in Release 11i
How To Regenerate Forms Library Files Using "adadmin" (11i & R12) (Doc ID 141118.1)


OracleAS
----------------------------------------------------------------------------------------------------br>Note 454811.1 Upgrading to the Latest OracleAS 10g 10.1.3.x Patch Set in Oracle E-Business Suite Release 12
Note 743518.1 Starting up AS10g services in an EBusiness Suite Release 12 environment


JDBC
----------------------------------------------------------------------------------------------------
Note 557194.1 monitor_jdbc_conn.sql - Script to monitor JDBC connections in Apps eBusiness Suite


JVM
----------------------------------------------------------------------------------------------------
Note 362851.1 Guidelines to setup the JVM in Apps Ebusiness Suite 11i and R12
Note 567551.1 Configuring various JVM tuning parameters for Oracle E-Business suite 11i and R12
Note 370583.1 Basic troubleshooting of JVM consuming cpu or too many JDBC connections in Apps 11i


Apache/mod_jserv
----------------------------------------------------------------------------------------------------
Note 230688.1 11i Basic Apache/mod_jserv Troubleshooting with Hello.class


Debug/Trace
----------------------------------------------------------------------------------------------------
Note 422419.1 R12 - How To Enable and Collect Debug for HTTP, OC4J and OPMN
Note 443671.1 R12 - Collecting Configuration Information for HTTP, OC4J and OPMN
Note 427848.1 How to Enable Execution Context ID (ECID) in the R12 access_log
Note 455154.1 R12: How To Obtain A Thread Dump When OC4J is shutdown

Note 603390.1 How To Create a User Event Trace in R11i / R12


OA Framework
----------------------------------------------------------------------------------------------------
Note 391554.1 Oracle Application Framework Documentation Resources, Release 12

Note 275880.1 Oracle Application Framework Release 11i Documentation Road Map
Note 275875.1 Oracle Application Framework Troubleshooting Release 11i (11.5.10)
Note 357597.1 How To Generate A SQL Trace In OA Framework For Oracle Applications


WebCache
----------------------------------------------------------------------------------------------------
Note 380486.1 Installing and Configuring Web Cache 10g and Oracle E-Business Suite 12
Note 306653.1 Installing and Configuring Web Cache 10.1.2 and Oracle E-Business Suite 11i


JDeveloper
----------------------------------------------------------------------------------------------------
Note 330236.1 Configuring JDeveloper For Use With Oracle Applications 11i and R12
Note 357218.1 Troubleshooting JDeveloper setup for Oracle Applications
Note 787209.1 How to find the correct version of JDeveloper to use with eBusiness Suite 11i or Release 12


Performance
----------------------------------------------------------------------------------------------------
Note 244040.1 bde_last_analyzed.sql - Verifies CBO Statistics
Note 74605.1 bde_chk_cbo.sql - Reports Database Initialization Parameters related to an Apps 12 or 11i instance
Note 396009.1 Database Initialization Parameters for Oracle Applications Release 12
Note 216205.1 Database Initialization Parameters for Oracle Applications 11i
Note 744143.1 Tuning performance on eBusiness suite
Note 169935.1 Troubleshooting Oracle Applications Performance Issues
Note 244040.1 Oracle E-Business Suite Recommended Performance Patches


Security
----------------------------------------------------------------------------------------------------
Note 738923.1 Oracle E-Business Suite Releases 11i and 12 Critical Patch Update note (January 2009)
Note 403537.1 Best Practices for Securing Oracle E-Business Suite Release 12
Note 189367.1 Best Practices for Securing the E-Business Suite Release 11i


Ihelp
----------------------------------------------------------------------------------------------------
Note 740834.1 R12: Troubleshooting iHelp


Advanced Configurations
----------------------------------------------------------------------------------------------------
Note 380483.1 Oracle E-Business Suite Release 12 Additional Configuration and Deployment Options
Note 217368.1 Advanced Configurations and Topologies for Enterprise Deployments of E-Business Suite 11i
Note 233428.1 Sharing the Application Tier File System in Oracle Applications 11i
Note 233436.1 Installing Oracle Application Server 10g with Oracle E-Business Suite Release 11i
Note 364439.1 Tips and Queries for Troubleshooting Advanced Topologies


DMZ
----------------------------------------------------------------------------------------------------
Note 380490.1 Oracle E-Business Suite R12 Configuration in a DMZ
Note 726953.1 Case History: Implementing a Reverse Proxy Alone in the DMZ Configuration - R12
Note 287176.1 DMZ Configuration with Oracle E-Business Suite 11i
Note 438744.1 Case History: Implementing a Reverse Proxy Alone in a DMZ Configuration - 11i
Note 460564.1 Hints and Tips for Troubleshooting the URL Firewal


Loadbalancer
----------------------------------------------------------------------------------------------------
Note 380489.1 Using Load-Balancers with Oracle E-Business Suite Release 12
Note 727171.1 Implementing Load Balancing On Oracle E-Business Suite - Documentation For Specific Load Balancer Hardware
Note 601694.1 How To Check Session Persistence On BigIP F5 And Cisco Ace Load Balancer Appliances
Note 603325.1 Using Cisco ACE Series Application Control Engine with Oracle E-Business Suite Release 12

BigIp:
----------------------------------------------------------------------------------------------------
How To Check Session Persistence On BigIP F5, Cisco Ace, Citrix Netscaler or Radware AppDirector Load Balancer Appliances [ID 601694.1]


SSL
----------------------------------------------------------------------------------------------------
Note 376700.1 Using SSL with Oracle E-Business Suit Release 12
Note 123718.1 11i A Guide to Understanding and Implementing SSL for Oracle Applications


Portal
----------------------------------------------------------------------------------------------------
Note 305918.1 Using Oracle Portal 10g with Oracle E-Business Suite Release 11i


SSO/OID
----------------------------------------------------------------------------------------------------
Note 376811.1 Integrating Oracle E-Business Suite Release 12 with 10g AS Oracle Internet Directory and Oracle Single Sign-On

Note 261914.1 Integrating Oracle E-Business Suite Release 11i with Oracle Internet Directory and Oracle Single Sign-On
Note 444573.1 Basic checks for user integration when using Oracle E-Business Suite 11i with Oracle AS 10g


Webcenter
----------------------------------------------------------------------------------------------------
Note 557221.1 Oracle WebCenter 10g Application Creation and Deployment Guide for Oracle E-Business Suite Release 12


Secure Enterprise Search
----------------------------------------------------------------------------------------------------
Note 566097.1 Oracle E-Business Suite Secure Enterprise Search Release Notes, Release 12.1.1
Note 744820.1 Oracle E-Business Suite Secure Enterprise Search Best Practices, Release 12
Note 462377.1 Installing Oracle E-Business Suite Secure Enterprise Search, Release 12
Note 740499.1 Oracle E-Business Suite Secure Enterprise Search Release Notes, Release 12.0.6
Note 726239.1 Oracle E-Business Suite Secure Enterprise Search Troubleshooting Guidelines, Release 12


SOA/BPEL/Webservices
----------------------------------------------------------------------------------------------------
Note 556540.1 Installing Oracle E-Business Suite Integrated SOA Gateway, Release 12.1
Note 726414.1 Oracle E-Business Suite Integrated SOA Gateway Troubleshooting Guide, Release 12
Note 755067.1 Using Oracle BPEL 10g with E-Business Suite Release 12.1.1
Note 755069.1 EBS R12 Packager and Adapters for External Application Servers
Note 782455.1 How Can I Expose E-Business Suite Integration Interfaces as Web Services in Release 11i and R12.0


MWA
----------------------------------------------------------------------------------------------------
Note 782162.1 MWA Troubleshooting Tips for Release 12
Note 269991.1 MWA Troubleshooting Tips for Release 11i


Certified/Supported
----------------------------------------------------------------------------------------------------
http://blogs.oracle.com/stevenchan/certifications.html
Note 363827.1 Rebaselined Oracle Applications Technology Components for Releases 11.5.7, 11.5.8, 11.5.9, and 11.5.10


WEBADI
----------------------------------------------------------------------------------------------------
Note 417692.1 Installing, Configuring and Troubleshooting Web ADI (Web Applications Desktop Integrator)
Note 452452.1 R12 Installing, Configuring and Toubleshooting Web ADI (Web Applications Desktop Integrator)
Note 294739.1 How to enable tracing for WEBADI
Note 726989.1 List of Patches in Web Applications Desktop Integrator (Web ADI) for Releases 11i and 12


Diagnostics
----------------------------------------------------------------------------------------------------
Note 167000.1 E-Business Suite Diagnostics Installation Guide
Note 421245.1 E-Business Suite Diagnostics References for R12
Note 179661.1 E-Business Suite Diagnostics 11i Test Catalog


Installation
----------------------------------------------------------------------------------------------------
Note 761564.1 Oracle Applications Installation and Upgrade Notes Release 12 (12.1.1) for Linux x86
Note 402310.1 Oracle Applications Installation and Upgrade notes Release 12 (12.0) for Linux (32-bit)
Note 406982.1 Cloning Oracle Applications Release 12 with Rapid Clone
Note 559518.1 Cloning Oracle E-Business Suite Release 12 RAC-Enabled Systems with Rapid Clone

Note 421409.1 Unbreakable Linux enviroment check before R12 install
Note 458533.1 How to Enable Enterprise Manager on the Oracle E-Business Suite Release 12
Note 603716.1 Using AS10g AS Control with eBusiness Suite Rel 12
Note 452120.1 How to locate the log files and troubleshoot RapidWiz for R12
Note 316806.1 Oracle Applications Installation Update notes, Release 11i (11.5.10.2)
Note 230672.1 Cloning Oracle Applications Release 11i with Rapid Clone

Note 207296.1 How to Find out Linux Version Information?


Database
----------------------------------------------------------------------------------------------------
Note 454750.1 Oracle Apps Release 12 with Oracle Database 10.2.0 interoperability notes
Note 735276.1 Interoperability notes E-Business Suite R12 with Oracle Database 11gR1
Note 388577.1 Configuring Oracle Applications Release 12 with 10g R2 RAC
Note 466649.1 Using Oracle 11g Release 1 Real Application Clusters and Automatic Storage Management with Oracle E-Business Suite Release 12

Note 216550.1 Oracle Applications Release 11i with Oracle9i Release 2 (9.2.0)
Note 362203.1 Oracle Applications Release 11i with Oracle 10g Release 2 (10.2.0)
Note 452783.1 Oracle Applications Release 11i with Oracle 11g Release 1 (11.1.0)
Note 362135.1 Configuring Oracle Applications Release 11i with 10g R2 RAC and ASM

Note 554539.1 Using Database Partitioning with Oracle E-Business Suite


Monitering Health Checks
-----------------------------------------------------------------------------------------------------

Oracle E-Business Suite Diagnostics Test Catalog for 12.1.1 [ID 783319.1]
Best Practices for Securing the E-Business Suite [ID 189367.1]
E-Business Suite Diagnostics Installation Guide [ID 167000.1]
E-Business Suite Diagnostic Tools FAQ and Troubleshooting Guide for Release 11i and R12 [ID 235307.1]
Applications 11i Health Check After Maintenance [ID  283976.1 ]


Database Performance Master Note 402983.1
SQL Tuning Performance Master Note 199083.1
Start Here: Diagnosing Query Tuning Problems Note 233112.1
Oracle Performance Diagnostic Guide Note 390374.1
How to Log a Good Performance Service Request Note 210014.1


Note 301137.1 OSWatcher Black Box User Guide
Note 1359094.1 FAQ: How to Use AWR Reports to Diagnose Database Performance Issues
How to Generate an AWR Report and Create Baselines (Doc ID 748642.1)
Note 461053.1 OSWatcher Black Box Analyzer User Guide
Note 1392633.1 Things to Consider before Upgrading to 11.2.0.3 to Avoid Poor Performance or Wrong Results
Note 223117.1 Troubleshooting I/O-Related waits


JRE
------------------------------------------------------------------------------------------------------

Deploying Sun JRE (Native Plug-in) for Windows Clients in Oracle E-Business Suite Release 12 (Doc ID 393931.1)

Worflow
-----------------------------------------------------------------------------------------------------

Note 275379.1 Script To Check What Workflow Related Patches and run to check installed patches


Autoconfig
-----------------------------------------------------------------------------------------------------

https://support.us.oracle.com/oip/faces/secure/km/DocumentDisplay.jspx?id=387859.1


Front End URLs
------------------------------------------------------------------------------------------------------

#If you wish to expose Web Services externally, see   Note: 380490.1 for detailed instruction on generating  and editing url_fw_ws.conf 

#Include Web Services URL FireWall If you wish to expose Web Services externally, see  Note: 380490.1 for detailed instruction on generating and editing url_fw_ws.conf

How to Redirect Oracle E-Business Suite 11i index.html page, directly to the Login Page (/oa_servlets/AppsLogin) (Doc ID 602445.1)

 $INST_TOP/portal/index.html

HTTP-500 Errors and Database Connection Errors
-------------------------------------------------------------------------------------------------------

E-Business Suite Users Experience Intermittent HTTP-500 Errors and Database Connection Errors (Doc ID 1314433.1)


NOTE:217368.1 - Advanced Configurations and Topologies for Enterprise Deployments of E-Business Suite 11i
NOTE:257650.1 - Resolving Problems with Connection Idle Timeout With Firewall
NOTE:380489.1 - Using Load-Balancers with Oracle E-Business Suite Release 12
NOTE:563233.1 - Concurrent Processing - Potential Output Post Processor Failures Due to a Multi-Node Setup
NOTE:601694.1 - How To Check Session Persistence On BigIP F5, Cisco Ace, Citrix Netscaler or Radware AppDirector Load Balancer Appliances
NOTE:727171.1 - Implementing Load Balancing On Oracle E-Business Suite - Documentation For Specific Load Balancer Hardware
NOTE:728463.1 - R12: iHelp Not Working After Implementing A Hardware Load Balancer, SSL Acceleration, Or DMZ
NOTE:779065.1 - "FRM-92050: Failed to connect to the server :/forms/lservlet -1" Error When Attempting to Launch Forms with Reverse Proxy


ADPATCH
-------------------------------------------------------------------------------------------------------

233038.1 – AD Command Line Options

130608.1 – ADPATCH BASICS

225165.1 – Patching Best Practices and Reducing Downtime

124545.1 – Applications Patching – Time Saving Techniques

76535.1 – Troubleshooting Issues Which Arise During the Application of Release 11 Patches

175485.1 – How to Apply an 11i Patch When adpatch is Already Running

APPS
--------------------------------------------------------------------------------------------------------

233428.1 – Sharing the Application Tier File System in Oracle

294652.1 – E-Business Suite 11i on RAC : Configuring Database Load balancing & Failover

PERFORMANCE TUNING

<Note:169935.1> Troubleshooting Oracle Apps Performance Issues

WORKFLOW MAILER
---------------------------------------------------------------------------------------------------------

242941.1 – How To Troubleshoot Java-based Workflow Notification Mailer In 11.5.9 and OWF.G

249957.1 – Example Of Configuring Workflow Java Notification Mailer With Oracle Applications 11.5.x

268085.1 – Configuring the Oracle Workflow 2.6/11i.OWF.H Java-based Notification Mailer with Oracle Applications 11i

267894.1 – How To Troubleshoot Java-based Workflow Notification Mailer In 11.5.9 and OWF.G

SSL
----------------------------------------------------------------------------------------------------------

273173.1 – Enable SSL in Oracle Applications 11.5.9 for Oracle OnDemand Customers

GSM
----------------------------------------------------------------------------------------------------------
210062.1 – Generic Service Management (GSM) in Oracle Applications 11i

PCP
----------------------------------------------------------------------------------------------------------

105133.1 – Concurrent Manager Questions and Answers Relating to Generic Platform

185489.1 – Setting Up Parallel Concurrent Processing On Unix Server

100449.1 – Setting Up Parallel Concurrent Processing in Release 11.0

SECURITY ALERTS

237007.1 – Secutiry Alert FAQ

JSP

215268.1 – Implementing and Using the JSP Precompiler (2636229)

229903.1 – Troubleshooting Performance issues for JSP pages in Oracle

OUI

2878462 – OUI PATCH 2.2.0.18.0

DEVELOPER

273393.1 => Report Server bible

Jinitiator

Bug.3329644

232200.1 – Client Tier and Jinitiator With Applications 11i

162488.1 – Complete Guide to JInitiator Setup & Troubleshooting for Oracle Applications 11i

Oracle9i

214887.1 – Upgrading Directly to a 9.2.0 Patch Set

159657.1 – Upgrading from V8.X to V9.X

62143.1 – Understanding and Tuning the Shared Pool

279069.1 – Compatibility Matrix: Linux, Filesystem & I/O Type

46234.1 – Interpreting Explain plan

236026.1 – Display Execution Plans with dbms_xplan.display

RAC

175465.1 – Step-By-Step Installation of 9i RAC on Sun Cluster v3

184821.1 – Step-By-Step Installation of 9.2.0.5 RAC on Linux

237997.1 – Linux OCFS – Best Practices

11i

216550.1 – Oracle Applications Release 11i with Oracle9i Release 2 (9.2.0)

216205.1 – Database Initialization Parameters for Oracle Applications 11i

DMZ

287176.1 – DMZ Configuration with Oracle E-Business Suite 11i

241015.1 – Configuring Applications 11i for use with Reverse Proxy and DMZ

217368.1 – Advanced Configurations and Topologies for Enterprise Deployments of E-Business Suite 11i

Discoverer4i

3201601 – 4.1.48.06 Admin edition patch

261528.1 – Setup of Discoverer 4i Gatekeeper For Firewall Access Without Using gkconfig GUI

280598.1 – Discoverer 4i On Linux: Required Patch and Configuration for Discoverer Server Stability

Oracle E-Business Suite R12 Configuration in a DMZ [ID 380490.1]



Express Server

68063.1 – How to backup Express Server 6

iAS

Note:175434.1 Create/Upgrade/Migrate a Database to Have a Locally Managed System Tablespace

Note:105120.1 Advantages of Using Locally Managed vs Dictionary Managed Tablespaces

Note:93771.1 Introduction to Locally-Managed Tablespaces

Note:109630.1 How and Where Bitmaps are Allocated for Locally Managed Tablespaces

Note:103020.1 Migration from Dictionary Managed to Locally Managed Tablespaces

Note: 248857.1

Techstack

277366.1 – Technology Validation Utility for Oracle Applications Release 11i (11.5.10 and higher)

Note: 166650.1 : Working Effectively With Support

PIC is document ID 1264434.1


OPatch
----------------------------------------------------------------------------------------------------

SEVERE:OUI-67028:Inventory load failed... OPatch cannot load inventory for the given Oracle Home. [ID 1226483.1]


Payroll
=======

Assignment Errors With pay_us_emp_dt_tax_rules.insert_fed_row APP-PAY-06153 (Doc ID 341171.1)

Error Saving A Salary Basis - pay_us_emp_dt_tax_rules.Insert_fed_tax_row (Doc ID 302878.1)

MRP Memory Based Planner has completed with error!!! PLZ HELP!!!
-----------------------------------------------------------------------------------------------------

Memory-Based Snapshot - Fails When Trying To Create a File larger than 2 gigabytes In Size [ID 261204.1]
Pnd : 6967677 : Mbp App-Mrp-22075: An Internal Error Has Occurred [ID 565763.1]
MRCNSP Memory-Based Snapshot Fails Selecting Capacity Resource Info [ID 295273.1]
MRCNSW Snapshot Worker Fails When Bill Of Resources/CRP Enabled APP-MRP-20075 - Also Performance Fix For CYCROL - Load Bill Of Resource [ID 959585.1]


Performance Tunning
-----------------------------------------------------------------------------------------------------

012-10-16 15:12:14.0 - 133320.1 Managing Payroll Performance using the Cost Based Optimizer (CBO)
2012-10-16 15:05:36.0 - 219306.1 How Do I Improve Payroll Performance?
2012-10-16 13:38:02.0 - 1342917.1 Troubleshooting ''latch: cache buffers chains'' Wait Contention
2012-10-09 18:11:41.0 - 1121393.1 (NEW for MOS v6): Creating On Demand Service Requests
2012-10-09 18:10:48.0 - 1473309.1 MOS-OD: Chapter 3 Service Requests
How to Generate an AWR Report and Create Baselines (Doc ID 748642.1)

Oracle Configuration Manager(OCM)
------------------------------------------------------------------------------------------------------
OCM ( Oracle Configuration Manager ) and My Oracle Support : FAQ and Troubleshooting (Doc ID 369619.1)
NOTE:406369.1 - Oracle Configuration Manager and E-Business Suite Release 12 Release Notes
NOTE:443727.1 - OCM:Cannot Connect To NTLM Proxy Server
NOTE:1182283.1 - How to associate a Support ID to a target via 'Associate Systems with Support Identifiers' (previous Task: Associate Collectors)

Login Page Issues:
------------------
Implementing Load Balancing On Oracle E-Business Suite - Documentation For Specific Load Balancer Hardware(727171.1)
Oracle E-Business Suite R12 - Login Page showing a blank page Occuring Intermittently [ID 1491845.1]
11i/R12 How to Debug "Transaction Context Is Lost" or "You are trying to access a page that is no longer active"(456906.1)
E-Business Suite Users Experience Intermittent HTTP-500 Errors and Database Connection Errors(1314433.1)