Problem: The BI Publisher report when run is not calling the beforeReport or afterReport triggers Eventhough the data xml contains call of these procedures
dataTemplate name="MAILORD_REP" defaultPackage="EMAIL_PKG" version="1.0">
<properties>
<property name="xml_tag_case" value="upper" />
<property name="debug_mode" value="on" />
</properties>
<dataQuery>
<sqlStatement name="S_ORDERS">
<![CDATA[
SELECT cwp.order_number, oe.orig_sys_document_ref
,cwp.currency_code,cwp.amount,cwp.date_sent
FROM oe_order_headers_all oe
WHERE 1 = 1
AND oe.org_id =745
AND oe.order_number = cwp.order_number
AND cwp.status = 'ERROR'
AND TRUNC(DATE_SENT) = TRUNC(SYSDATE -1)
ORDER BY cwp.date_sent DESC
]]>
</sqlStatement>
</dataQuery>
<dataTrigger name="beforeReport" source="EMAIL_PKG.beforereport" />
<dataStructure>
<group name="G_ORDERS" source="S_ORDERS">
<element name="ORDER_NUMBER" value="ORDER_NUMBER"/>
<element name="ORIG_SYS_DOCUMENT_REF" value="ORIG_SYS_DOCUMENT_REF"/>
<element name="CURRENCY_CODE" value="CURRENCY_CODE"/>
<element name="AMOUNT" value="AMOUNT"/>
<element name="DATE_SENT" value="DATE_SENT"/>
</group>
</dataStructure>
<dataTrigger name="afterReport" source="EMAIL.afterReport" />
</dataTemplate>
The log file of the concurrent program does not show any log messages added in beforereport and afterreport triggers.
The program is ending normal and the log file is not showing any errors also.
Solution: The reason for not calling any report triggers are because of the missing parameter declaration in the package specification.
You should define all the parameters defined for the concurrent program and token names with the same name in the package specification .
Issue will be resolved
