Custom PO Print - Text Attachment Content on BI Publisher Report

Rahul L

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"
FROM fnd_attached_documents FndAttachedDocumentsEO,
po_headers_draft_all headers,
po_versions versions,
fnd_documents_vl FndDocumentsEO
WHERE ( ( FndAttachedDocumentsEO.pk1_value = headers.vendor_site_id
AND FndAttachedDocumentsEO.entity_name = 'POZ_SUPPLIER_SITES_ALL_M' )
OR ( FndAttachedDocumentsEO.pk1_value = headers.po_header_id
AND FndAttachedDocumentsEO.pk2_value = versions.version_id
AND FndAttachedDocumentsEO.entity_name = 'PO_HEADERS' ) )
AND FndAttachedDocumentsEO.category_name = 'TO_SUPPLIER'
AND ( FndAttachedDocumentsEO.entity_name = 'PO_HEADERS' )
AND headers.po_header_id = versions.po_header_id
--AND versions.co_sequence = Nvl(:param_co_num, 0)
and headers.po_header_id = 103018
AND ( FndAttachedDocumentsEO.document_id = FndDocumentsEO.document_id )
2) Create a datalink from Header Dataset (PODetailsQuery) to this dataset based on PoHeaderId.
3) Create another dataset based on content server (FA_UCM_PROVISIONED) and select the previous dataset as the parent group and map the Document Id from the previous dataset.

But in this case we are getting an Error "You Cannot Create a link to a Child Group as it is having a Parent Group".

Do we have any other approach to get the PO Attachment Content details on the BI Fusion Report.
 

 

Version

19c

Lowell Stang

I am experiencing the same behavior in BI Publisher when attempting to add a Content Server dataset: Error "You Cannot Create a link to a Child Group as it is having a Parent Group".  Content Server connectivity test is successful.

Version: 19D

Robert Fighiroae-Oracle

Hi Rahul,

This is a known issue identified in 19C/19D.

The fix has been delivered in Fusion 20A.

Are you still encountering the same error message?

Kind regards,

Robert