R12 New Techstack

There has been a specific directory structure and file structure that is followed in Oracle application. In the previous release till 11iCU2, there was some standard naming convention that is following. Each directory whether it’s a product top or form directory was having an organized path.

In the new oracle application release, E-Business suite R12, the file directory structure is changed. This doesn’t mean that there is no specific organization of files and directory. Off course the pattern for directories and file system is organized well, but it is different then the directory structure for the previous releases.

In this post we will check the changes in the directory structure organization and also the techstack level changes.

Why new structure

Lets us first answer to the question, as to why the new directory structure and file system was introduced, if at all, old file system and directory structure was flaw less and been working fine. And the answer to this is the need to separate E-business suite into three parts

Data
Code
Configuration
In many cases, configuration changes more frequently than code and data. So keeping it separately would result in easy maintenance.

Also, in a shared file system, MUTEX files, related to Apache, cause access related problems as IAS_ORACLE_HOME is mounted on NFS. With the new file structure, this issue is also resolved as all the configuration files can be stored on the local server instead of NFS.

Directory Structure Changes

In R12 the directory structure is as given below. Just after HOME, we have APPS directory and INST directory. APPS directory contains the APPL_TOP and also the installation of forms OH and application server 10g. The version for forms that is used in E-Business suits is 10g and also the application server used is 10g. The directory 10.1.2 belongs to form oracle home and directory 10.1.3 belongs to application server oracle home. Since these are the underlying technology they are grouped under TECH_ST. APPS_ST contains the APPL_TOP and COMMON_TOP. In apps11i the APPL_TOP directory used to have format appl, where as in R12 this has been changed as simply appl directory


Other then this there is one more directory at this level (INST). This is instance directory. We have a new environment variable in R12 called as INST_TOP, which points in this directory.

Instance top contains all the config files, log files, ssl certificates, document root etc. This is a new directory introduced in R12TS. Addition of this directory makes the middle-tier more organized, since data is kept separate from config/log files. Another advantage is that, multiple instances can easily share the same middle tier / DB. To create a new instance that shares an existing middle-tier, just create a new instance_top with proper config files and nfs mount the middle tier in the server

The directory structure for apps11i is also shown. Here we have 3 top directory under HOME directory. These are appl (APPL_TOP as discussed previously), comn (COMMON_TOP) and ora (IAS_ORACLE_HOME for 9i Application server and forms ORACLE_HOME). Inside ora directory we have 8.0.6 directory, which is the ORACLE_HOME for forms, and iAS directory which is ORACLE_HOME for 9i Application server.



For the new E-Business suite, the structure on the database side is as shown in the fig



The database side consists of the base oracle directory, similar to appmgr directory. Inside oracle directory again we have the distinction of technology directory with data directory. We have APPS_ST and TECH_ST directories. APPS_ST contains data files for the database and TECH_ST is the ORACLE_HOME for oracle database 10g.

File System Changes

Here we will be comparing the major directory structure changes that happened between the old and new release.



JAVA_TOP changes
11i:

$JAVA_TOP = $COMMON_TOP/java
Class
Archives
R12:

$JAVA_TOP = $COMMON_TOP/java/classes
Classes
$AF_JLIB = $COMMON_TOP/java/lib
Archives
In case of 11i release the JAVA_TOP was pointing to COMMON_TOP / java directory, which consist of class and archive directories. The class directory consist of all the .class files where as archive directory consist of all jar files.

In R12 this has been changed and new JAVA_TOP directly points to COMMON_TOP / java / classes directory, which contains all .class files. For jar files we have another directory called lib. This contains JAR files. For pointing to this directory, there is another environment variable that is defined called AF_JLIB.

Techstack Level Changes

For Oracle Apps 11i we have following components version.



In R12 the components and versions are as given below.



Component Level Comparison

In case of new techstack some of the components got changed. Following is the brief comparison.



In case of 11i, Jserv engine was part of HTTP server and was used for JSP and Java requests. This has been replaced by OACORE (for handling JSP). Instead of Application server 9i used in 11i, in R12 we have Application server 10g.

INST_TOP Structure

Instance top contains all the config files, log files, ssl certificates, document root etc. This is a new directory introduced in R12TS. Addition of this directory makes the middle-tier more organized, since data is kept separate from config/log files. Another advantage is that, multiple instances can easily share the same middle tier / DB. To create a new instance that shares an existing middle-tier, just create a new instance_top with proper config files and nfs mount the middle tier in the server.

In 11i release all the config/log files was in COMMON_TOP. This has been shifted to INST_TOP. This is just to organize the application middle tire and to make a distinction between the core files and config/log files. Before checking the contents of INST_TOP, lets have a brief comparison of what was the content of COMMON_TOP in 11i release and R12. COMMON_TOP contains following directories.



So if we see the above comparison for the COMMON_TOP for 11i and R12, we see that there is only one directory, which is missing. This directory is admin directory. This directory is been shifted to INST_TOP. Also the log directory, which is still shown in COMMON_TOP, is no more used. There is another log directory in INST_TOP. This represents the logs for all the components of middle tier. Lets now see the structure of INST_TOP.



Here we see that we have some of the directories, which are same as directories in COMMON_TOP. So lets clear the confusion here as to which directory in which TOP is used for what purpose.

Actually the LOG, PORTAL and RGF directory in COMMON_TOP is not used. Instead these directories in INST_TOP are actually used. They are just the copies stored in COMMON_TOP. Also the admin directory is clearly moved to INST_TOP.

LOG directory contains the log files for all the components of mid tier like apache, oacore, opmn, and concurrent manager and also the logs for the AD-scripts used to manager various services.

CERTS directory is used for SSL certificates. In case of secured environment where secure certificates are used, the certificates should be downloaded in this directory.

PID directory contains the PID (process ID) for middle tier processes like apache.

APPL directory contains the 2 directories admin and fnd. ADMIN directory contains ojspCompile.conf and ojspCompile.properties. These files are important for JSP compilation and settings. FND directory contains the DBC file, which is required by the middle tier to connect to database. Actually the DBC file which used to be in $FND_TOP/secure directory location in the 11i release has been shifted to this location. This location is directly referred by an environment variable FND_SECURE. This was pointing to $FND_TOP/secure directory in 11i release. In R12 its pointing to $INST_TOP/appl/fnd/secure directory.

ORA directory indicated the techstack components. But an ORA directory in INST_TOP contains the configuration information of the techstack components. Lets look into the details of this directory.



ADMIN directory contains all the AD-scripts used to manage the middle tier components. ADMIN directory contains the SCRIPT directory, which has all the script. Actually these are the wrapper scripts over the main binary. We will see the details of these scripts when we explain each component. Following are the different AD-scripts and there function.



New Environment Variables in R12



Changes to existing environment Variables in R12

how to find the file versions in 11i

How to find version in Oracle Apps 11i
-->To find apps version

select release_name from apps.fnd_product_groups;

If your are on11i then output will be like 11.5.10 or 11.5.10.2

-->To find Apache/Webserver version

login to web tier as owner of application(applmgr)

$IAS_ORACLE_HOME/Apache/Apache/bin/httpd -version

-->To find a file version

adident Header

-->to find database version

sqlplus

connect / as sysdba

The top most line shows the oracle database version

-->to find forms version

f60gen

-->to find reports version

r60gen

-->to find workflow version

select text from WF_RESOURCES where name= ‘WF_VERSION’;

--To find OA Framework version
http://hostname:port/OA_HTML/OAInfo.jsp

or

adident Header $OA_HTML/OA.jsp

adident Header $FND_TOP/html/OA.jsp

Note:both versions from above command should be same


The following conversion chart can be used to identify the version


OA.jsp Version OA Framework Version


115.61 11.5.10.5RUP 5473858
115.60 11.5.10.4RUP 4676589
115.58 11.5.10.3RUP 4334965 / 5125546
115.56 5.10
115.36 5.7
115.27 5.6

--To find Jinitior version
$OA_HTML/bin/appsweb.cfg
locate the following line
jinit_ver_name=Version=1,3,1,18

--To find if the system is multi-org enabled


select multi_org_flag from fnd_product_groups

--To find if system is multilingual


select multi_lingual_flag from fnd_product_groups

--To find MRC is implemented or not


select multi_currency_flag from fnd_product_groups

Concurrent manger faqs........?

FND Concurrent Manager FAQ's
-----------------------------

When would one be required to bounce (stop and restart) the Concurrent Manager?

When you modify the Printer Driver you have to restart the Manager which
runs the request which is attached to that Printer Driver, however,if you do
not know which manager then you have to restart the Internal manager because
the printer driver can be used by multiple managers and multiple requests.
If only a concurrent program definition is modified, running a verify on the
Internal Manager will pick up the changes without the need for bouncing the
manager.



Does the Internal manager schedule requests to be run or does it put requests
into queues to be run by other managers?

This is a very common misconception. The ICM really does not have any
such scheduling responsibilities. It has NOTHING to do with scheduling
requests, or deciding which manager will run a particular request.
Its function is only to run 'queue control' requests, which are
requests to startup or shutdown other managers. It is responsible for
startup and shutdown of the whole concurrent processing facility, and
it also monitors the other managers periodically, and restarts them if
they should go down. It can also take over the Conflict Resolution
manager's job, and resolve incompatibilities.


If the ICM itself should go down, requests will continue to run
normally, except for 'queue control' requests. You can restart it with
'startmgr', you do not need to kill the other managers first.



How can I check to see if a concurrent manager is running?

One way to see if a manager is running is to use the 'Administer
Concurrent Managers' form. Navigate to Concurrent->Managers->Administer.
You will see two columns labeled 'Actual' and 'Target'. The Target column
lists the number of processes that should be running for each manager
for this particular workshift. The Actual column lists the number of
processes that are actually running. If the Actual column is zero, there
are no processes running for this manager. If the Target column is zero,
then either a workshift has not been assigned to this manager, or the current
workshift does not specify any target processes. If the target column
is not zero, then the manager processes have either failed to start up,
or gone down. You should check the manager's logfile and the ICM
logfile. You can also search for OS processes using the 'ps' command.
It is possible for the form to be inaccurate, i.e. it may show actual
processes even though they are not really running. When in doubt, check for
processes at the OS level. On NT, you can check to see if the Concurrent Manager
service is running using the Services control panel.



Where do concurrent request or manager logfiles and output files go?

The concurrent manager first looks for the environment variable
$APPLCSF. If this is set, it creates a path using two other
environment variables: $APPLLOG and $APPLOUT
It places log files in $APPLCSF/$APPLLOG, output files go in
$APPLCSF/$APPLOUT

So for example, if you have this environment set:
$APPLCSF = /u01/appl/common
$APPLLOG = log
$APPLOUT = out

The concurrent manager will place log files in /u01/appl/common/log,
and output files in /u01/appl/common/out
Note that $APPLCSF must be a full, absolute path, and the other two
are directory names.

If $APPLCSF is not set, it places the files under the product top of
the application associated with the request. For example, a PO report
would go under $PO_TOP/$APPLLOG and $PO_TOP/$APPLOUT
Logfiles go to: /u01/appl/po/9.0/log
Output files to: /u01/appl/po/9.0/out
All these directories must exist and have the correct permissions.

Note that all concurrent requests produce a log file, but not necessarily
an output file.
Concurrent manager logfiles follow the same convention, and will be
found in the $APPLLOG directory



What are the logfile and output file naming conventions?

Request logfiles: l.req


Output files: If $APPCPNAM is not set: .
If $APPCPNAM = REQID: o.out
If $APPCPNAM = USER: .out


Where: = The request id of the concurrent request
And: = The id of the user that submitted the request


Manager logfiles:


ICM logfile: Default is std.mgr, can be changed with the mgrname
startup parameter
Concurrent manager log: w.mgr
Transaction manager log: t.mgr
Conflict Resolution manager log: c.mgr


Where: is the concurrent process id of the manager



Can I delete a concurrent manager?

