Is it possible to use BI Publisher in EBS without a data template?

Question

Summary

Content

Our goal is to make a PDF report of pay slips. We want to use the same procedure that the Online Payslip uses to generate XML data, but how can we pass that to the BI Publisher engine? Since the data is already XML and stored in a BLOB, there is no good way of using that in a data template SQL query. Is it possible to use BI Publisher in EBS without a data template? How can we call the BI Publisher engine to use this XML data and combine it with an RTF template to produce PDF? I have seen it is possible with Java, but the requirement is only use PL/SQL and BI Publisher objects. Thanks for any help or insight!

Anhall · Answer

Can you describe how the BLOB would be mapped to the data definition? Maybe something like, in the data template XML, in the SQL query, you would do: SELECT CUSTOM_PKG.XML_FUNCTION(ASG_ACT.ASSIGNMENT_ACTION_ID) PAYSLIP_DATA FROM HR.PAY_ASSIGNMENT_ACTIONS ASG_ACT WHERE ASG_ACT.ASSIGNMENT_ID = :p_Assignment_Id Then in data structure just use the blob column as a regular element, like: Is that generally what you're suggesting? It seems like that would work, but there would be an extra layer of XML tags around the data. That wouldn't be too much of a problem, just a little messy.

User910243567 · Answer

You can create Conc. Program using package to write BLOB to output then map it to data definition which in turn mapped it to template definition.