Skip to Main Content
Forums

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

how to display no data found in RTF template ? XML Publisher

User608206Jul 15 2014 — edited Jul 16 2014

Hi

   I have xml file, how to display no data found in RTF template ? XML Publisher ?

This is the XML File

<?xml version="1.0" encoding="UTF-8"?>

<INVALIDSERIALPRODUCT>

<P_ORG_CODE></P_ORG_CODE><P_DATE_RANGE_FROM></P_DATE_RANGE_FROM><P_DATE_RANGE_TO></P_DATE_RANGE_TO><P_ITEM_NUMBER>VIR</P_ITEM_NUMBER><P_LOT_NUMBER></P_LOT_NUMBER><P_RMA_NUMBER_FROM></P_RMA_NUMBER_FROM><P_RMA_NUMBER_TO></P_RMA_NUMBER_TO><P_CUSTOMER_NAME></P_CUSTOMER_NAME><P_EMAIL></P_EMAIL>

<G_SNQ>

<USER_NAME>NSAWHNEY</USER_NAME>

<G_SN>

<ITEM_NUMBER>VIR823010</ITEM_NUMBER>

<DESCRIPTION/>

<LOT_NUMBER>Viread 245mg,Korea</LOT_NUMBER>

<SERIAL_NUMBER>000000000004</SERIAL_NUMBER>

<RMA_NUMBER>8200000106</RMA_NUMBER>

<CUSTOMER_NAME>Yuhan Corporation Korea</CUSTOMER_NAME>

<COUNTERFEIT_CHECK_DATE>2014-07-11T05:13:05.000-07:00</COUNTERFEIT_CHECK_DATE>

<REASON>Serial number and lot combination not valid in Axway Track-n-Trace.</REASON>

</G_SN>

<G_SN>

<ITEM_NUMBER>VIR823010</ITEM_NUMBER>

<DESCRIPTION/>

<LOT_NUMBER>Viread 245mg,Korea</LOT_NUMBER>

<SERIAL_NUMBER>000000000004</SERIAL_NUMBER>

<RMA_NUMBER>8200000106</RMA_NUMBER>

<CUSTOMER_NAME>Yuhan Corporation Korea</CUSTOMER_NAME>

<COUNTERFEIT_CHECK_DATE>2014-07-11T05:52:23.000-07:00</COUNTERFEIT_CHECK_DATE>

<REASON>Serial number and lot combination not valid in Axway Track-n-Trace.</REASON>

</G_SN>

<G_SN>

<ITEM_NUMBER>VIR823010</ITEM_NUMBER>

<DESCRIPTION/>

<LOT_NUMBER>Viread 245mg,Korea</LOT_NUMBER>

<SERIAL_NUMBER>000000000016</SERIAL_NUMBER>

<RMA_NUMBER>8200000106</RMA_NUMBER>

<CUSTOMER_NAME>Yuhan Corporation Korea</CUSTOMER_NAME>

<COUNTERFEIT_CHECK_DATE>2014-07-11T05:53:06.000-07:00</COUNTERFEIT_CHECK_DATE>

<REASON>Serial number and lot combination not valid in Axway Track-n-Trace.</REASON>

</G_SN>

<G_SN>

<ITEM_NUMBER>VIR823010</ITEM_NUMBER>

<DESCRIPTION/>

<LOT_NUMBER>Viread 245mg,Korea</LOT_NUMBER>

<SERIAL_NUMBER>011000000011</SERIAL_NUMBER>

<RMA_NUMBER>8200000106</RMA_NUMBER>

<CUSTOMER_NAME>Yuhan Corporation Korea</CUSTOMER_NAME>

<COUNTERFEIT_CHECK_DATE>2014-07-11T06:09:16.000-07:00</COUNTERFEIT_CHECK_DATE>

<REASON>Serial number does not exist in Axway Track-n-Trace</REASON>

</G_SN>

<G_SN>

<ITEM_NUMBER>VIR823010</ITEM_NUMBER>

