ORA-20100: Temporary file creation for FND_FILE failed

Unable to Install Checkpoint VPN
January 18, 2021

ORA-20100: Temporary file creation for FND_FILE failed

Problem:

Getting the error below while running concurrent programs with EBS R12.1 and DB 19c installed. The paths for APPLTMP and APPLPTMP are correct

An internal error has occurred in the program xla_create_acct_rpt_pvt.BeforeReport . ORA-20001: -: XLA-95103: An internal error occurred. Please inform your system administrator or support representative that:

An internal error has occurred in the program XLA_CREATE_ACCT_RPT_PVT.print_logfile. ORA-20100: ORA-20100: Temporary file creation for FND_FILE failed.
Directory &FILE_DIR is invalid
ORA-06512: at “APPS.APP_EXCEPTION”, line 72
ORA-06512: at “APPS.XLA_EXCEPTIONS_PKG”, line 110
ORA-06512: at “APPS.XLA_EXCEPTIONS_PKG”, line 289
ORA-06512: at “APPS.XLA_EXCEPTIONS_PKG”, line 162
ORA-06512: at “APPS.XLA_CREATE_ACCT_RPT_PVT”, line 285
ORA-06512: at line 4

Solution:

To enable the UTL_FILE functionality on which the supplemental UTL_FILE_DIR parameter depends, ensure that you have set the following event at the CDB level in your database initialization parameters: event='10946 trace name context forever, level 8454144'

Reference:

Using UTL_FILE_DIR or Database Directories for PL/SQL File I/O in Oracle E-Business Suite Releases 12.1 and 12.2 (Doc ID 2525754.1)

Leave a Reply

Your email address will not be published. Required fields are marked *