ORA-20100: Temporary file creation for FND_FILE failed

ORA-20100: Temporary file creation for FND_FILE failed

In 19c database for EBS R12.2 , we are getting below error while run jobs or creating files.

ORACLE error 20100 in FDPSTP

Cause: FDPSTP failed due to ORA-20100: ORA-20100: Temporary file creation for FND_FILE failed.

The ORA-20100 error in Oracle E-Business Suite indicates that the temporary file creation for FND_FILE has failed.

Solution:

1) Make sure UTL file dir is setup correctly as below

Click Here

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

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

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;

 

4) Bounce application and database after setting the event.

5) 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;

6) Connect to SQLPLUS and try below command to make sure it runs successfully.

exec FND_FILE.PUT_LINE(FND_FILE.LOG, 'THIS IS A TEST');

If you like please follow and comment