<DESCRIPTION/>

<LOT_NUMBER>Viread 245mg,Korea</LOT_NUMBER>

<SERIAL_NUMBER>000000000021</SERIAL_NUMBER>

<RMA_NUMBER>8200000106</RMA_NUMBER>

<CUSTOMER_NAME>Yuhan Corporation Korea</CUSTOMER_NAME>

<COUNTERFEIT_CHECK_DATE>2014-07-11T06:11:09.000-07:00</COUNTERFEIT_CHECK_DATE>

<REASON>Serial number and lot combination not valid in Axway Track-n-Trace.</REASON>

</G_SN>

<G_SN>

<ITEM_NUMBER>VIR823010</ITEM_NUMBER>

<DESCRIPTION/>

<LOT_NUMBER>Viread 245mg,Korea</LOT_NUMBER>

<SERIAL_NUMBER>000000000001</SERIAL_NUMBER>

<RMA_NUMBER>8200000066</RMA_NUMBER>

<CUSTOMER_NAME>Yuhan Corporation Korea</CUSTOMER_NAME>

<COUNTERFEIT_CHECK_DATE>2014-07-11T06:46:04.000-07:00</COUNTERFEIT_CHECK_DATE>

<REASON>Serial number and lot combination not valid in Axway Track-n-Trace.</REASON>

</G_SN>

<G_SN>

<ITEM_NUMBER>VIR823010</ITEM_NUMBER>

<DESCRIPTION/>

<LOT_NUMBER>Viread 245mg,Korea</LOT_NUMBER>

<SERIAL_NUMBER>000000000001</SERIAL_NUMBER>

<RMA_NUMBER>8200000066</RMA_NUMBER>

<CUSTOMER_NAME>Yuhan Corporation Korea</CUSTOMER_NAME>

<COUNTERFEIT_CHECK_DATE>2014-07-11T07:08:21.000-07:00</COUNTERFEIT_CHECK_DATE>

<REASON>Serial number and lot combination not valid in Axway Track-n-Trace.</REASON>

</G_SN>

<G_SN>

<ITEM_NUMBER>VIR823010</ITEM_NUMBER>

<DESCRIPTION/>

<LOT_NUMBER>Viread 245mg,Korea</LOT_NUMBER>

<SERIAL_NUMBER>00000000004 </SERIAL_NUMBER>

<RMA_NUMBER>8200000066</RMA_NUMBER>

<CUSTOMER_NAME>Yuhan Corporation Korea</CUSTOMER_NAME>

<COUNTERFEIT_CHECK_DATE>2014-07-11T07:13:05.000-07:00</COUNTERFEIT_CHECK_DATE>

<REASON>Unknow Error </REASON>

</G_SN>

<G_SN>

<ITEM_NUMBER>VIR823010</ITEM_NUMBER>

<DESCRIPTION/>

<LOT_NUMBER>Viread 245mg,Korea</LOT_NUMBER>

<SERIAL_NUMBER>000000000011</SERIAL_NUMBER>

<RMA_NUMBER>8200000101</RMA_NUMBER>

<CUSTOMER_NAME>Yuhan Corporation Korea</CUSTOMER_NAME>

<COUNTERFEIT_CHECK_DATE>2014-07-11T19:32:00.000-07:00</COUNTERFEIT_CHECK_DATE>

<REASON>Serial number and lot combination not valid in Axway Track-n-Trace.</REASON>

</G_SN>

<G_SN>

<ITEM_NUMBER>VIR823010</ITEM_NUMBER>

<DESCRIPTION/>

<LOT_NUMBER>Viread 245mg,Korea</LOT_NUMBER>

<SERIAL_NUMBER>000000000004</SERIAL_NUMBER>

<RMA_NUMBER>8200000107</RMA_NUMBER>

<CUSTOMER_NAME>Yuhan Corporation Korea</CUSTOMER_NAME>

