FRM-41839: Disk I/O error on temporary record buffer file/tmp/... TMP, frm-41839... tmp

FRM-41839: Disk I/O error on temporary record buffer file/tmp/... TMP, frm-41839... tmp

This error is generated when processing a large amount of data, such as Physical Inventory Adjustment. Because EBS requires a large amount of data, the system will use a temporary file in the/tmp directory *. TMP. The temporary file is deleted.

If the data volume is too large, this error may be reported: FRM-41839: Disk I/O error on temporary record buffer file/tmp/... TMP

This error may be reported because the space allocated to the/tmp directory is too small and the disk space is insufficient. however, even if the directory space is sufficient, this error may occur because EBS has a limit on the size of the temporary file. Before patch 14825718, the file size is limited to 2 GB. After completing the patch, you can modify the configuration file to increase the size limit of the temporary file.

See Most Common Solutions to FRM-41839 and. tmp Files Not Being Deleted (Doc ID 435437.1) 13th.

For more information about downloading patches, see Upgrading OracleAS 10g Forms and Reports in Oracle E-Business Suite Release 12 (Doc ID 437878.1)

Procedure:

0. shut down EBS
1. download patch (Solaris): https://updates.oracle.com/download/14825718.html
2. upload the patch to DIR:/var/tmp
3. unzip p14825718_xxx.zip (depends on Ct's system)
4. cd 14825718
5. export PATH = $ PATH:/var/tmp/14825718
6. use command: opatch apply
7. after patch applied, then go to $ ORA_CONFIG_HOME/10.1.2/forms/server, find file default. env, find FORMS_SCROLL_ALL_BUT_ONE in the file, and add
Following in the next line:
FORMS_RECMGR_RECSIZE_POWER = 4
This wocould allow. tmp file size up to 32 Gb.
8. Then bounce EBS and retest.

This is a Framework patch. After completing this patch, you need to generate the form and jar files again and use the adadmin command. Otherwise, the form may not be opened.