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

Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

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

Received Response
41
Views
2
Comments
Anhall
Anhall Rank 3 - Community Apprentice
in Oracle Analytics Cloud and Server

Summary

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

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!

Answers

  • Anhall
    Anhall Rank 3 - Community Apprentice

    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:

    <group name="PAYSLIP_REPORT" source="Q_PAYSLIP_REPORT">

    <element name="PAYSLIP_DATA" value="PAYSLIP_DATA" />

    </group>

    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
    User910243567 Rank 6 - Analytics Lead

    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.