APP-FND-01630: Cannot open file D:\oracle\prodcomn\temp\OF4981.tmp

My Friend call me and told me he is getting following errors when he runs the report.

Cause: The program terminated, returning status code 3.
Action: Check your installation manual for the meaning of this code on this operating system.
APP-FND-01630: Cannot open file D:\oracle\prodcomn\temp\OF4981.tmp for reading
Cause: USDINS encountered an error when attempting to open file D:\oracle\prodcomn\temp\OF4981.tmp for reading.
Action: Verify that the filename is correct and that the environment variables controlling that filename are correct.
Action: If the file is opened in read mode, check that the file exists. Check that you have privileges to read the file in the file directory. Contact your system administrator to obtain read privileges.
Action: If the file is opened in write or append mode, check that you have privileges to create and write files in the file directory. Contact your system administrator to obtain create and write privileges.
Concurrent Manager encountered an error while running Oracle*Report for your concurrent request 440550.
Review your concurrent request log and/or report output file for more detailed information.

I had searched the metalink and i got the solution for this

To implement the solution, please execute the following steps:

1. Rename the temp directory.

2. Create new temp directory.

3. Run cmclean.sql

Note 134007.1 CMCLEAN.SQL Non Destructive Script to Clean Concurrent Manager Tables

4. Bounce the applications services.

Leave a Reply

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