SQL> select OUTFILE_NAME from FND_CONCURRENT_REQUESTS where concurrent_request_id = <...>;
SQL> select * from dba_directories;
grr wrote:What are the Unix privileges/permissions on the /tmp directory and the file ? What is the complete error message ? If you temporarily change the permissions on $APPLCSF/$APPLOUT directory and file to match your test case, does your code function ? If so, this is a permissions issue.
Atlast I got the mail with the attachment, what we did was, we changed the path for the Directory to /tmp and moved the pdf file into the /tmp of database server.
From this databse server i am able to attach the documents and send to the mail. but when I am trying to pick it from Application server it is getting error.
As you know that, the concurrent request output file saves in the Applications server.HTH
Can you please suggest me how can I attach the pdf from the Application server.
grr wrote:Is this a single node install ? If so, it looks to be a permissions issue, as the code works when the permissions are set correctly.
The code was not having any problems but the issue was with the Privileges/permissions.
What my DBA did is he moved the pdf file from the Application Server into the Database server /tmp and then he created the directory OUT_DIR as path /tmp.
My question may look simple for you, Is that utl_smtp code allows us to get the file from the data base server only.
Or is that the DBA will not give the necessary permissions to access the Application server path.
grr wrote:If the concurrent programs are running on the Apps tier, then the APPLCSF and APPLOUT directories (where the concurrent output is created) will be on the Apps tier. This directory will need to be accessible to the database tier where your code runs. There are various mechanisms to do this - check with your Unix sys admins
It is Application tier.
And one more question, Can we change the name of the attachment coming in the mail.You can copy the original file to any file name (as part of your code).
As the attachment name is user.requestid, i want this to be renamed while sending to the mail. Is this possible?