Hi guys,I got this error when I am registering PL/SQL PROCEDURE program in APPS(11.5.9) and when I am submiting the Request from SRS window I am getting this error. The ERROR is-------------------------------------------------------Cause: FDPSTP failed due to ORA-20100: File o0028513.tmp creation for FND_FILE failed.You will find more information on the cause of the error in request log.ORA-06512: at "APPS.FND_FILE", line 378ORA-06512-------------------------------------------------------can any one help how to resolve this error,I am getting this error when PL/SQL PROCEDURE contains "FND_FILE.PUT_LINE"waiting for your reply Guysthnx

bommana_vidyasagar
Profile Answers by bommana_vidyasagar Questions by bommana_vidyasagar
Dec 14th, 2006
4
6400

Questions by bommana_vidyasagar answers by bommana_vidyasagar

Showing Answers 1 - 4 of 4 Answers

Guest

Jan 23rd, 2007

hi ,
pls check ur fnd_file syntax is like this
fnd_file.put_line(fnd_file.output ,'testing' );

Manishas
Profile Answers by Manishas

Feb 24th, 2007

Hi,
First Create and execute procedure at database level, If it is executing successfully then run request from SRS window.

Kranti Shah

Feb 27th, 2007

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 initSID.ora. Thus, APPLPTMP must be one of the directories listed
in initSID.ora in order for FND_FILE to work.

Solution:

Set the APPLPTMP Registry Variable on the MS Windows Registry to point to the
UNIX temporary directory as specified by UTL_FILE_DIR initialization parameter
in the database initSID.ora file.

Navigate to the Registry and set APPLPTMP Variable.

        HKEY_LOCAL_MACHINE
Software
    Oracle
              Applications
11.5.1
<APPL_CONFIG>

        e.g.:
        Key: PROD
Value name : APPLPTMP
        value data : /usr/tmp

J. Diwakar reddy

Mar 2nd, 2007

why because

1) Is there any internal problem of your system.
2) Another one is you didn't write procedure correctly.