You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Announcing a new experience for the Oracle Analytics community coming April 4th!
This category will be read-only as we migrate this space from 3/30-4/4, after which you’ll be able to post as usual. See you there!

XML Report RTF Design

Received Response
13
Views
3
Comments
edited Sep 11, 2019 5:18AM in Oracle Analytics 3 comments

Summary

To display AP Invoice and PO details with distinct values

Content

Hi Dear all,

I am working on a XML Publisher report which displays VENDOR NAME, INV_BATCH, INVOICE_NUM, PO_NUM, PO_LINE, PO_LINE_AMOUNT

I am using the below xml sample data:

======================================================

<?xml version="1.0" encoding="UTF-8"?>
<XXAPINVPODETAILS>
<LIST_G_SUM>
<G_SUM>
<INV_VEN>ABC VENDOR NAME</INV_VEN>
<BATCH_NAME>TEST_BATCH</BATCH_NAME>
<INV_NUM>   TEST_INV_001</INV_NUM>
<PO_NUM>          1000</PO_NUM>
<PO_LNUM>2</PO_LNUM>
<PO_LAMT>50</PO_LAMT>
</G_SUM>
<G_SUM>
<INV_VEN>ABC VENDOR NAME</INV_VEN>
<BATCH_NAME>TEST_BATCH</BATCH_NAME>

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!