ORA-20100: Temporary file creation for FND_FILE failed

 APP-AR-11526: ORA-20100: ORA-20100: Temporary file creation for FND_FILE failed.

SOLUTION

There are 4 steps for addressing the ORA-20100 error:

1.  utl_file_dir parameter is not set. Run following SQL to check: 

select value from v$parameter where name = 'utl_file_dir';

If no value is returned, make the setup according to Doc ID 2525754.1, sections:

3.1.2: Updating UTL_FILE_DIR in an Oracle E-Business Suite Instance on Oracle Database 19c

OR

3.2: Referencing a Physical Directory Path Without Using UTL_FILE_DIR

 

2.  First value from above SQL should match to value of $APPLPTMP environment parameter.

 

3.  Event 10946 should be set at Container Database (CDB) level, as explained in Note 2525754.1:

alter system set events '10946 trace name context forever, level 8454144';
alter system set event='10946 trace name context forever, level 8454144' scope=spfile;

 Bounce application and database after setting the event.

 

4. There is a concern with the synonyms. If issue persists please restart of the server and follow the steps below:

a. Execute select owner,object_name,object_type,status,created from dba_objects where object_name='FND_FILE'; to verify the synonym details

b. Recreate the synonym that exists for Custom schema
create or replace SYNONYM schema_name.FND_FILE for apps.FND_FILE; (schema_name should replace with custom schema name)

c. Provide grant by executing below command:
grant execute on directory EBS_DB_DIR_UTIL to public;
grant read, write on directory EBS_DB_DIR_UTIL to public;

d. Provide grant to custom schema:
grant execute on fnd_file to custom schema name;

e. Recompile the Custom package that is used in the Custom program.

f.  Retest the issue by submitting the concurrent program.

Note:  FND_FILE is a wrapper for UTL_FILE. Therefore, first make sure UTL_FILE is valid.