You can disable the manager by checking the 'Enabled' checkbox, or
you can simply Terminate the manager and it will not run again unless
you reactivate it.
If it is really necessary, you can query the manager in the
'Define Manager' form, and delete the row. (It is recommended that you
DO NOT do this)

What is the function of the 'Conflict Resolution Manager'?

Concurrent managers read requests to start concurrent programs running. The
Conflict Resolution Manager checks concurrent program definitions for
incompatibility rules.

If a program is identified as Run Alone, then the Conflict Resolution Manager
prevents the concurrent managers from starting other programs in the same
conflict domain.

When a program lists other programs as being incompatible with it, the
Conflict Resolution Manager prevents the program from starting until any
incompatible programs in the same domain have completed running.


What is the 'Internal Scheduler/Prereleaser' manager?

The short name for this manager is FNDSCH. It is also known as the
Advanced Scheduler/Prereleaser Manager. This manager is intended
to implement Advanced Schedules. Its job is to determine when a
scheduled request is ready to run. Advanced Schedules were not fully
implemented in Release 11.0, they are implemented in Release 11.5,
but are not widely used by the various Apps products. General Ledger
uses FNDSCH for financial schedules based on different calendars and
period types. It is then possible to schedule AutoAllocation sets,
Recurring Journals, MassAllocations, Budget Formulas, and MassBudgets
to run according to the General Ledger schedules that have been
defined.

If financial schedules in GL are not being used then it is not a
problem to deactivate this manager.



What is the 'Internal Monitor' manager/service?

This manager/service is used to implement Distributed Concurrent Processing.
It monitors whether the ICM is still running, and if the ICM crashes,
it will restart it on another node.
You do not need to run this manager/service unless you are using Distributed
Concurrent Processing.


See the Installation manual and Sysadmin Guide for more info on DCP.



How do I check/set the PMON method?

To check the PMON method:
1) cd $FND_TOP/sql
2) sqlplus apps/apps @afimchk.sql
This will tell whether the internal manager is running, what the PMON
method is, and where the log file is.


To set the PMON method:
1) first shut the concurrent managers down
2) cd $FND_TOP/sql
3) sqlplus apps/apps @afimpmon.sql LOCK (or RDBMS)



How do I enable/disable the Conflict Resolution Manager?

Use the system profile option 'Concurrent: Use ICM'.
Setting this to 'No' (which is the default) allows the CRM to be started.
Setting it to 'Yes' causes the CRM to be shutdown and the Internal
Manager (ICM) will take over the conflict resolution duties. If the CRM will
not start (it is started automatically by the ICM), check this profile option.


Note that using the ICM to resolve conflicts is not recommended.
The CRM's sole purpose is to resolve conflicts, while the ICM has
other functions to perform as well. Only set this option to 'YES'
if you have a good reason to do so.



How do I clean out the Concurrent Manager tables?

Cleaning out the tables is a useful method of making sure that there
are no invalid statuses that can prevent the managers from starting.
Previously, this has been done by truncating fnd_concurrent_processes
and/or fnd_concurrent_requests. Truncation of the tables is a little
drastic, and can cause problems later when trying to purge requests,
not to mention losing all of the request information.


Run the script, cmclean.sql, article Note 134007.1 CMCLEAN.SQL - Non
Destructive Script to Clean Concurrent Manager Tables
It will make sure the relevant status codes are valid without
deleting any information.



How do I tell concurrent manager processes apart at the OS level?

Use: pf -ef | grep FNDLIBR


This will produce output like:


vd11 13703 13660 0 May 11 ? 0:01 FNDLIBR FND Concurrent_Processor
MANAGE OLOGIN="APPS/94A491A1000000000000000000
n1070161 24936 24927 0 Apr 29 ? 0:05 FNDLIBR FND Concurrent_Processor
MANAGE OLOGIN="APPS_APPDEMO/94C4B1C10000000000
n1070161 24938 24927 0 Apr 29 ? 0:06 FNDLIBR FND Concurrent_Processor
MANAGE OLOGIN="APPS_APPDEMO/94C4B1C10000000000
n1070161 24927 24922 0 Apr 29 ? 2:03 FNDLIBR FND CPMGR FNDCPMBR sysmgr
="" sleep=60 pmon=20 diag=N logfile=/u16/app


The last process, #24927, shows 'FNDLIBR FND CPMGR', this one is the
Internal Manager (ICM). Notice that it gives some of the parameters it
was started with, the other processes showing 'Concurrent_Processor'
are Standard manager processes. Notice that the ICM process is the
parent process of the Standard managers. (processes 24936 and 24938)

Other managers will have the name of the executable, like ARLIBR or
INVLIBR:

$ ps -ef | grep ARLIBR
vd11 13683 13660 0 May 11 ? 0:20 ARLIBR APPS/82A2A4940000000000000
000000000000000000000000000000000000000 AR ART


The Conflict Resolution manager will look like:

$ ps -ef | grep FNDCRM
n1070161 24941 24927 0 Apr 29 ? 1:17 FNDCRM APPS_APPDEMO/84BFBEB900000
0000000000000000000000000000000000000000000000



What is the syntax for controlling the concurrent manager using startmgr and
concsub in NT?

On NT, the concurrent manager is run as an NT service, you start and
stop the managers using the Services control panel.
See the Applications Installation manual for NT, Appendix A for
details. See pg. 5-9 of this manual for instructions on creating the
concurrent manager service.




Why am I seeing pinging entries like this in the ICM logfile?

PING (0.0.0.0): 56 data bytes
64 bytes from 192.75.91.2: icmp_seq=0 ttl=255 time=0.705 ms
64 bytes from 192.75.91.2: icmp_seq=1 ttl=255 time=1.120 ms
Process monitor session ended : 29-FEB-2000 10:38:43
64 bytes from 192.75.91.2: icmp_seq=2 ttl=255 time=0.985 ms
64 bytes from 192.75.91.2: icmp_seq=3 ttl=255 time=1.006 ms


Pinging other machines is used in Distributed Concurrent Processing.
This means you have DCP turned on, using the environment variable
APPLDCP. Set APPLDCP to OFF and restart the managers.



I hit the Restart button to start the Standard manager, but it still did not
start?

Telling a manager to restart just sets the status to Restart. The ICM
will start it the next process monitor session or the next time the
ICM starts. Use Activate to start a manager immediately.
When a manager is deactivated manually, the ICM will not restart
it, you will need to set it to Restart, or activate it manually.



How many rows are in FND_CONCURRENT_REQUESTS and FND_CONCURRENT_PROCESSES
tables?

When tables reach above 3000-4000 rows, the performance begins to
diminish. You may want to run Purge Concurrent Request on a regular basis,
dependant on the amount of requests being run.

The Purge Concurrent Requests job can be used to purge:
Requests, Mgr logs, and All requests depending on what is chosen.

Use the following options: Enter = All, Mode = AGE, Mode Value = 15

The std.mgr log continuously grows where it may good to
archive it regularly.



Any processes pending in Internal or Conflict Resolution Manager?

Best course of action before starting the Concurrent Managers is to cancel
any "Deactivate" or "Verify" jobs pending in the Internal Manager and place
any other pending jobs on hold.



How do I turn on transaction manager diagnostics?

Set the profile option 'Concurrent:Debug Flags' to 'TCTM1' at the site
level. This will cause transactions to make debug entries in the
FND_CONCURRENT_DEBUG_INFO table. Truncate this table before running a
tranasction, then select the entries from the table.
Starting the managers with diag=Y will also produce more information
in the transaction manager logfile.



How do transaction managers work?

Briefly:
(See the server documentation for details on the DBMS_PIPE package)
1) A tranasction manager is started on the concurrent processing
server, and periodically reads the pipe for incoming transactions.
2) A client program (usually a form) calls the
FND_TRANSACTION.SYNCHRONOUS function.
3) This function writes a message into the pipe containing the program
to be run and its parameters.
4) FND_TRANSACTION.SYNCHRONOUS begins reading a return pipe for the
return status.
5) The manager sees the message in the pipe, retrieves the program id
and parameters.
6) The manager runs the program with the specified parameters. The
program will be of type 'Immediate', so there will not be a
separate concurrent request run.
7) The program completes, and the manager packs its return status into
the return pipe.
8) FND_TRANSACTION.SYNCHRONOUS reads the return value and passes it
back to its caller.


Note that these events take place essentially simultaneously on the
client and server. This is a synchronous transaction because the
client waits for the server to return, or times out waiting for it.



Problem....

When you try to submit a request like Active users or
Active responsibilities, request gets submitted.

When we view the help requests, you find that it is
inactive / nomanager.

Within 12 to 15 seconds, you refresh-it gets completed.

Initially, you could find only inactive and we look at
the diagnostic- the concurrent manager assigned is not
picking up.

There is no specialization rules in any managers except
the include program this source.

Solution....

Most often when this occurs where a request goes
"inactive/no manager" and is then processed a short time
later, the solution is to either increase the cache size
for your Standard manger, or increase the actual number of
Standard manager processes.

Cache Size is set on the CONCURRENT/MANAGER/DEFINE form. Basically,
this regulates how many requests a manager will pick up for each
sleep cycle.


How do I process more concurrent requests concurrently?

The Concurrent Manager parameters, (Query the concurrent manager by
Login as Sysadmin, navigate -> Concurrent -> Manager -> Define and Query for
the relevant concurrent manager), should be modified to handle more
concurrent requests concurrently, this can be done in two steps:

(i) Increase the Number of Target processes for the manager

(ii) Change the cache size of the concurrent manager as this determines
how many requests will be evaluated by a manager at a time and should match the target (process) value as set above.



RELATED DOCUMENTS
-----------------
Note 1050938.6 What to Set $APPCPNAM for the Report Output File Naming Convention Format
Note 149600.1 FND_CONC_PP_ACTIONS and FND_RUN_REQ_PP_ACTIONS Growing Exponentially
Note 134007.1 CMCLEAN.SQL - Non Destructive Script to Clean Concurrent Manager Tables

Calculate the no of requests run per week

SELECT COUNT(*) Total, sum(decode(greatest(0,ceil (sysdate - actual_completion_date)), least(7,ceil(sysdate-actual_completion_date) ),1,0)) Week4, sum(decode(greatest(8,ceil (sysdate - actual_completion_date)), least(14,ceil(sysdate-actual_completion_date) ),1,0)) Week3, sum(decode(greatest(15,ceil (sysdate - actual_completion_date)), least(21,ceil(sysdate-actual_completion_date) ),1,0)) Week2, sum(decode(greatest(22,ceil (sysdate - actual_completion_date)), least(28,ceil(sysdate-actual_completion_date) ),1,0)) Week1 FROM FND_CONCURRENT_REQUESTS WHERE ACTUAL_COMPLETION_DATE is not null;

concurrent manager scripts

Scripts for monitoring concurrent managers

$FND_TOP/sql Scripts for monitoring concurrent managers

Script Description
Afcmcreq Prints the log file name of managers that can run a given request
Afcmstat Displays all defined managers and shows current status of manager processes
Afimchk Checks to see if the concurrent manager monitor is actually running
Afimlock Monitors locks that the ICM and CRM are waiting for. Run this if you have long delays when submitting jobs.
afimpmon Sets the PMON method based on the argument (for CONC_PMON_METHOD)
Afimveri Resets the concurrent manager monitor
Afqpmrid Returns the operating system process id of the FNDLIBR process of a concurrent manager request. Use this information to run ORADEBUG for specific requests.

$FND_TOP/sql Scripts for reviewing concurrent requests
Script Description
Afrqpend Lists all the Pending/Normal requests. These include jobs on hold, future-dated requests, and those waiting for a manager.
Afrqrun Lists all Running, Terminating, and Paused requests
Afrqscm Prints the log file names of managers that can run a given request
Afrqstat Summarizes concurrent request execution since a particular date
Afrqwait Selects all the Pending requests with status Q

WORKFLOW in oracle

