BI Publisher (MOSC)

MOSC Banner

Logic to print data in required format for XML

edited Apr 7, 2011 11:08PM in BI Publisher (MOSC) 4 commentsAnswered
 Hi,
Please find the xml format:

<ListOf_ssFsInvoice>
<ssFsInvoice>
<ListOf_ssFsInvoiceLineItems>
<ssFsInvoiceLineItems>
<ListOf_ssFsInvoiceLineItemDetails>
<ssFsInvoiceLineItemDetails>
<ssDnrmPartBillingType>Paid</ssDnrmPartBillingType>
<ListOf_ssFsInvoiceLineItemDetailTaxes>
<ssFsInvoiceLineItemDetailTaxes>
<ssTaxName>VAT</ssTaxName>
<ssAmount>1000</ssAmount>
</ssFsInvoiceLineItemDetailTaxes>
<ssFsInvoiceLineItemDetailTaxes>
<ssTaxName>Entry</ssTaxName>
<ssAmount>2000</ssAmount>
</ssFsInvoiceLineItemDetailTaxes>
<ssFsInvoiceLineItemDetailTaxes>
<ssTaxName>XYZ</ssTaxName>
<ssAmount>500</ssAmount>
</ssFsInvoiceLineItemDetailTaxes>
</ListOf_ssFsInvoiceLineItemDetailTaxes>
</ssFsInvoiceLineItemDetails>
</ListOf_ssFsInvoiceLineItemDetails>
</ssFsInvoiceLineItems>
</ListOf_ssFsInvoiceLineItems>
</ssFsInvoice>
</ListOf_ssFsInvoice>

Requirement:
1.For ssDnrmPartBillingType = Paid print total of ssAmount for similar ssTaxName and repeated items appear only once(similar ssTaxName should appear only once).
2.e.g.
Line item 1:
Paid VAT 1000
Paid Entry 200
Paid XYZ 100
Line item 2:
Paid VAT 100
Paid Entry 100
Paid XYZ 50


Report Output
VAT 1100
Entry 300
XYZ 150

and so on.

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