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

Custom PO Print - Text Attachment Content on BI Publisher Report

25
Views
2
Comments
edited Jan 7, 2020 5:22PM in General Transactional Reporting (OTBI) 2 comments

Summary

We are creating a custom report where we need to display the Content of Text attachment for a Purchase Order. This information is not being stored in seeded Document tables but creating a file in UCM

Content

We are creating a custom report where we need to display the Content of Text attachment for a Purchase Order. This information is not being stored in seeded Document tables but creating a file in UCM with .txt file.

Approach we Tried:
i) Create a SQL dataset “DocumentID” with the corresponding query:
SELECT FndDocumentsEO.dm_version_number AS "DOCUMENT_ID",
headers.po_header_id AS "PoHeaderId"

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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