In-built Data purge concurrent programs
As per metalink note 387459.1:


The ATG / FND supplied data purge requests are the following:
- Purge Concurrent Request and/or Manager Data [FNDCPPUR]
- Purge Obsolete Workflow Runtime Data [FNDWFPR]
- Purge Signon Audit data [FNDSCPRG.sql]
- Purge Obsolete Generic File Manager Data [FNDGFMPR]
- Purge Debug Log and System Alerts [FNDLGPRG]
- Purge Rule Executions [FNDDWPUR]
- Purge Concurrent Processing Setup Data for Cloning [FNDCPCLN]



Metalink Note 732713.1 describes purging strategy for E-Business Suite 11i:


There is no single Archive/Purge routine that is called by all modules within eBusiness Suite, instead each module has module specific archive/purge procedures.



Concurrent Jobs to purge data
Purge Obsolete Workflow Runtime Data (FNDWFPR)
Oracle Applications System Administrator’s Guide - Maintenance Release 11i (Part No. B13924-04)
Note 132254.1 Speeding up and Purging Workflow
Note 277124.1 FAQ on Purging Oracle Workflow Data
Note 337923.1 A closer examination of the Concurrent Program Purge Obsolete Workflow Runtime Data

Purge Debug Log and System Alerts (FNDLGPRG)
Note 332103.1 Purge Debug Log And System Alerts Performance Issues

Purge Signon Audit data (FNDSCPRG)
Note 1016344.102 What Tables Does the Purge Signon Audit Data Concurrent Program Affect?
Note 388088.1 How To Clear The Unsuccessful Logins

Purge Concurrent Request and/or Manager Data (FNDCPPUR)
Oracle Applications System Administrator’s Guide - Maintenance Release 11i (Part No. B13924-04)
Note 565942.1 Which Table Column And Timing Period Does The FNDCPPUR Purge Program Use
Note 104282.1 Concurrent Processing Tables and Purge Concurrent Request and/or Manager Data Program (FNDCPPUR)
Note 92333.1 How to Optimize the Process of Running Purge Concurrent Request and/or Manager Data (FNDCPPUR)

Delete Diagnostic Logs (DELDIAGLOG)
Note 466593.1 How To Delete Diagnostic Logs and Statistics?

Delete Diagnostic Statistics (DELDIAGSTAT)
Note 466593.1 How To Delete Diagnostic Logs and Statistics?

Purge FND_STATS History Records (FNDPGHST)
Oracle Applications System Administrator’s Guide - Configuration Release 11i (Part No. B13925-06)
Note 423177.1 Date Parameters For "Purge Fnd_stats History Records" Do Not Auto-Increment

Page Access Tracking Purge Data (PATPURGE)
Note 413795.1 Page Access Tracking Data Purge Concurrent Request Fails With Ora-942
Note 461897.1 Which Tables store the Page Access Tracking Data?
Note 402116.1 Page Access Tracking in Oracle Applications Release 12

Purge Obsolete Generic File Manager Data (FNDGFMPR)
Oracle Applications System Administrator’s Guide - Configuration Release 11i (Part No. B13925-06)
Note 298698.1 Avoiding abnormal growth of FND_LOBS table in Application
Note 555463.1 How to Purge Generic or Purchasing Attachments from the FND_LOBS Table

Summarize and Purge Concurrent Request Statistics (FNDCPCRS)
(no references found)

Purge Inactive Sessions (ICXDLTMP)
Note 397118.1 Where Is 'Delete Data From Temporary Table' Concurrent Program - ICXDLTMP.SQL

Purge Obsolete ECX Data (FNDECXPR)
Note 553711.1 Purge Obsolete Ecx Data Error ORA-06533: Subscript Beyond Count
Note 338523.1 Cannot Find ''Purge Obsolete Ecx Data'' Concurrent Request
Note 444524.1 About Oracle Applications Technology ATG_PF.H Rollup 6

Purge Rule Executions (FNDDWPURG)
(no references found)

Additional Notes
You can monitor and run purging programs through OAM by navigating to the Site Map--> Maintenence --> Purge section.

workflow

Applies to:
Oracle Workflow Cartridge - Version: 11.0 to 12.0
Information in this document applies to any platform.
Purge Obsolete Workflow Runtime Data FNDWFPR
Purpose
This note gives common question answers regarding workflow purge process.
This helps user to understand basic functionality of this process.


Questions and Answers
WHICH WORKFLOW TABLES DO I NEED TO CHECK?
Master workflow runtime table is WF_ITEMS.
All other runtime table records are associated to record in WF_ITEMS.
If records are purged in WF_ITEMS, records ar purged in all other workflow runtime tables.
Checking the workflow runtime table master table for progress purging is the same as check any other workflow runtime table.

This query will help you to determine volume of wf process classified by Status, item Type, and permanency.
select wi.item_type ITEM_TYPE,
wit.persistence_type P_TYPE,
decode (wi.end_date, NULL, 'OPEN', 'CLOSED') Status,
count(*) COUNT
from wf_items wi,
wf_item_types wit
where wit.name = wi.item_type
group by item_type,
wit.persistence_type,
WIT.PERSISTENCE_DAYS,
decode (wi.end_date, NULL, 'OPEN', 'CLOSED')
order by decode (wi.end_date, NULL, 'OPEN', 'CLOSED'), 4 desc;
When workflow processes are not closed and purged, these workflow runtime tables could growth exponentially:

WF_ITEM_ATTRIBUTE_VALUES
WF_ITEM_ACTIVITY_STATUSES
WF_NOTIFICATION_ATTRIBUTES


Records in these tables are purged only if the records in wf master table, WF_ITEMS, qualifies to be purged.

These queries give the volumen of data in the tables.

select count(*) from WF_ITEM_ATTRIBUTE_VALUES;
select count(*) from WF_ITEM_ACTIVITY_STATUSES;
select count(*) from WF_NOTIFICATION_ATTRIBUTES;


The above Workflow tables contain data which is used for Workflow background processing. If these tables grow too large the Workflow performance level becomes slower. You should be purging these tables should be purged on a regular basis.

References
Also, check the Note 165316.1-'bde_wf_data.sql - Query Workflow Runtime Data That Is Eligible For Purging'


WHAT ARE THE APIs PROVIDED FOR PURGING WORKFLOW DATA?
WF_PURGE is the database defined package which contain the APIs to purge workflow runtime tables. There are also APIs to purge not runtime data like workflow directory services data. Workflow design data, tables where wfprocess definitions are stored is also not runtime data.

The most commonly used procedures are:
Wf_Purge.Items :

Purge all runtime date associated with completed items, their processes, and
notifications sent by them.
Deletes from the tables: WF_NOTIFICATIONS, WF_ITEM_ACTIVITY_STATUSES,
WF_ITEM_ATTRIBUTE_VALUES AND WF_ITEMS/
Parameters:

itemtype : Item type to delete, or null for all itemtypes
itemkey : Item key to delete, or null for all itemkeys
enddate : Purges wf processes closed after this date
force : Forces to purge closed wf processes even if it has wf slibing
processes open.
docommit : TRUE does commit, FALSE deleted but does not commit.


Wf_Purge.Activities :

Purges wf process definition versions that are not used and that are obsolete.
Deletes from tables:
WF_ACTIVITY_ATTR_VALUES,
WF_ACTIVITY_TRANSITIONS,
WF_PROCESS_ACTIVITIES,
WF_ACTIVITY_ATTRIBUTES_TL,
WF_ACTIVITY_ATTRIBUTES,
WF_ACTIVITIES_TL and
WF_ACTIVITIES that are associated with the specified item type,
have an END_DATE less than or equal to the specified end date and
are not referenced by an existing item as either a process or activity.


Wf_Purge.Total : Purge both item data and activity data.

Wf_Purge.AdHocDirectory :

Purge users and roles in the WF_LOCAL_* tables
whose expiration date has elapsed and that are not referenced in any notification.


Note:

The WF_PURGE_APIS only purge data associated with Temporary item type whose
persistence, in days, has expired. A persistence type PL/SQL variable is set
to 'TEMP' (Temporary) by default and should not be changed. Use the WF_PURGE.
TotalPERM API to delete all eligible obsolete runtime data associated with
item types of with a persistence type of 'Permanent'.

WHAT PARAMETERS DO I PASS TO THE PURGE APIs?
Many of the Purge APIs accept the following parameters:

Item Type: The item type associated with the obsolete runtime data you want to delete. Leave this parameter null to delete obsolete data for all item types
Item Key: A string generated from the application object's primary key. The string uniquely identifies the item within an item type. Leave this parameter null to purge all items in the specified item type.
End Date: A specified date to delete up to.



WHICH CONCURRENT PROGRAM DO I NEED TO USE FOR PURGING?
Answer
------
In Oracle E-Business Suite, use the concurrent program 'Purge Obsolete Workflow
Runtime Data' (short name FNDWFPR) which calls database package WF_Purge.Total.

This program deletes old Workflow runtime data for completed Workflows.
It is recommended that this program or package is run regularly as required.


WHAT ARE THE PARAMETER VALUES TO DEFINE TO RUN 'Purge Obsolete Workflow Runtime Data' CONCURRENT PROGRAM?



Item Type : The item type to purge. Leaving this field blank defaults to purging the runtime data for all item types.
Item Key : The item key to purge. Leaving is field blank defaults to purging the runtime data for all item keys.
Age : Minimum age of data to purge, in days.
Persistence Type : The persistence type tbe purged, either ’TEMP’ for Temporary or ’PERM’ for Permanent. The default TEMP’.
Runtime data : Yes, will purge only wf runtime data Runtime data defined No, will purge wf runtime data and wf design data, wf process definitions.
WHERE IS THE OFFICIAL DOCUMENTATION AVAILABLE?Answer
Important Workflow documentation can be found in the Online Documentation library which resides in Oracle Technology Network. There are links to the OTN Online documents in the MetaLink 'Knowledge' tab.

Oracle Workflow Administrator's Guide 2.6.3 (PDF, 1183 Kb) Part number B10283-01
Oracle Workflow API Reference 2.6.3 (PDF, 860 Kb) Part number B10286-01
Oracle Workflow Developer's Guide 2.6.3 (PDF, 427 9Kb) Part number B10284-01
Oracle Workflow User's Guide 2.6.3 (PDF, 820 Kb) Part number B10285-01
Oracle Workflow Web Services Guide 2.6.3 (PDF, 100 Kb) Part number B10624-01
References
NOTE:132254.1 - Speeding Up And Purging Workflow
NOTE:141853.1 - Workflow Performance is Very Slow And Workflow Background Tables Are Large
NOTE:144806.1 - A Detailed Approach To Purging Oracle Workflow Runtime Data
NOTE:165316.1 - bde_wf_data.sql - Query Workflow Runtime Data That Is Eligible For Purging

Speeding up and Purging Workflow

Speeding up and Purging Workflow

Andy Tremayne and Steve Mayze
An enhanced extract from The Oracle Applications Tuning Handbook ISBN 0-07-212549-7

Updated patch list and script notes on 14/02/2002
Added patch reference 2561517 on 17/01/2003
Added patch reference 2755885 on 08/04/2003

Contents:

Performance Profile Options
Performance Patches and Histograms
Purging Workflow Data
Investigative Queries
Dealing with Workflow errors
Scripts to create Histograms

--------------------------------------------------------------------------------

Performance Profile Options
Some products of Oracle Applications have utilized the internal features of Oracle Workflow and brought them to the surface as configurable application profile options. Two profile options have historically affected performance:

Account Generator: Run in Debug Mode
Purchasing: Workflow Processing Mode
Account Generator: Run in Debug Mode
This controls the Forced Synchronous mode of the Workflow Engine. Always ensure that this is switched off unless you are trying to debug the output. The two settings are as follows:
Yes The Account Generator workflows runs in audit mode and status information is saved to the Workflow history tables.
No The Account Generator workflows run in non-audit mode and no status information is saved, therefore increasing performance and reducing the wait time when generating an account.

