SQL & PL/SQL

Hi, i'd just like to share this piece of information i gathered from this thread:

fnd_gfm package to generate a download URL

it was left unanswered and i couldn't reply, so i just made a new thread about it.

i was migrating a workflow notification message from 11i to R12, and i've had some problems regarding the download link in the attachment.

It was previously hardcoded and there have been some changes from FND_DOCUMENTS and FND_DOCUMENTS_TL tables regarding MEDIA_ID from 11i to R12.

to programatically generate a download link, i used the example from the thread fnd_gfm package to generate a download URL

SELECT fnd_gfm.construct_download_url (fnd_web_config.gfm_agent,
                                                           (SELECT fdt.media_id
                                                              FROM apps.fnd_documents fdt,
                                                                   fnd_attached_documents fad
                                                             WHERE fdt.document_id = fad.document_id
                                                               AND fad.entity_name = l_entity_name
                                                               AND pk1_value = l_trx_no)
                                                            ) DownloadLink
FROM DUAL;

but as the problem of OP was that it always asks user credentials before getting access to the document.

The solution is by invoking this statement through a form where user is currently logged in, not as a standalone code.

since i am using this in a workflow attachment message, it does not have problems in asking for user credentials.

Hope this helps!