1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Table name to find the attachments created in journal batches

Discussion in 'Oracle Financials' started by kartheekbk, Sep 3, 2015.

  1. kartheekbk

    kartheekbk Active Member

    Likes Received:
    Trophy Points:
    Hi Forum,

    I have created one journal batch, from the attachment button, I gave two attachments names with data type: Web Page and two other attachment names with Data type: Long text and Short Text

    as my understanding, Journal batch attachement names are stored in the table: fnd_attached_docs_form_vl

    with the following query:

    SELECT distinct URL
    FROM fnd_attached_docs_form_vl
    WHERE pk1_value = <batch_id>

    now the results showing only two records of data type : web page..

    Can you help me to find out the attachment names created for other data types ?
    please find the image attached.



    Attached Files:

    Last edited: Sep 3, 2015