Purchasing: Workflow Processing Mode
This profile option can be set to Online or Background:

Online The Workflow Engine will run the Purchase Order and Requisition workflows online when transactions are created.
Background This causes the purchase order and requisition workflows to be deferred to the Background Engine. This can increase throughput; but before setting this value, ensure that you have configured at least one Background Engine and that it is running.

--------------------------------------------------------------------------------

Performance Patches and Histograms
Patch 2755885 program loops and child worklow processes are not purged when the parent process are still active
Patch 2561517 contains a performance update to 2136244, which addresses stuck processes.
Patch 1661521 changes literals to bind arguments for the HandleSenderror and setContext procedures
Patch 2070056 relates directly to purging performance
Patch 1953214 relates to performance in the Find Notifications screen
Patch 1384537 relates to purge rollback issues and commits after each purged item

Patch 1508871 for workflow includes a number of fixes that target performance (fixed 11.5.5)
Bug 1659212 discusses checking a number of workflow histograms and if necessary running the scripts below to create them and populate the corresponding statistics.

Check/create a histogram for ACTIVITY_STATUS in WF_ITEM_ACTIVITY_STATUSES
Check/create a histogram for MAIL_STATUS and STATUS in WF_NOTIFICATIONS
Scripts to create histograms can be found at the bottom of this note.


--------------------------------------------------------------------------------

Purging Workflow Data

Purging Run-Time Information

When the engine executes any type of workflow other than Forced Synchronous, status information is stored into the Workflow history tables. Over time, this can amount to many thousands of rows; the growth of these tables depend on the complexity of the workflows and how often they are used.

The problems associated with large volumes of data can be avoided by regularly purging run-time information. There are two types of information:

Design time information This is the workflow definition information that was created within the Oracle Workflow Builder.
Run-time information This includes the status history, Item Attribute values, and notifications that are created during the execution of a workflow process.
Managing the volume of information is performed using Workflow Purge APIs. They only operate on obsolete run-time information, leaving all design-time information intact. Administration scripts are provided to operate on both run-time and design-time information. Both APIs and scripts are discussed in the following sections.
Workflow Purge APIs

The Purge APIs are a set of procedures contained in the WF_PURGE package. Table 14-1 lists some of the procedures available and the parameters that they accept, which control the amount of data to purge. In their simplest form, the purge procedures can be run with no parameters at all. For example, to purge both item and activity data for completed workflow processes use the following:

execute wf_purge.total;

The concept of workflow persistence was introduced in Oracle Workflow 2.5. The Persistence Type controls how long a status audit trail is maintained for each instance of the Item Type. The three types of persistence are Permanent, Temporary, and Synchronous. Synchronous, when run with no auditing, does not have any history information. The history information for workflows marked as Permanent can only be removed by WF_PURGE.TOTALPERM; the history information for workflows marked as Temporary is removed by WF_PURGE.TOTAL. For best performance, run WF_PURGE.TOTAL frequently, and WF_PURGE.TOTALPERM periodically, but be aware of your site’s policy on status history retention. Further details can be found in the Oracle Workflow User Guide.

Procedure Parameters Description
WF_PURGE.ITEMS Itemtype
Itemkey
Enddate Removes all run-time data associated with completed items.
WF_PURGE.ACTIVITIES Itemtype
Enddate Removes obsolete activities versions. These are versions of activities that are no longer used by any item.
WF_PURGE.NOTIFICATIONS Itemtype
Enddate Removes old notifications. These are notifications that are no longer used by any item.
WF_PURGE.TOTAL Itemtype
Itemkey
Enddate Purges both item and activity data.
WF_PURGE.TOTALPERM Itemtype
Itemkey
Enddate Deletes all eligible obsolete run-time data that has a persistence type of Permanent.
WF_PURGE.ADHOCDIRECTORY Enddate Purges all ad hoc users and roles that are not associated with a notification.


Table 1: WF_PURGE Procedures

Using the Generric Purge Procedures

You can run execute WF_PURGE.TOTAL from the SQL command prompt. This will not delete anything in process or active. However you should also run execute WF_PURGE.TOTALPERM which will delete any items with a persistence type of permanent and execute WF_PURGE.NOTIFICATIONS.

Note: If you run into problems such as running out of rollback, you will need to purge by item type or something else to limit the amount of data (committing between each iteration). .

Standard Purge Scripts

These scripts remove not only run-time data, but also Item Type and workflow definition information. Table 14-2 lists and describes some of the available scripts. Carefully consider the impact of running these scripts, as purging run-time information for incomplete workflow processes may result in the underlying application being placed into an unstable state. Any transactions that are incomplete when the process has been removed may not be able to be completed.

Caution: Extreme care should be taken when using these scripts!
Script Parameters Description
$FND_TOP/sql/wfrmitms.sql
$ORACLE_HOME/admin sql/wfrmitms.sql Itemtype
Itemkey Removes the status information for a specified Item Type and Item Key
$FND_TOP/sql/wfrmtype.sql
$ORACLE_HOME/admin /sql/wfrmtype.sql None - You will be prompted Purges all run-time information for a given item type

Table 2: Workflow Purge Scripts



--------------------------------------------------------------------------------

Investigative Queries
The main tables of concern when dealing with workflows are WF_ITEM_ACTIVITY_STATUS and WF_ITEM_ATTRIBUTE_VALUES. The SQL statements below will help analyze their contents.

select item_type,activity_status,count(*)
from wf_item_activity_statuses
group by item_type,activity_status
ITEM_TYP ACTIVITY COUNT(*)
-------- -------- ----------
INVTROAP COMPLETE 8
WFERROR COMPLETE 413298
INVTROAP DEFERRED 1
CREATEPO ERROR 5
An understanding of WFERROR will help define what needs to happen next:

ACTIVE Nobody has reviewed these yet
COMPLETE Someone has responded to the error notification with abort/retry/ignore. These are complete and should
be purged.
ERROR The error process is in error. This usually happens on new sites where the configuration is incomplete. For example, an error process notification was sent to non-existent person. Reviewing the error stack should tell you what the problem is.
NOTIFIED A workflow exception has been raised and the wferror process started. There will be an unactioned notification somewhere on the system.


select item_type,count(*)
from wf_item_attribute_values
group by item_type

ITEM_TYP COUNT(*)
-------- ----------
APEXP 4490
AZNF003 5
AZNF004 5
AZNF005 5
CREATEPO 360
ECO_APP 35
If there are a lot of rows to be purged, you will risk running of out of rollback. One way of reducing the amount of data is to use this second query to purge by ITEM_TYPE. If you still experience problems, then you can restrict the amount of data further using a date range. Alternatively apply patch 1384537


--------------------------------------------------------------------------------

Dealing With Workflow Errors
In order to address the errors, go in through the Workflow Web agent as SYSADMIN, view the waiting notifications on these errors and review their content. They will contain why the WFERROR process was fired off. You can take the appropriate action from those notifications. Abort, retry, ignore.

Working with large numbers of Errors

If you have a huge number of errors then you could use the SQL queries above to speed up your analysis rather than reviewing each record. Consider using the wfretry.sql script to restart the processes from SQL*Plus. Note that it is not a good idea to go through and abort all of these error'd processes as they could be active legitimate workflows that are pending within the application. Only if you are happy that all of the error'd processes can be deleted then you could consider using the wf_engine.abortProcessAPI. Again, use extreme caution when manipulating data this way.



--------------------------------------------------------------------------------

Scripts to create Histograms and gather statistics
Bug 1659212 discusses checking a number of workflow histograms and if necessary running the scripts below to create them and populate the corresponding statistics.

Check/create a histogram for ACTIVITY_STATUS in WF_ITEM_ACTIVITY_STATUSES
Check/create a histogram for MAIL_STATUS and STATUS in WF_NOTIFICATIONS
REM histogram.sql
REM Create histogram for ACTIVITY_STATUS in WF_ITEM_ACTIVITY_STATUSES
REM for bug 1417941
REM
prompt 'Enter FND schema name e.g. APPLSYS'
def fnd_schema = '&&1'
.
WHENEVER SQLERROR EXIT FAILURE ROLLBACK;
.
begin
FND_STATS.LOAD_HISTOGRAM_COLS(
action=>'INSERT'
,appl_id=>0
,tabname=>'WF_ITEM_ACTIVITY_STATUSES'
,colname=>'ACTIVITY_STATUS'
);
.
FND_STATS.GATHER_TABLE_STATS(
ownname=>'&fnd_schema'
,tabname=>'WF_ITEM_ACTIVITY_STATUSES'
);
.
end;
/
.
commit;
REM hist_notif.sql
REM Create histogram for MAIL_STATUS and STATUS in WF_NOTIFICATIONS
REM for bug 1563380
prompt 'Enter FND schema name e.g. APPLSYS'
def fnd_schema = '&&1'
.
WHENEVER SQLERROR EXIT FAILURE ROLLBACK;
.
begin
FND_STATS.LOAD_HISTOGRAM_COLS(
action=>'INSERT'
,appl_id=>0
,tabname=>'WF_NOTIFICATIONS'
,colname=>'MAIL_STATUS'
);
.
FND_STATS.LOAD_HISTOGRAM_COLS(
action=>'INSERT'
,appl_id=>0
,tabname=>'WF_NOTIFICATIONS'
,colname=>'STATUS'
);
.
FND_STATS.GATHER_TABLE_STATS(
ownname=>'&fnd_schema'
,tabname=>'WF_NOTIFICATIONS'
);
.
end;
/
.
commit;

Important metalink link notes for dbas

