Oracle Reports XML Output
Hi,
We are using an Oracle Report for XML Output. I am getting the output by adding XML Tag in the column/group properties not by an XML Publisher Template.
Currently I am getting the output as
-<PaymentRec>
-<PaymentDetail>
-<InvoiceInfo></InvoiceInfo>
</PaymentDetail>
</PaymentRec>
-<PaymentRec>
-<PaymentDetail>
-<InvoiceInfo></InvoiceInfo>
</PaymentDetail>
</PaymentRec>
For each Invoice I am getting a separate PaymentRecord.
The requirement is to have Only 1 PaymentRecord for all the Invoices under that Payment Record. Which will make it look like:
-<PaymentRec>
-<PaymentDetail>
-<InvoiceInfo></InvoiceInfo>
-<InvoiceInfo></InvoiceInfo>
-<InvoiceInfo></InvoiceInfo>
</PaymentDetail>
</PaymentRec>
-<PaymentRec>
-<PaymentDetail>
We are using an Oracle Report for XML Output. I am getting the output by adding XML Tag in the column/group properties not by an XML Publisher Template.
Currently I am getting the output as
-<PaymentRec>
-<PaymentDetail>
-<InvoiceInfo></InvoiceInfo>
</PaymentDetail>
</PaymentRec>
-<PaymentRec>
-<PaymentDetail>
-<InvoiceInfo></InvoiceInfo>
</PaymentDetail>
</PaymentRec>
For each Invoice I am getting a separate PaymentRecord.
The requirement is to have Only 1 PaymentRecord for all the Invoices under that Payment Record. Which will make it look like:
-<PaymentRec>
-<PaymentDetail>
-<InvoiceInfo></InvoiceInfo>
-<InvoiceInfo></InvoiceInfo>
-<InvoiceInfo></InvoiceInfo>
</PaymentDetail>
</PaymentRec>
-<PaymentRec>
-<PaymentDetail>
0