DBA

APPLPTMP
========

APPLPTMP is a special directory used only for PLSQL temporary files. When a concurrent program uses the FND_FILE package, the concurrent manager uses APPLPTMP as the directory to which it writes temporary files. FND_FILE uses the UTL_FILE Package, which can only write to directories specified in init.ora. Thus, APPLPTMP must be one of the directories listed in init.ora in order for FND_FILE to work.

Ensure that the virtual path assigned to the APPLPTMP environment variable is valid, writable, and is referenced at the beginning of the UTL_FILE_DIR database parameter.

Example:
In the initSID.ora
utl_file_dir = /usr/tmp, /u01/sql/tmp, /u02/sql/tmp
In the SID.env,
APPLPTMP = /usr/tmp
(or any of the directories listed above that applmgr has read/write permissions to).

Make sure that the value for APPLPTMP comes first in this listing for UTL_FILE_DIR, as this is the key to this solution.

.h files
========

I can see in patches under FND>Include folder there are many *.h files. I know these are header files. Can anyone tell why this is necessary and where does these goes in system. Which location etc and what harm or benefit they do to patch in question. 
 
Answer  
 
The include directory contains C language header (.h) files that may be linked with files in the lib directory. Those files are used by adadmin and adpatch (and some other ad utilities) to relink executable files which will be located under the 
$PRODUCT_TOP/bin directory. Please note that not all products require this directory.