BI Publisher (MOSC)

MOSC Banner

SQL did not retrieve data in XML

edited May 9, 2017 10:12AM in BI Publisher (MOSC) 19 commentsAnswered

Hi All,

Below is the data template XML loaded and ran the program with parameter  01-JAN-2016 and 10-JAN-2016.The request completed normally but  the output shows only the name . I ran the query normally in TOAD and it gives records.

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

- <CPD_AP_PO_INV_REPORT>

<LIST_G_CPD_INVOICE_DETAILS />

</CPD_AP_PO_INV_REPORT>

  • Below is the data template XML:

-------------------------------------------

Please let me know what might be the issue.

<?xml version="1.0" encoding="UTF-8" ?><!--========================================================================= --><!-- CPD AP INVOICE DETAILS--><!-- Chicago Park District --><!--========================================================================= --><!-- Name : CPD_AP_PO_INV_REPORT --><!-- Description : AP Invoice Payment Details Report--><!-- --><!-- --><!-- --><!-- --><!--Change Record: --><!--=============== --><!--Version Date Author Remarks --><!--======= ========== =============== ======================= --><!--1.0 03-MAY-2017 Harish Ventrapragada Initial version --><!--==========================================================================--><dataTemplate version="1.0" description="CPD_AP_INVOICE_DETAILS" name="CPD_AP_PO_INV_REPORT"><properties><property name="scalable_mode" value="on"/></properties><properties><property name="db_fetch_size" value="20"/></properties><properties>

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center