EBS Customizations (MOSC)

MOSC Banner

Oracle Reports XML Output

edited Apr 30, 2011 8:42PM in EBS Customizations (MOSC) 5 commentsAnswered
 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>

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