The Concurrent program is getting completed successfully, able to view output & logfile. But in the log file, it shows below error.
Oracle error 20100: java.sql.SQLException: ORA-20100: Error: FND_FILE failure. Unable to create file, o0165247.tmp in the directory, /testebs1/applcsf/tmp.
You will find more information in the request log.
ORA-06512: at “APPS.FND_FILE”, line 417
ORA-06512: at “APPS.FND_FILE”, line 526
ORA-06512: at “APPS.FND_CONCURRENT”, line 1335
ORA-06512: at line 1
has been detected in FND_CONCURRENT.SET_INTERIM_STATUS.Successfully resubmitted concurrent program FNDOAMCOL with request ID 8907654 to start at 25-JAN-2017 22:38:56 (ROUTINE=AFPSRS)
Step 1: Stop the application.
Step 2: Manually delete the files under $APPLCSF/$APPLLOG
Step 3: Restart the application and retest the issue.