404 error while clicking on View results in purchasing

SQL> select max(log_sequence) from fnd_log_messages;

MAX(LOG_SEQUENCE)
-----------------
          1040326

1049124


Issue :
-------

After funds check is performed, Trying to see the results by clicking on "View Results" button only shows the header of the new page. The bottom of the page is not found and shows the Error: http 404

Solution :
----------

How to obtain data from FND log messages:

1. Set the following profiles at user level
- FND: Debug Log Enabled = 'Yes'
- FND: Debug Log Level = 'Statement'
- FND: Debug Log Module = '%'

2. Run the following query and note its output as log_val_1.

select max(log_sequence) from fnd_log_messages;
3. Perform the operations to reproduce the error.
When in the form, get the audsid, go to Help->About Oracle Applications, you will find the AUDSID field in the Database Server zone.

Note: if you do not see the AUDSID value, set the FND: Diagnostics profile option to "Yes" and it will be visible.

4. Once the process completes run again the query from step 2 and note its output as log_val_2.

5. Run the following query to fetch the log messages using the AUDSID value from step 3:

select log_sequence, module, message_text
from fnd_log_messages
where log_sequence between log_val_1 and log_val_2
and audsid = &enter_audsid
order by log_sequence;
SOLUTION

In the FND log file, find the lines with error :

> java.io.FileNotFoundException:
> filename.fo  (No such file or directory)

Confirm that the directory referred in the error message in the FND log do exist and has write privileges.
If it doesn't then create the directory and grant the required privileges.


Alternatively Note 428855.1 - JAVA.IO.FILENOTFOUNDEXCEPTION NO SUCH FILE FOR EXCEL FORMAT can be used to point the Temporary Directory parameter to an existing directory.

Note :

1. File ownership or permission is necessary to check.

2. Temporary directory path in Xml administrator needs to be point to a valid path of $APPLTMP. This path needs to be present in concurrent manager node.

3.Otherwise set Temporary directory to /tmp

Reference :

The Funds Check - View Result Getting Error Showing the Report Page: http 404 (Doc ID
1084049.1)
NOTE:428855.1 - XML Publisher Report Fails With: JAVA.IO.FILENOTFOUNDEXCEPTION No Such File For Excel Format