General Ledger & Intercompany

Get Involved. Join the Conversation.

Topic

    angela ahrens
    sql on showing manual journal entries with missing...
    Topic posted October 31, 2019 by angela ahrensRed Ribbon: 250+ Points 
    29 Views, 2 Comments
    Title:
    sql on showing manual journal entries with missing attachments
    Summary:
    sql on showing manual journal entries with missing attachments
    Content:

    anyone have sql on manual journal entries with missing attachments

    Comment

     

    • Ravi Kanth Vuddagiri

      The attachment gets stored first in UCM when it is added into Journal. Later when it is submitted for approval the same gets stored in SOA side as well if the total size of attachments added to a specific journal are less than 5MB [Whatever fits in that 5MB only saved as attachment and rest will be URLs].
      From SOA side with archival job in place, the data gets removed from SOA DB periodically.

      Please refer the below tables for attachment details :

      select * from fusion.fnd_attached_documents
      select * from fusion. FND_DOCUMENTS_TL
      select * from fusion.FND_DOCUMENTS


      SQL> select customer_trx_id from fusion.ra_customer_trx_all where trx_number like '1234')

      Query to validate the attached document :

      SQL> select TITLE,DOCUMENT_ID from fusion.FND_DOCUMENTs_tl
      where DOCUMENT_ID in ( select DOCUMENT_ID from fusion.FND_attached_DOCUMENTS where PK1_VALUE = '112233445566' )
      and LANGUAGE = 'US'


      Note : PK1 - customer_trx_id

    • angela ahrens

      i already figured it out ... thanks for the post..