Categories
- All Categories
- 149 Oracle Analytics News
- 27 Oracle Analytics Videos
- 14.7K Oracle Analytics Forums
- 5.7K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 54 Oracle Analytics Trainings
- 12 Oracle Analytics Data Visualizations Challenge
- 4 Oracle Analytics Career
- 2 Oracle Analytics Industry
- Find Partners
- For Partners
Custom PO Print - Text Attachment Content on BI Publisher Report

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
Comments
-
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
0 -
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
0