Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
Attachment type Text loaded via REST API on AR Invoice is not visible on Report — Cloud Customer Connect
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
8
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!