Almost the same problem i have found when execute query using form applet when i got this message FRM-41838: Unable to open temporary record buffer file %s. And then i got this message when i run report. Here the message,
REP-0118 Unable to create a temporary file
The solution i found that maybe help for anyone who face the same problem,
– Check user variables
TEMP and TMP refers to directory that exists, if not exists then you must edit the value
– check free space on the disk, it must be enough space to create temporary file
– delete file in temporary directory, maybe, it cannot be modified because read only or already exists
– check registry setting using REGEDIT, locate variable REPORTS_TMP underkey hkey_local_machine/software/oracle/<oracle home>
make sure the value of the variable refers to exist directory
Filed under: Oracle | Tagged: Oracle, REP- error code | Leave a comment »