How to extract BLOB image in data template
I am trying to extract a blob image for insert into a BI Publisher report in EBS 12.1.3. Below is my data template which appears to work, but I can not get the blob image to render; the Q_ATTCHMT section is the query from FND_LOBS. Is this the correct way to extract the blob image from the database?
<?xml version="1.0" encoding="utf-8"?>
<dataTemplate name="PRODCARD" description="Production Card Data" Version="1.0" dataSourceRef="TESTNEW">
<properties>
<property name="include_parameters" value="true" />
<property name="debug_mode" value="on" />
</properties>
<parameters>
<parameter name="JOB_FROM" dataType="character" />
<parameter name="ORG_ID" dataType="number" />