Authentication failed error in the notification attachment

Authentication failed error

Report output send as an attachment in the notification. An user first time see the notification and open the attachment. But from the second time user can not open the attachment. It gives the error 'Authentication failed error'

Solution:The attachment output files stores in the temporary file fnd_file_temp. 

Once you view this file and then close the file , system automatically delete the record from the table fnd_file_temp. So second time onwards no file found in the table.That is why it gives error 'Authentication failed'

 

Go to package fnd_webfilepub and comment out all the 'delete from fnd_file_temp' and check.

As you are commenting the code 'delete from fnd_file_temp'  So the all attachment files will not be deleted.

In that case it is better to delete the fnd_file_temp periodically.