Forum Stats

  • 3,854,599 Users
  • 2,264,390 Discussions
  • 7,905,734 Comments

Discussions

EBS XML Publisher Report RTF Template and bursting of output to XLS, cell in xls file shows 2.18E+14

User_ORR9T
User_ORR9T Member Posts: 2 Green Ribbon

Oracle EBS XML Publisher Report RTF Template and bursting of output to XLS, need alphanumeric format for a column in RTF

It's XML Publisher report registered as a concurrent program in Oracle EBS R12. Executable: XDODTEXE, Executable Method: Java Concurrent Program. Output Format XML. Template of Data Definition is RTF.

Excel output of the report is being emailed to users. The xls output is showing invoice_number as 2.18E+14, instead of “218000000001774”. Please let me know if you know of a way to format it in the RTF. The field can have alphanumeric values. My example output just has numeric. Thanks for your help. If we click on the cell in excel the value is displayed on top section correctly, but inside cell it is displayed as 2.18E+14. Please explain how I can pre-format invoice_number field in the RTF so that when the excel output is sent out in e-mail by bursting, it is displayed as 218000000001774.

Relevant section of code from the XML Data Definition

  <sqlStatement name="Q1">
  <![CDATA[SELECT ' '||invoice_number    invoice_number,
                  ' '||message           error_message,
                  message_group     error_group
             FROM pref_errors
            WHERE file_id = (
                            SELECT MAX(file_id)
                              FROM pref_control
                             WHERE file_type = 'PREF'
                            )
            GROUP BY invoice_number,
                     message,
                     message_group
            ORDER BY invoice_number,
                     message_group]]>
  </sqlStatement>


<dataStructure>
     <group name="G1" source="Q1">
           <element name="INVOICE_NUMBER "             value="INVOICE_NUMBER"/>
           <element name="ERROR_MESSAGE"               value="ERROR_MESSAGE"/>
           <element name="ERROR_GROUP"                 value="ERROR_GROUP"/>
     </group>
</dataStructure>
<datatrigger name="SUBMIT_XML_BURST_FCN" source="CUSTOM_COMMON_UTIL_PKG.SUBMIT_XML_BURST_FCN(:C_REQUEST_ID)"/>
</dataTemplate>

 Run code snippet


Please make note of this section in below code. Template is RTP. output-type is excel
  <xapi:document output= "${C_FILE_NAME}" output-type="excel" delivery="123">
  <xapi:template type="rtf" location="xdo://XXX.XXXAR0059.en.00/?getSource=true"/>
  </xapi:document>

- XML Bursting Code
<xapi:requestset xmlns:xapi="http://xmlns.oracle.com/oxp/xapi" type="bursting">
  <xapi:request select="/">
  <xapi:delivery>
   <xapi:email server="${C_SERVER}" port="${C_PORT}" from="${C_FROM_EMAIL}" reply-to="${C_FROM_EMAIL}">
    <xapi:message id="123" to="${C_EMAIL}" attachment="true"
          subject="${C_INSTANCE} Error Report processed on ${C_DATE} ">

            Error Report, processed at datetime ${C_DATE}. 


    </xapi:message>
   </xapi:email>
  </xapi:delivery>
  <xapi:document output= "${C_FILE_NAME}" output-type="excel" delivery="123">
  <xapi:template type="rtf" location="xdo://XXX.XXXAR0059.en.00/?getSource=true"/>
  </xapi:document>
  </xapi:request>
</xapi:requestset>


Answers