CUSTOM Programs failing: FDPSTP failed due to ORA-20100: ORA-20100: Temporary file creation for FND_FILE failed ( EBS 12.1.3 & Oracle 19c CDB):
[16-DEC-2024 17:57:29]: **Starts**
[16-DEC-2024 17:57:29]: **SQL error and free**
[16-DEC-2024 17:57:29]: ORACLE error 20100 in FDPSTP
Cause: FDPSTP failed due to ORA-20100: ORA-20100: Temporary file creation for FND_FILE failed.
Directory &FILE_DIR is invalid, contact your system administrator.
Action: Check that the directory is a valid directory with wri
Below 4 steps for addressing the ORA-20100 error: (fixed tempfile creation error for CUSTOM Programs)
1. utl_file_dir parameter is not set. Run following SQL to check:
for 19c DB: login as apps user
select value from v$parameter where name = 'utl_file_dir';
If above query returns wrong values then correct directory path using steps (below URL) to set UTL_FILE_DIR
https://rajoraclegenie.blogspot.com/search/label/Oracle%2019c%20Database
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.
Reference: Custom Concurrent Programs Fail with Error FDPSTP failed due to ORA-20100: ORA-20100: Temporary file creation for FND_FILE failed (Doc ID 2723960.1)
0 Comments