<COUNTERFEIT_CHECK_DATE>2014-07-14T02:49:40.000-07:00</COUNTERFEIT_CHECK_DATE>

<REASON>Serial number and lot combination not valid in Axway Track-n-Trace.</REASON>

</G_SN>

<G_SN>

<ITEM_NUMBER>VIR823010</ITEM_NUMBER>

<DESCRIPTION/>

<LOT_NUMBER>Viread 245mg,Korea</LOT_NUMBER>

<SERIAL_NUMBER>000000000092</SERIAL_NUMBER>

<RMA_NUMBER>8200000109</RMA_NUMBER>

<CUSTOMER_NAME>Yuhan Corporation Korea</CUSTOMER_NAME>

<COUNTERFEIT_CHECK_DATE>2014-07-14T07:52:22.000-07:00</COUNTERFEIT_CHECK_DATE>

<REASON>Serial number and lot combination not valid in Axway Track-n-Trace.</REASON>

</G_SN>

<G_SN>

<ITEM_NUMBER>VIR823010</ITEM_NUMBER>

<DESCRIPTION/>

<LOT_NUMBER>Viread 245mg,Korea</LOT_NUMBER>

<SERIAL_NUMBER>000000000031</SERIAL_NUMBER>

<RMA_NUMBER>8200000109</RMA_NUMBER>

<CUSTOMER_NAME>Yuhan Corporation Korea</CUSTOMER_NAME>

<COUNTERFEIT_CHECK_DATE>2014-07-15T02:24:27.000-07:00</COUNTERFEIT_CHECK_DATE>

<REASON>Serial number and lot combination not valid in Axway Track-n-Trace.</REASON>

</G_SN>

<G_SN>

<ITEM_NUMBER>VIR823010</ITEM_NUMBER>

<DESCRIPTION/>

<LOT_NUMBER>Viread 245mg,Korea</LOT_NUMBER>

<SERIAL_NUMBER>000000000034</SERIAL_NUMBER>

<RMA_NUMBER>8200000109</RMA_NUMBER>

<CUSTOMER_NAME>Yuhan Corporation Korea</CUSTOMER_NAME>

<COUNTERFEIT_CHECK_DATE>2014-07-15T02:30:28.000-07:00</COUNTERFEIT_CHECK_DATE>

<REASON>Catchall fault scope has been executed</REASON>

</G_SN>

<G_SN>

<ITEM_NUMBER>VIR823010</ITEM_NUMBER>

<DESCRIPTION/>

<LOT_NUMBER>Viread 245mg,Korea</LOT_NUMBER>

<SERIAL_NUMBER>000000000010</SERIAL_NUMBER>

<RMA_NUMBER>8200000114</RMA_NUMBER>

<CUSTOMER_NAME>Yuhan Corporation Korea</CUSTOMER_NAME>

<COUNTERFEIT_CHECK_DATE>2014-07-15T03:36:18.000-07:00</COUNTERFEIT_CHECK_DATE>

<REASON>Serial number and lot combination not valid in Axway Track-n-Trace.</REASON>

</G_SN>

<G_SN>

<ITEM_NUMBER>VIR823010</ITEM_NUMBER>

<DESCRIPTION/>

<LOT_NUMBER>Viread 245mg,Korea</LOT_NUMBER>

<SERIAL_NUMBER>000000000158</SERIAL_NUMBER>

<RMA_NUMBER>8200000114</RMA_NUMBER>

<CUSTOMER_NAME>Yuhan Corporation Korea</CUSTOMER_NAME>

<COUNTERFEIT_CHECK_DATE>2014-07-15T04:19:48.000-07:00</COUNTERFEIT_CHECK_DATE>

<REASON>Serial number and lot combination not valid in Axway Track-n-Trace.</REASON>

</G_SN>

</G_SNQ>

</INVALIDSERIALPRODUCT>

thanks

nks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 13 2014
Added on Jul 15 2014
#general-xml, #xml
2 comments
2,941 views