My Oracle Support Banner

Invoice Print Selected Invoices Not Grouping Properly When Using XML Output (Doc ID 1992226.1)

Last updated on FEBRUARY 11, 2019

Applies to:

Oracle Receivables - Version 12.1.3 and later
Information in this document applies to any platform.


You are having problems with the Invoice Print Selected Invoices Grouping.

You converted the report to use an XML template, to change the layout, but if you run the report for an invoice number that exists twice for the same customer & operating unit (different invoice types), the XML code is grouped funny.

The customer_trx_id in G_INVOICES is only displayed once (id 786479). However, the second invoice is displayed under G_INV_TERM.
Since there is no reason to group by inv_term in the XML, it is just repeating on G_LINES, this causes all lines to be displayed under the one G_INVOICES group.

Each invoice should be listed separately as G_INVOICES.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.