***Moderator action (Timo): removed many email addresses from this post. User, please don't post private information when asking questions here!***
Hi,
I've been updating an csv file and sending it through mail by running concurrent. I've tested it in test environment and everything works fine but in production it is giving me ORA-29284:file read error.
In production The file is being updated in DB server but the file which is being sent through mail is old csv file(The non-updated file). I've given the permission 777 but still the problem is not resolved.
I'm currently working in Oracle E-Business Suite.
This is the log of Concurrent program
+---------------------------------------------------------------------------+
XX CRM Integration: Version : 12.4
Copyright (c) 1998, 2013, Oracle and/or its affiliates. All rights reserved.
+---------------------------------------------------------------------------+
Current system time is 25-OCT-2017 14:42:07
+---------------------------------------------------------------------------+
**Starts**25-OCT-2017 14:42:07
**Ends**25-OCT-2017 14:44:24
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
ORA-29284: file read error
calling values:***
calling CC values:***
Mail Sent To ***
Mail Sent cc ***
Subject Of The Mail report
Test Message For The MailHi,<br/><p>Please find the Report <br/>
<br/>Best Regards,
Attachment Name report_equipment_return_tasks_for_all_statuses.csv
Sending Equipment RETURN Report
Going to create UTL connection
Prepared UTL_SMTP connection
Mail will be sent to ***
Mail will be sent to ***
Mail will be sent to(cced) ***
Mail will be sent to(cced) ***
connection open
+---------------------------------------------------------------------------+
End of log messages from FND_FILE
+---------------------------------------------------------------------------+
+---------------------------------------------------------------------------+
No completion options were requested.
Output file size:
0
+---------------------------------------------------------------------------+
Concurrent request completed successfully
Current system time is 25-OCT-2017 14:44:24
+---------------------------------------------------------------------------+
Please help me with this issue.
TIA