NOTE.74660.1 : Resolving Invalid Objects in Oracle Applications
NOTE.338879.1 : Landscape1309 - Linux Landscape Quick Reference
NOTE.341782.1 : Linux Quick Reference
NOTE.312572.1 : About Oracle Applications Technology Updates for Release 11.
NOTE.316806.1 : Oracle Applications Installation Update Notes, Release 11i
NOTE.370274.1 : New Features in Oracle Application 11i
NOTE.275734.1 : India Localization
NOTE.47837.1 : Applications Utilities FAQ
NOTE.189487.1 : System Administration FAQ's
NOTE.289786.1 : Installing Oracle Applications: A Guide to Using Rapid
NOTE.245079.1 : Steps to clone a 11i RAC environment to a non-RAC
NOTE.243693.1 : Rapid Clone Coredumps when Running Adcfgclone.pl
NOTE.231701.1 : How to Find Patching History (10.7, 11.0, 11i)
NOTE.139684.1 : Oracle Applications Current Patchset Comparison Utility -
NOTE.331746.1 : Oracle Accelerator FAQ for Global Product Support (Internal
NOTE.144751.1 : Applications Patching - Time Saving Techniques
NOTE.232833.1 : Oracle Applications Release Notes, Release 11i (11.5.9)
NOTE.110372.1 : 11i: How to Clean up the UNIX Environment After Install
NOTE.156219.1 : Net8i/9i Basic configuration of LISTENER.ORA and TNSNAMES.
NOTE.69725.1 : Configuring TNSNAMES.ORA, SQLNET.ORA,and LISTENER.ORA in
NOTE.356878.1 : How to relink the whole Applications 11i Installation
NOTE.233428.1 : Sharing the Application Tier File System in Oracle
NOTE.130686.1 : How to Generate Form, Library and Menu for Oracle
NOTE.246105.1 : Upgrading to J2SE 1.4.2 with Oracle Applications 11i
NOTE.139949.1 : NEED TO CLEAR APACHE, BROWSER OR JINITIATOR CACHE FOR
NOTE.133972.1 : How to Reset the APPS and APPLSYS Passwords in Release 11.5
NOTE.216980.1 : FNDLOAD Fails with PLS-306 in call to LOAD_ROW
NOTE.333785.1 : Oracle Applications Internationalization Guide
NOTE.222663.1 : Internationalization Update Notes for the Oracle E-Business Suite 11i
NOTE.372952.1 : Customer Translations
NOTE.168330.1 : Reload Applications Related Java Objects
NOTE.287176.1 : DMZ Configuration with Oracle E-Business Suite 11i
NOTE.233436.1 : Installing Oracle Application Server 10g with Oracle E-
NOTE.231701.1 : How to Find Patching History (10.7, 11.0, 11i)
NOTE.139684.1 : Oracle Applications Current Patchset Comparison Utility -
NOTE.238276.1 : Migrating to Linux with Oracle Applications Release 11i
NOTE.242480.1 : Using a Staged Applications 11i System to Reduce Patching
NOTE.1076329.6 : SQL*Plus Errors - SP1.MSB Not Found
NOTE.248857.1 : Oracle Applications Tablespace Model Release 11i -
NOTE.269293.1 : Oracle Applications Tablespace Model FAQs
NOTE.258330.1 : About Oracle Applications Manager Minipack 11i.OAM.H
NOTE.268837.1 : Gathering Debug Weboam Log
NOTE.342332.1 : Troubleshooting Login Problems in Oracle Applications 11i
NOTE.112577.1 : How to customize reports at runtime using XML - simple
NOTE.144689.1 : How to Generate a Report (.rdf) File from the UNIX Command
NOTE.211424.1 : How to Enable a Large SGA(over 1.7GB) on RedHat Advanced
NOTE.345145.1 : Is There A Way To Automate The Prompts For Adcfgclone.Pl?
NOTE.1812.1 : TECH : Getting a Stack Trace from a CORE file
NOTE.144599.1 : How to Generate a .pll Library File for Applications 11i
NOTE.282038.1 : Oracle Applications Release 11i with Oracle Database 10g
NOTE.208375.1 : How To Convert A Single Instance Database To RAC In A
NOTE.279956.1 : Oracle E-Business Suite Release 11i with 9i RAC :
NOTE.312731.1 : Configuring Oracle Applications Release 11i with 10g RAC
NOTE.362135.1 : Configuring Oracle Applications Release 11i with 10g R2 RAC
NOTE.1067473.6 : Custom Forms do not Show up in FNDSCMON Form
NOTE.232834.1 : Oracle Applications Release 11.5.9 Maintenance Pack
NOTE.216550.1 : Oracle Applications Release 11i with Oracle9i Release 2 (9.
NOTE.362203.1 : Oracle Applications Release 11i with Oracle 10g Release 2 (10.2.0)
NOTE.233038.1 : AD Command Line Options
NOTE.186125.1 : Applications 11i and Standby Databases
NOTE.260887.1 : Steps to Clean Nonexistent Nodes or IP Addresses from
NOTE.342459.1 : Diagnostics Overview
NOTE.394615.1 : Adaddnode.Pl failed with : ORA-00001 : unique constraint
NOTE.338003.1 : How to change the hostname and/or port of the Database Tier
NOTE.341322.1 : How to change the hostname of an Applications Tier using AutoConfig
NOTE.333785.1 : Oracle Applications Internationalization Guide
NOTE.211708.1 : Detailed Explanations of How NLS/MLS is Being Handled in 11i
NOTE.73352.1 : NLS/MLS Frequently Asked Questions
NOTE.72324.1 : Guidelines on Resolving NLS/MLS issues
NOTE.316365.1 : Oracle Applications Release 11.5.10.2 Maintenance Pack
NOTE.230627.1 : 9i Export/Import Process for Oracle Applications Release 11i
NOTE.331221.1 : 10g Export/Import Process for Oracle Applications Release 11i
NOTE.362205.1 : 10g Release 2 Export/Import Process for Oracle Applications Release 11i
NOTE.259552.1 : 11.5.9 Category 3 Preupgrade Instructions for 9.2.0.4
NOTE.341281.1 : How to disable the language selection option available in AppsLocalLogin.jsp
NOTE.389472.1 : OATM Migration fails with ORA-22853 for LOB objects
NOTE.174605.1 : bde_chk_cbo.sql - Reports Database Initialization
NOTE.333785.1 : Oracle Applications Internationalization Guide
NOTE.124721.1 : Migrating an Applications Installation to a New Character
NOTE.66320.1 : Changing the Database Character Set or the Database
NOTE.119164.1 : Changing Database Character Set - Valid Superset Definitions
NOTE.123670.1 : Use Scanner Utility before Altering the Database Character
NOTE.213015.1 : SYS.METASTYLESHEET marked as having convertible data (ORA-
NOTE.258895.1 : SYS.RULE$ marked as having convertible data (ORA-12716 when
NOTE.258902.1 : SYS.JOB$ marked as having convertible data
NOTE.43208.1 : Certified Compilers
NOTE.270806.1 : 11.5.9 : Invalid Objects - IES Java Classes
NOTE.165114.1 : Resolving Invalid Java Classes in Oracle Applications
NOTE.343253.1 : Tns-12555, Tns-12560, Tns-00525, Linux Error : 1 Starting
NOTE.150168.1 : Obtaining Forms Runtime Diagnostics (FRD) In Oracle
NOTE.210193.1 : Use of Multiple Organizations In Oracle Applications
NOTE.165035.1 : Current Issues - Multiple Organizations Architecture
NOTE.208267.1 : Improved Convert to Multi-Org Process In Oracle
NOTE.226456.1 : Multiple Organizations in Oracle Applications R11i, March
NOTE.259546.1 : Setting Up Multiple Organizations in Oracle HRMS
NOTE.131081.1 : How can I find which version of Portal I am running ?
NOTE.262125.1 : Sun.io.MalformedInputException For OraSCV.asc,emreadme.txt,
NOTE.216205.1 : Database Initialization Parameters for Oracle Applications
NOTE.213015.1 : SYS.METASTYLESHEET marked as having convertible data (ORA-
NOTE.283225.1 : How to Recreate the Listener for Event and Listener for
NOTE.153960.1 : FAQ : X Server testing and troubleshooting
NOTE.146468.1 : Installing and Upgrading Oracle9i Application Server with
NOTE.233428.1 : Sharing the Application Tier File System in Oracle
NOTE.351283.1 : Interoperability Notes : Oracle Applications Release 11i
NOTE.287453.1 : Oracle Applications 11.5.10 - Installation Update Notes for
NOTE.317226.1 : Concurrent Managers Do Not Start With GSM Profile Option
NOTE.311015.1 : Adgendbc.sh Errors Running AutoConfig
NOTE.337937.1 : Step By Step - 10gR2 RAC with ASM install on Linux(x86) -
NOTE.266043.1 : Support of Linux and Oracle Products on Linux
NOTE.224302.1 : Raw Devices on Linux
NOTE.134395.1 : Cannot Connect to Personal Home Page : Your Session is no
NOTE.351646.1 : Configuring Oracle E-Business Suite Release 11i with 10g
NOTE.230688.1 : Basic ApacheJServ Troubleshooting with IsItWorking.class
NOTE.70276.1 : HOW TO INTEGRATE APPLICATIONS RELEASE 11 WITH CUSTOM
NOTE.273449.1 : Diagnosing Login Problems with Apps 11.5.9 (FND.G)
NOTE.139863.1 : Configuring and Troubleshooting the Self Service Framework
NOTE.342332.1 : Troubleshooting Login Problems in Oracle Applications 11i
NOTE.233428.1 : Sharing the Application Tier File System in Oracle
NOTE.252422.1 : Requesting Translation Synchronization Patches
NOTE.287176.1 : DMZ Configuration with Oracle E-Business Suite 11i
NOTE.68713.1 : Troubleshooting Self-Service Web Applications Login
NOTE.304489.1 : Using Oracle Applications with a Split Configuration
NOTE.225074.1 : 11i AOL : Cannot login to PHP after DB upgrade to 9.2.0.2
NOTE.358140.1 : Troubleshooting Unix coredumps and obtaining stack traces
NOTE.1007808.6 : HOW TO HANDLE CORE DUMPS ON UNIX
NOTE.1812.1 :
NOTE.169706.1 : Oracle Database on AIX,HP-UX,Linux,MacOSX,Solaris,Tru64
NOTE.197031.1 : 32-bit/64-bit Certification/Conversion Issues on Oracle
NOTE.300172.1 : Obsolescence of KOREAN_LEXER Lexer Type
NOTE.225456.1 : Troubleshooting Guide for Cloning Issues
NOTE.161474.1 : Oracle Applications Remote Diagnostics Agent (APPS_RDA)
NOTE.111383.1 : The Basics About Report Review Agent (FNDFS) on 11i
NOTE.210062.1 : Generic Service Management (GSM) in Oracle Applications 11i
NOTE.316447.1 : About Oracle XML Publisher Release 5.5
NOTE.295036.1 : About XML Publisher Release 5.0
NOTE.130091.1 : Upgrading Oracle Applications 11i to use JDK 1.3
NOTE.292424.1 : Cleaning your Windows System After a Failed Oracle
NOTE.124606.1 : Upgrading JInitiator with Oracle Applications 11i
NOTE.316806.1 : Oracle Applications Installation Update Notes, Release 11i
NOTE.177183.1 : Succesfully Installing NLS/MLS in 11i
NOTE.134007.1 : CMCLEAN.SQL - Non Destructive Script to Clean Concurrent Manager Tables
NOTE.1010501.7 : FAQ : Licensing and de-licensing a product, country-specific
NOTE.217368.1 : Advanced Configurations and Topologies for Enterprise
NOTE.287176.1 : DMZ Configuration with Oracle E-Business Suite 11i
NOTE.302738.1 : Using Virtual Hostnames with Oracle Applications Release 11i
NOTE.403311.1 : United States Time Zone Changes 2007 : E-Business Suite
NOTE.333785.1 : Oracle Applications Internationalization Guide
NOTE.232313.1 : Information on Previous Versions of Developer 6i Patchsets
NOTE.240862.1 : Install Oracle Unicode Fonts for Dynamic Image Generation
NOTE.60966.1 : Getting Rid Of Those Pesky Invalid Objects In Oracle
NOTE.400830.1 : How to Render Non ASCII Characters in Personalized
NOTE.285218.1 : Recommended Browsers for Oracle Applications 11i
NOTE.403311.1 : United States & Canada 2007 Daylight Saving Time (DST)
NOTE.289788.1 : Upgrading Oracle Applications
NOTE.316804.1 : Oracle Applications NLS Release Notes, Release 11i (11.5.10.
NOTE.189867.1 : Troubleshooting FRM-92050, FRM-92100, FRM-92101, FRM-92102
NOTE.253763.1 : After Cloning on Target instance FRM-92050 Failed to
NOTE.274783.1 :

Amol's Bookmark
*********************************************************************
NOTE.167000.1 : eBusiness Suite Support - Oracle Diagnostics Support Pack
NOTE.235307.1 : OSS Application Diagnostics Tools : FAQ and Troubleshooting
NOTE.231142.1 : About Oracle Diagnostics version 2.1
NOTE.262006.1 : About Oracle Diagnostics 2.2
NOTE.300976.1 : Support Diagnostics Newsletter for Applications Core
NOTE.357223.1 : "This test can be executed only after logging into
NOTE.363759.1 : How To Add Diagnostic Tools To Responsibility Menu

Installation
*********

NOTE.215868.1 : 11i Release Notes
NOTE.77219.1 : Applications Release 11.0.3 One-Hour Install for Unix
NOTE.287453.1 : Oracle Applications 11.5.10 - Installation Update Notes for
NOTE.292424.1 : Cleaning your Windows System After a Failed Oracle
NOTE.110372.1 : 11i : How to Clean up the UNIX Environment After Install
NOTE.169402.1 : How To Cleanup After A Failed Applications Installation On
NOTE.48602.1 : How do I determine which products are fully installed, and
NOTE.124353.1 : WIN : Manually Removing all Oracle Components on Microsoft
NOTE.275493.1 : Removing 10g Database and Software from AIX, HP-UX, Linux,
NOTE.279519.1 : How to completely remove 8i / 9i Database and Software from
NOTE.232831.1. : Oracle Applications NLS Release Notes 11.5.9 - B10846-01
NOTE.287453.1 : Oracle Applications 11.5.10 - Installation Update Notes for
NOTE.187240.1 : Applications AOL Scenarios : Is It Supported ?
NOTE.287453.1 : Oracle Applications 11.5.10 - Installation Update Notes for
NOTE.316806.1 : Oracle Applications Installation Update Notes, Rel 11.5.10.2
NOTE.360079.1 : Global and Local Inventory explained
NOTE.295185.1 : How to Recreate the Global oraInventory
NOTE.197028.1 : Software Requirements and Tools for Oracle Applications
NOTE.201392.1 : Visual C++ Requirement for Release 11i on Windows
NOTE.268776.1 : GNU Make Requirement for Release 11i For Windows
NOTE.181244.1 : Configuring VNC Or XVFB As The X Server For Applications 11i
NOTE.153960.1 : FAQ : X Server testing and troubleshooting

Patching
*******

NOTE.174436.1 : Oracle Applications Patching FAQ
NOTE.175485.1 : How to Apply an 11i Patch When adpatch is Already Running
NOTE.231701.1 : How to Find Patching History (10.7, 11.0, 11i)
NOTE.252422.1 : Requesting Translation Synchronization Patches in Release
NOTE.316366.1 : 11.5.10 Oracle E-Business Suite Consolidated Update 2 (CU2)
NOTE.259484.1 : Release 11.5.10 Maintenance Pack Installation Instructions
NOTE.316365.1 : Oracle Applications Release 11.5.10.2 Maintenance Pack
NOTE.139684.1 : Oracle Applications Current Patchset Comparison Utility -
NOTE.181665.1 : Release 11i Adpatch Basics
NOTE.358247.1 : ORA-00001 : unique constraint violated error while applying
NOTE.358417.1 : Unable to Start Concurrent Managers After Applying 11i.
NOTE.353414.1 : Application Technology Group (ATG) Patching Policy
NOTE.359198.1 : XDF files fail to load on HP-UX, Memory Fault(Coredump)
NOTE.232834.1 : Oracle Applications Release 11.5.9 Maintenance Pack
NOTE.337274.1 : About Oracle Applications Technology 11i.ATG_PF.H Rollup 3
NOTE.244040.1 : Oracle E-Business Suite Recommended Performance Patches
NOTE.367756.1 : Uploading Java Objects To Patch History Tables Fails While
NOTE.76708.1 : Using ADSPLICE To Add Products To The APPL_TOP In

Cloning
******

NOTE.230672.1 : Cloning Oracle Applications Release 11i with Rapid Clone
NOTE.216664.1 : FAQ : Cloning Oracle Applications Release 11i
NOTE.242123.1 : Create new middle tier node in existing Apps 11i
NOTE.238276.1 : Migrating to Linux with Oracle Applications Release 11i
NOTE.364565.1 : Troubleshoot RapidClone or OAM Clone issues

Upgrade
*******

NOTE.200963.1 : R11.5.3/R11.5.4/R11.5.5 Upgrade And Install Issues
NOTE.289765.1 : Oracle Applications Release 11i (11.5.10) Upgrade Assistant
NOTE.289788.1 : Upgrading Oracle Applications

Autoconfig
**********

NOTE.165195.1 : Using AutoConfig to Manage System Configurations with
NOTE.218089.1 : Autoconfig FAQ
NOTE.270519.1 : Customizing an AutoConfig Environment
NOTE.260887.1 : Steps to Clean Nonexistent Nodes or IP Addresses from
NOTE.341322.1 : How to change the hostname of an Applications Tier using
NOTE.338003.1 : How to change the hostname and/or port of the Database Tier
NOTE.108865.1 : How To Create a Database Connection(DBC) File and

AD Utilities
**********

NOTE.233038.1 : AD Command Line Options

Relinking
********

NOTE.69798.1 : Basics of Relinking an Executable or Binary in an Oracle
NOTE.1009722.6 : How to relink Oracle Concurrent Program Executables on Unix

OAM
****

NOTE.210062.1 : Generic Service Management (GSM) in Oracle Applications 11i
NOTE.117264.1 : FAQ (Oracle Applications Manager)
NOTE.177089.1 : OAM11i Standalone Mode Setup and Configuration
NOTE.214962.1 : How To Determine The Version Of OAM (Oracle Application
NOTE.258330.1 : About Oracle Applications Manager Minipack 11i.OAM.H
NOTE.166115.1 : Oracle Applications Manager 11i integrated with Oracle
NOTE.185431.1 : Troubleshooting Oracle Applications Manager OAM 2.0 for 11i
NOTE.73959.1 : Installation and Configuration of Oracle Application Manager
NOTE.225024.1 : Oracle Applications Manager 11i Documentation Roadmap
NOTE.338317.1 : Basic Information on Cloning An 11.5.10 System Using OAM

NLS/MLS
*******

NOTE.15389.1 : NLS DEBUGGING SUCCESS GUIDE ** INTERNAL ONLY **
NOTE.227332.1 : NLS considerations in Import/Export - Frequently Asked
NOTE.15095.1 : Export/Import and NLS Considerations
NOTE.175300.1 : A Guide to Debugging Globalization (NLS) Support Issues
NOTE.124721.1 : Migrating an Applications Installation to a New Character

Forms
*****

NOTE.130686.1 : How to Generate Form, Library and Menu for Oracle
NOTE.177610.1 : Oracle Forms in Applications FAQ
NOTE.141012.1 : How to Manually Generate an 11.5 Form on Unix

Apps Database
*************

NOTE.174605.1 : bde_chk_cbo.sql - Reports Database Initialization
NOTE.186125.1 : Applications 11i and Standby Databases
NOTE.248857.1 : Oracle Applications Tablespace Model Release 11i -
NOTE.216205.1 : Database Initialization Parameters for Oracle Applications
NOTE.285267.1 : Oracle E-Business Suite 11i and Database FAQ
NOTE.230627.1 : 9i Export/Import Process for Oracle Applications Release 11i
NOTE.183078.1 : Recreating Applications 11i JAVA objects in the database
NOTE.216212.1 : Business Continuity for Oracle Applications Release 11i,
NOTE.282038.1 : Oracle Applications Release 11i with Oracle Database 10g
NOTE.340859.1 : Upgrading Oracle Applications 11i Database to 10g with
NOTE.174605.1 : bde_chk_cbo.sql - Reports Database Initialization
NOTE.216211.1. : Nologging in the E-Business Suite
NOTE.282038.1 : Oracle Applications Release 11i with Oracle Database 10g

RAC / Apps RAC
**************

NOTE.220970.1 : RAC : Frequently Asked Questions
NOTE.312731.1 : Configuring Oracle Applications Release 11i with 10g RAC
NOTE.270901.1 : How to Dynamically Add a New Node to an Existing 9.2.0 RAC
NOTE.294652.1 : E-Business Suite 11i on RAC : Configuring Database Load balancing & Failover
NOTE.312731.1 : Configuring Oracle Applications Release 11i with 10g RAC
NOTE.279956.1 : Oracle E-Business Suite Release 11i with 9i RAC :
NOTE.277825.1 : How to setup Tnsnames.ora (806) for 11i and RAC

Database
********

NOTE.1012933.6 : General Information : Alert Logs and Trace Files
NOTE.209870.1 : How to Reload the JVM in 9.2.0.X
NOTE.175472.1 : How to Reload the JVM in 8.1.7.X
NOTE.159143.1 : Separating Multiple 8i or 9i Oracle Versions to Avoid
NOTE.307349.1 : OUI tips for Oracle RDBMS 10.1.X on OpenVMS
NOTE.130814.1 : How to move LOB Data to Another Tablespace

System Administration
*******************

NOTE.189457.1 : Oracle Applications Systems Administration Setup and Usage
NOTE.290525.1 : Oracle User Management FAQ
NOTE.316277.1 : Unable To Change Guest User Password In Oracle Applications
NOTE.311552.1 : How to optimize the purge process in a high transaction
NOTE.154850.1 : How to Run the Purge Concurrent Request and/or Manager Data

Jserver
******

NOTE.295484.1 : Clear Server Cache and Bounce Apache (Web Server)
NOTE.220188.1 : Oracle Applications Release 11i apps.zip Re-architect
NOTE.230688.1 : Basic ApacheJServ Troubleshooting with IsItWorking.class

Invalid Objects
*************

NOTE.60558.1 : Troubleshooting the Source of Invalid Objects
NOTE.266910.1 : How To Resolve IES Invalid Java Classes After Loading JAR
NOTE.113947.1 : Step by Step Troubleshooting Guide to Solve APPS Invalid
UNIX / LINUX / WINDOWS
=======================
NOTE.1007808.6 : HOW TO HANDLE CORE DUMPS ON UNIX
NOTE.1812.1 : TECH : Getting a Stack Trace from a CORE file
NOTE.28588.1 : TECH : Using Truss / Trace on Unix
Advanced Configuration:
======================
NOTE.217368.1 : Advanced Configurations and Topologies for Enterprise
NOTE.226880.1 : Configuration of Load Balancing and Transparent Application
NOTE.97926.1 : Failover Issues and Limitations [Connect-time failover and
NOTE.123718.1 : 11i : A Guide to Understanding and Implementing SSL for
Techstack:
=========

NOTE.162488.1 : Complete Guide to JInitiator 1.1.8 Setup & Troubleshooting
NOTE.312572.1 : About Oracle Applications Technology Updates for Release 11.
NOTE.246105.1 : Upgrading to J2SE 1.4.2 with Oracle Applications 11i
NOTE.94091.1 : Example : Identifying Connection String Problems in JDBC

Workflow:
========

NOTE.298550.1 : Troubleshooting Workflow Data Growth Issues

General:
=======

NOTE.184977.1 : Certify FAQ, Product Navigation & User's Guide
NOTE.224882.1 : Common Commands asked by Oracle Support for Troubleshooting
NOTE.110415.1 : Payables MRC Frequently Asked Questions
NOTE.285218.1 : Recommended Browsers for Oracle Applications 11i
NOTE.257650.1 : Resolving Problems with Connection Idle Timeout
NOTE.270523.1 : How To Find the Oracle Applications Framework and Rollup
NOTE.301504.1 : "Cannot Complete Applications Logon" Error After Selecting
NOTE.315094.1 : JTF Login Page - an operational assessment for CRM
NOTE.242490.1 : How To Configure The "/etc/hosts" File On Linux
NOTE.282038.1 : Oracle Applications Release 11i with Oracle Database 10g Release 1
NOTE.342861.1 : Java Version Conflict When Migrating Platforms
NOTE.209999.1 : Oracle Applications Manager in Oracle Applications 11.5.8
NOTE.198160.1 : Summary note to LOB's/BLOB's/CLOB's/NCLOB's and BFILES
NOTE.159244.1 : How To Use FNDCPASS to Change The Oracle Users, APPS, APPLSYS and Application Module Passwords (INV, AR, AP, etc.) For Applications 11.5 in Unix
NOTE.186981.1 : Oracle Application Server with Oracle E-Business Suite
NOTE.333436.1 : Oracle E-Business Suite 11i on Windows Server 2003 Service
NOTE.356878.1 : How to relink the whole Applications 11i Installation
NOTE.197031.1 : 32-bit/64-bit Certification/Conversion Issues on Oracle
NOTE.158577.1 : NLS_LANG Explained (How does Client-Server Character
NOTE.227331.1 : Setting NLS Parameters - Frequently Asked Questions
NOTE.124721.1 : Migrating an Applications Installation to a New Character
NOTE.43208.1 : Certified Compilers
NOTE.66320.1 : Changing the Database Character Set or the Database
NOTE.279956.1 : Oracle E-Business Suite Release 11i with 9i RAC :
NOTE.260393.1 : Java Mailer and Other 11.5.9/OWF G Current Issues in
NOTE.232313.1 : Information on Previous Versions of Developer 6i Patchsets
NOTE.125767.1 : Upgrading Developer 6i with Oracle Applications 11i
NOTE.371438.1 : adpreclone.pl dbTier fails with RC-50409 : Topology
NOTE.135949.1 : Troubleshooting the Personal Home Page Login Problems in 11.
NOTE.164317.1 : Upgrading JDBC drivers with Oracle Applications 11i
NOTE.302035.1 : How to Test a JDBC Thin Driver Connection From the SSO
NOTE.365735.1 : How to use Digital Certificates for 11i Applications
NOTE.357922.1 : Autoconfig Reverts to old Context File Values.
NOTE.206511.1 : How to Find a JAR File Which Contains a Particular JAVA
NOTE.68839.1 : 8i Using loadjava and dropjava to Load and Unload Java
NOTE.165123.1 : JAVA CLASS - ORA-29534 : referenced object
NOTE.165114.1 : Resolving Invalid Java Classes in Oracle Applications
NOTE.271218.1 : Yellow bar's and Java security error , The daddy of all
NOTE.294932.1 : Recommendations to Install Oracle Applications 11i
NOTE.169706.1 : Oracle Database on AIX,HP-UX,Linux,MacOSX,Solaris,Tru64
NOTE.342442.1 : Cloning Multi-Node to Single-Node Oracle Applications
NOTE.233428.1 :
NOTE.302738.1 : Using Virtual Hostnames with Oracle Applications Release 11i
NOTE.356433.1 : Using Oracle Applications Release 11i with Virtual
NOTE.362135.1 : Configuring Oracle Applications Release 11i with 10g R2 RAC
NOTE.159270.1 : How To Use FNDCPASS to Change The Oracle Users, APPS,
NOTE.303237.1 : Migrating Red Hat Linux 2.1 or 3.0 to Red Hat Linux 4.0
NOTE.91985.1 :
NOTE.200963.1 : R11.5.3/R11.5.4/R11.5.5 Upgrade And Install Issues
NOTE.272789.1 : Post Clone Problem : Login/Portal Server Installation May
NOTE.339664.1 : Analyst Crib Sheet for NLS/MLS issues in Oracle
NOTE.211708.1 : Detailed Explanations of How NLS/MLS is Being Handled in 11i
NOTE.245079.1 : Steps to clone a 11i RAC environment to a non-RAC
NOTE.362135.1 : Configuring Oracle Applications Release 11i with 10g R2 RAC
NOTE.362135.1 : Configuring Oracle Applications Release 11i with 10g R2 RAC
NOTE.312731.1 : Configuring Oracle Applications Release 11i with 10g RAC
NOTE.131321.1 : How to Relink Oracle Database Software on UNIX
NOTE.231876.1 : Windows OS Upgrade for 11i E-Business Suite
NOTE.184977.1 : Certify FAQ, Product Navigation & User's Guide
NOTE.209810.1 : How to Relink Oracle Applications 11i Programs After
NOTE.361428.1 : Using Linux Desktop Clients with Oracle Applications 11i
NOTE.296559.1 :
NOTE.275734.1 : India Localization
NOTE.364439.1 : Tips and Queries for Troubleshooting Advanced Topologies
NOTE.372928.1 : Oracle Critical Patch Update July 2006 Documentation Map
NOTE.372931.1 : E-Business Suite Critical Patch Update Note
NOTE.268837.1 : Gathering Debug Weboam Log
NOTE.292996.1 : How to Re-Install Intermedia on an 11i Environment
NOTE.160121.1 : Introduction to Sun Cluster v3
NOTE.188135.1 : Documentation Index for Real Application Clusters
NOTE.251351.1 : How to Change the Characterset in a Standby Database in 9i
NOTE.362203.1 : Oracle Applications Release 11i with Oracle 10g Release 2
NOTE.362205.1 : 10g Release 2 Export/Import Process for Oracle Applications
NOTE.1009718.6 : HOW TO SOLVE UNDEFINED SYMBOL ERRORS ON UNIX AND VMS
NOTE.316889.1 : Complete checklist for manual upgrades to 10gR2
NOTE.223721.1 : How to Install XVFB on Linux for dynamic image generartion
NOTE.130091.1 : Upgrading Oracle Applications 11i to use JDK 1.3
NOTE : 163400.1 : Release Content Documents and Features Summary Matrices
NOTE.253918.1 : Autopatch Fails with "Unable to call adppdepRunFndLoad
NOTE.166650.1 : Working Effectively With Oracle Support Services
NOTE.333785.1 : Oracle Applications Internationalization Guide
NOTE.119164.1 : Changing Database Character Set - Valid Superset Definitions
NOTE.17210.1 : Supported NLS Character Sets
NOTE.179133.1 : The correct NLS_LANG in a Windows Environment
NOTE.226565.1 : 9iRAC Useful Views and Statistics (INTERNAL ONLY)
NOTE.387046.1 : RCONFIG : Frequently Asked Questions
NOTE.200340.1 : RAC : Cache Fusion
NOTE.265253.1 : 10g Recyclebin Features And How To Disable it( _recyclebin )
NOTE.312594.1 : Get Warning Messages Trying To Generate Jar Files From
NOTE.242480.1 : Using a Staged Applications 11i System to Reduce Patching
NOTE.134007.1 : CMCLEAN.SQL - Non Destructive Script to Clean Concurrent
NOTE.365228.1 : About Oracle Applications Technology 11i.ATG_PF.H Rollup 4
NOTE.371016.1 : How To License A New Product.
NOTE.151654.1 : How To Start the License Manager After Installing Oracle
NOTE.279430.1 : How To Change Project Installation From Shared To Full
NOTE.123891.1 : How to deactivate a language in e-Business Suite
NOTE.216550.1 : Oracle Applications Release 11i with Oracle9i Release 2 (9.
NOTE.341437.1 : Business Continuity for Oracle Applications Release 11i
NOTE.246105.1 : Upgrading to J2SE 1.4.2 with Oracle Applications 11i
NOTE.304748.1 : Internal : E-Business Suite 11i with Database FAQ
NOTE.308320.1 : How to install the 10.1.0 Enterprise Manager Grid Control
NOTE.291901.1 : Maintenance Mode - A New Feature in 11.5.10
NOTE.134527.1 : TNS-00516 Starting TNS Listener
NOTE.300482.1 : Overview of Using Java with Oracle E-Business Suite Release
NOTE.208256.1 : WIN : How to Remove a Single ORACLE_HOME and Its Traces on
NOTE.363827.1 : Rebaselined Oracle Applications Technology Components for
NOTE.373611.1 : How to move Concurrent Processing Server from one node to
NOTE.240818.1. : Concurrent Processing: Transaction Manager Setup and Configuration Requirement in an 11i RAC Environment
NOTE.69660.1 : Understanding Data Auditing in Oracle Application Tables
NOTE.60828.1 : Overview of Oracle Applications AuditTrails
NOTE.134949.1 : Release 11.0.3 and Oracle 8i Release 8.1.6 Interoperability
NOTE.342332.1 : Troubleshooting Login Problems in Oracle Applications 11i
NOTE.189256.1 : UNIX : Script to Verify Installation Requirements for Oracle
NOTE.296559.1 : FAQ : Common Tracing Techniques within the Oracle
NOTE.177183.1 : Succesfully Installing NLS/MLS in 11i
NOTE.73352.1 : NLS/MLS Frequently Asked Questions
NOTE.399789.1 : NLS Frequently Asked Questions
NOTE.339664.1 : Analyst Crib Sheet for NLS/MLS issues in Oracle
NOTE.227331.1 : Setting NLS Parameters - Frequently Asked Questions
NOTE.110849.1 : Installing and Relinking Oracle Developer on UNIX Platforms
NOTE.76535.1 : Troubleshooting Issues Which Arise During the Application of Release 11 Patches
NOTE.316804.1 : Oracle Applications NLS Release Notes, Release 11i (11.5.10.
NOTE.287176.1 : DMZ Configuration with Oracle E-Business Suite 11i
NOTE.310840.1 : AFPCAL Received Failure Code While Parsing or Running
NOTE.371434.1 : Using Openfiler iSCSI with an Oracle database
NOTE.233040.1 : When Oracle Applications Automatic Patch Prerequisite
NOTE.236469.1 : Using Distributed AD in Applications Release 11.5.
NOTE.233043.1 : 11.5.9 Oracle E-Business Suite Consolidated Update 2
NOTE.108185.1 : Oracle Applications Object Library SQL scripts
NOTE.201662.1 : How To Manually Relink on Windows NT or Windows 2000
NOTE.306906.1 : How to create missing DB objects from xdf files
NOTE.396708.1 : Guidelines to Determine whether a Bug or SR is a LinuxOS
NOTE.166762.1 : Oracle Applications Manager 11i Availability
NOTE.60966.1 : Getting Rid Of Those Pesky Invalid Objects In Oracle
NOTE.216589.1 : Step By Step Guide to Creating a Custom Application in
NOTE.105127.1 : FAQ (Customization)
NOTE.243880.1 : Shared APPL_TOP FAQ
NOTE.409045.1 : How to clone from Rac to Non-rac in Oracle Applications 11i.
NOTE.373611.1 : How to move Concurrent Processing Server from one node to
NOTE.342442.1 : Cloning Multi-Node to Single-Node Oracle Applications
NOTE.261428.1 : Setting up 11i E-Business suite using a hardware load
NOTE.224875.1 : Installation, Patching & Upgrade Frequently Asked Questions
NOTE.278816.1 : How to Setup Parallel Concurrent Processing using Shared
NOTE.286506.1 : Sharing Middle-tier Oracle Home in E-Business Suite 11i
NOTE.105133.1 : Concurrent Manager Questions and Answers Relating to
NOTE.69336.1 : Basic information about Concurrent Managers
NOTE.169706.1 : Oracle Database on AIX,HP-UX,Linux,MacOSX,Solaris,Tru64
NOTE.345145.1 : Is There A Way To Automate The Prompts For Adcfgclone.Pl?
*********************************************************************
NOTE.416338.1 : How To Upgrade JDK / J2SE 1.4 Sub-Versions
NOTE.225165.1 : Patching Best Practices and Reducing Downtime
NOTE.368628.1 : Is The 'Personal Home Page' Mode Supported In Oracle 11i Applications?
NOTE.387859.1 : Using AutoConfig to Manage System Configurations in Oracle
NOTE.402306.1 : Oracle Applications Installation and Upgrade Notes Release
NOTE.160214.1 : How to change the oracle users, APPS, APPLSYS and
NOTE.159244.1 : How To Use FNDCPASS to Change The Oracle Users, APPS,
NOTE.335515.1 : Relink fails for Oracle 9.2.0.7.0 on LINUX x86 server on
NOTE.372800.1 : How to Implement an SSL CA Root Certificate in JInitiator
NOTE.402312.1 : Oracle Applications Installation and Upgrade Notes Release
NOTE.394692.1 : Oracle Applications Documentation Resources, Release 12
NOTE.603104.1 : Troubleshooting RapidClone issues with Oracle Applications R12
NOTE.384248.1 : Sharing The Application Tier File System in Oracle E-Business Suite Release 12
NOTE.388577.1 : Configuring Oracle Applications Release 12 with 10g R2 RAC
NOTE.559518.1 : Cloning Oracle Applications Release 12 with Rapid Clone on RAC Enabled Systems
NOTE.393861.1 : Globalization Guide for Oracle Applications Release 12
NOTE.372800.1 : How to Implement an SSL CA Root Certificate in JInitiator
NOTE.184876.1 : Oracle Application Object Library Middle (Web) Tier Setup
NOTE.403385.1 : Duplicate Responsibilities Created On Sysadmin Login And
NOTE.380483.1 : Oracle E-Business Suite Release 12 Additional Configuration
NOTE.148903.1 : Interoperability Notes Oracle Applications Release 11i with
NOTE.364704.1 : A Guide to Configure, Maintain & Troubleshoot JDBC Buffers
NOTE.148902.1 : Interoperability Notes Oracle Applications Release 11.0
NOTE.337762.1 : How to Remove an Oracle Applications 11i node
NOTE.399362.1 : Oracle Applications Release 12 Upgrade Sizing and Best
NOTE.104457.1 : Invalid Objects In Oracle Applications FAQs
NOTE.132604.1 : Upgrading OJSP with Oracle Applications 11i
NOTE.215268.1 : Implementing and Using the JSP Precompiler
NOTE.316900.1 : ALERT : Oracle 10g Release 2 (10.2) Support Status and Alerts
NOTE.189908.1 : ALERT : Oracle9i Release 2 (9.2) Support Status and Alerts
NOTE.380490.1 : Oracle E-Business Suite R12 Configuration in a DMZ
NOTE.269291.1 : Oracle Applications Tablespace Migration Utility User
NOTE.206511.1 : How to Find a JAR File Which Contains a Particular JAVA
NOTE.406982.1 : Cloning Oracle Applications Release 12 with Rapid Clone
NOTE.262125.1 : Sun.io.MalformedInputException For OraSCV.asc,emreadme.txt,
NOTE.419839.1 : How to enable Apache, OC4J and OPMN logging in Oracle
NOTE.422419.1 : How To Enable and Collect Debug for HTTP, OC4J and OPMN in
NOTE.15390.1 : How to Determine and Change DB_NAME or ORACLE_SID
NOTE.375682.1 : About Oracle Applications Technology ATG_PF.H Rollup 5
NOTE.135715.1. : Diagnostic Steps for Intermittent FRM-99999 & FRM-92100
NOTE.185489.1 : Setting Up Parallel Concurrent Processing On Unix Server
NOTE.431496.1 : Java In The Database For Oracle Applications : Introduction
NOTE.183408.1 : Raw Devices and Cluster Filesystems With Real Application
NOTE.277366.1 : Technology Validation Utility for Oracle Applications
NOTE.394448.1 : Getting Started with the Application Management Pack for
NOTE.412044.1 : Application Management Pack for Oracle E-Business Suite
NOTE.375113.1 : Oracle Diagnostics 2.4
NOTE.405425.1 : Oracle Diagnostics 2.5
NOTE.201340.1 : Using Forms Listener Servlet with Oracle Applications 11i
NOTE.160337.1 : How To Manually Change The APPS, APPLSYS and APPLSYSPUB
NOTE.372322.1 : HP Tru64 UNIX Migration Strategy for Oracle E-Business
NOTE.303709.1 : Reclaiming unused space in APPLSYSD tablespace
NOTE.130183.1 : How to Get Log Files from Various Programs for Oracle
NOTE.269129.1 : How to Implement Printing for Oracle Applications : Getting
NOTE.297522.1 : How to investigate printing issues and work towards its resolution ?
NOTE.215527.1 : Maintenance Wizard Overview
NOTE.452120.1 : How to locate the log files and troubleshoot RapidWiz for
NOTE.312640.1 : Oracle Text : Re-installation of Applications 11i (11.5.10)
**************
*** iSetup ***
**************
NOTE.402785.1 : iSetup dependency with Deinstall and Reinstall of XMLDB
NOTE.368670.1 : About Oracle iSetup Minipack 11i.AZ.H
NOTE.243554.1 : How to Deinstall and Reinstall XML Database (XDB)
NOTE.244523.1 : Security Alert #57 : Buffer Overflows in EXTPROC of Oracle
NOTE.433435.1 : Japanese characters are displayed like square boxes in
NOTE.455366.1 : Investigating NoClassDefFoundError in eBusiness 11i when
NOTE.197409.1 : Error Opening Oracle*Terminal File fmrweb.res
NOTE.312553.1 : How To Use the Original Forms for Reprint Instead of the
NOTE.438086.1 : Platform Migration with Oracle Applications Release 12
NOTE.458452.1 : Complying with Daylight Saving Time (DST) and Time Zone
NOTE.189367.1 : Best Practices for Securing the E-Business Suite
NOTE.300969.1 : Troubleshooting SSL with Oracle Applications 11i
NOTE.444524.1 : About Oracle Applications Technology ATG_PF.H Rollup 6
NOTE.265253.1 : 10g Recyclebin Features And How To Disable it( _recyclebin )
NOTE.428262.1 : How to identify the form name attached to an f60webmx
NOTE.68839.1 : 8i Using loadjava and dropjava to Load and Unload Java
NOTE.405521.1 : Oracle Enterprise Manager Grid Control Release Notes for
NOTE.187905.1 : bde_imt_index_status.sql - List all interMedia Text indexes
NOTE.388577.1 : Configuring Oracle Applications Release 12 with 10g R2 RAC
NOTE.345106.1 : Login Links On New Rapid Install Homepage Do Not Function
NOTE.443521.1 : Enterprise Manager Grid Control Plug-in for Oracle Applications, Version 1.0/1.2
NOTE.398412.1 : Workflow Queues Creation Scripts
NOTE.77483.1 : External Support FTP site : Information Sheet
NOTE.122452.1 : Global Customer Services Policy Regarding Customizations
NOTE.257911.1 : How To Use Rotatelogs In 9iAS Release 1 (1.0.2.x)
NOTE.276845.1 : Apache Web Server Hangs Every Other Time Running Adapcctl.
NOTE.218893.1 : How to Create The Service Manager 'FNDSM' on Oracle
NOTE.437878.1 : Upgrading Forms and Reports 10g in Oracle Applications
NOTE.290807.1 : Upgrading Sun JRE with Oracle Applications 11i
NOTE.280167.1 : AS10g with Apps 11i - Summary of Login process
NOTE.357218.1 : Troubleshooting JDeveloper setup for Oracle Applications
NOTE.403339.1 : Oracle 10gR2 Database Preparation Guidelines for an E-Business Suite Release 12 Upgrade
NOTE.463249.1 : After Clone Forms Is Trying To Connect To Target Instance
NOTE.386374.1 : How to enable/disable/change password of the listeners for Oracle Applications 11i
NOTE.454750.1 : Oracle Apps Release 12 with Oracle Database 10.2.0 interoperability notes
NOTE.428503.1 : Integrating Oracle E-Business Suite Release 11i with Oracle Database Vault 10.2.0.3
NOTE.443761.1 : How to check if a certain Patch was applied to Oracle Applications instance using 'adpatch'?
NOTE.291783.1 : Getting Started with the Oracle Grid Control Plug-in for Oracle Applications in Release 11i (AMP v1)
NOTE.468980.1 : How to Remove the Language Icons in the AppsLocalLogin.jsp
NOTE.398619.1 : Clone Oracle Applications 11i using Oracle Application Manager (OAM Clone)
NOTE.295606.1 : Oracle Application Server 10g with Oracle E-Business Suite Release 11i Troubleshooting
NOTE.169706.1 : Oracle® Database on AIX®,HP-UX®,Linux®,Mac OS® X,
Solaris®,Tru64 Unix® Operating Systems Installation and
Configuration Requirements Quick Reference (8.0.5 to 11.1)
NOTE.109665.1 : Organization Setup Frequently Asked Questions - FAQ
NOTE.434395.1 : ATG Service Request Creation
NOTE.438086.1 : Platform Migration with Oracle Applications Release 12
NOTE.469213.1 : How To Encrypt The Apps Password In Wdbsvr.App
NOTE.293369.1 : OPatch documentation list
NOTE.275379.1 : Script To Check What Workflow Related Patches Are Installed
NOTE.388577.1 : Configuring Oracle Applications Release 12 with 10g R2 RAC
NOTE.264157.1 : The correct NLS_LANG setting in Unix Environments
NOTE.91985.1 : Step by Step on Cloning the ORACLE_HOME (Including DB) and
NOTE.74838.1 : Migrating Apps Release 11.0 from UNIX Host To A Second
NOTE.396009.1 : Database Initialization Parameters for Oracle Applications Release 12
NOTE.391406.1 : How to get a clean Autoconfig Environment
NOTE.560719.1 : How to troubleshoot iSetup issues
NOTE.406376.1 : Oracle E-Business Tax Release 12 Known Issues
NOTE.577713.1 : On Windows, After 10g Upgrade, Running Autoconfig on Apps
NOTE.343917.1 : Frequently Asked Questions : Oracle E-Business Suite Support
NOTE.553831.1 : java.lang.ArrayIndexOutOfBoundsException Error when
NOTE.119319.1 : How to Replace Oracle Logo with Company Logo on Applications 11i Sign-On Screen
NOTE.554336.1 : How Do You Manually Generate A Form In Release 12 (frmcmp)
NOTE.444286.1 : How to manually generate a R12 report on Unix
NOTE.356433.1 : Using Oracle Applications Release 11i with Virtual Hostnames and Business Continuity
NOTE.555081.1 : Concurrent Manager Does Not Start if the Profile Option "Concurrent : GSM Enabled" is Set "Y" at Site Level
NOTE.149124.1 : Creating a StatsPack performance report
NOTE.471566.1 : Migrating Oracle E-Business Suite R12 from Linux 32-bit to Linux 64-bit
NOTE.397757.1 : How to Speed Up Index Creation on FND_LOBS by indexing Only FND_HELP Data
NOTE.375127.1 : How to restart the adworker having status fixed,restart,wait
NOTE.353150.1 : OPatch Failing Validation Phase When Archiving Really Did Not Fail
NOTE.215527.1 : Maintenance Wizard Overview
NOTE.564465.1 : Sysadmin And User Responsibility Not Available
NOTE.219968.1 : SQL*Net, Net8, Oracle Net Services - Tracing and Logging at a Glance
NOTE.417122.1 : Resolving the Library Cache Locks
NOTE.419475.1 : Removing Credentials from a Cloned EBS Production Database
Metalink Important Note IDs

1. How to run OATM migration utility ---- Note:404954.1

2. 11.5.10 Oracle E-Business Suite Consolidated Update 2 (CU2)---- Note:316366.1

3. Upgrading Oracle Applications ---- Note:289788.1

4. E-Business Suite Diagnostics Patch Installation Guide ---- Note:167000.1

5. Step by Step Troubleshooting Guide to Solve APPS Invalid Objects ---- Note:113947.1

6. Compatibility Matrix for Export And Import Between Different Oracle Versions ----Note:132904.1

7. ORA-06550 Running Sys.Utl_recomp.Recomp_parallel(1) During ADPATCH or ADADMIN Session ---- Note:362727.1

8. Now Available: Oracle E-Business Suite Release 12.0.4 ---- Note:556312.1

9. Cloning Oracle Applications Release 11i with Rapid Clone ---- Note:230672.1

10.Upgrading Developer 6i with Oracle Applications 11i ---- Note:125767.1

11.The Basics About Report Review Agent (FNDFS) on 11i ---- Note:111383.1

12.How To Use FNDCPASS to Change The Oracle Users, APPS, APPLSYS and Application Module Passwords (INV, AR, AP, etc.) For Applications 11.5 in Unix ---- Note:159244.1

13.USAGE OF INDIA LOCALIZATION PATCH TOOL (INDPATCH) ---- Note:376756.1

14.Sharing the Application Tier File System in Oracle Applications 11i ----Note:233428.1

15.Shared APPL_TOP FAQ ---- Note:243880.1

16.Using a Staged Applications 11i System to Reduce Patching Downtime ---- Note:242480.1

17.Summary of Possible Reasons and Solutions for the Problem Where All Concurrent Requests Stuck in Pending Phase ---- Note:182154.1

18.Release 11i Adpatch Basics ---- Note:181665.1

19.How to Apply an 11i Patch When adpatch is Already Running ---- Note:175485.1

20.How to Create a Custom Concurrent Manager ---- Note:170524.1

21.Concurrent Manager Questions and Answers Relating to Generic Platform ----Note:105133.1

22.E-Business Suite Diagnostics Patch Installation Guide ---- Note:167000.1