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

Last updated on AUGUST 28, 2017

Applies to:

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

Symptoms

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.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms