You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Attachment type Text loaded via REST API on AR Invoice is not visible on Report

Received Response
122
Views
1
Comments
edited Jun 9, 2021 5:47PM in Receivables & Collections 1 comment

Summary

Attachment type Text loaded via REST API on AR Inv is not visible on Report

Content

Hello, We are unable to see the uploaded attachment type text in the report output. When uploading the same manually its working and showing on report. When checked in detail we found FND_DOCUMENTS_TL Title column is not populated via API. Please find the API details attached here FYR We designed the Datamodel as Type ContentServer and used the ID as the dm_version_number from below table This is the reference SQL which we have use dto get the ID SELECT fdv.dm_version_number ContentServerId FROM fnd_documents_vl fdv, fnd_attached_documents fad WHERE fad.document_id = fdv.document_id AND fdv.datatype_code = 'TEXT' AND fad.entity_name = 'RA_CUSTOMER_TRX_ALL'

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!