Invoice Print Issues: Printing Selected Invoices Does Not Print Because Term_id Does Not Match (Doc ID 362151.1)

Last updated on AUGUST 24, 2016

Applies to:

Oracle Receivables - Version 11.5.9 to 11.5.10.3 [Release 11.5.9 to 11.5.10]
Information in this document applies to any platform.
ConcurrentProgram:RAXINV_SEL - Invoice Print Selected Invoices


Symptoms

Invoice Print Selected Invoices report does not print the selected invoice.

A trace file was generated from the report when run from a special trace user, which was setup using the instructions in <note:296559.1> to trace 10046 at level 4.

This trace shows that the statement that returns no rows is :-

The transaction data diagnostic script, <Note 223834.1>,  shows data corruption: The term_id in ra_customer_trx_all and ar_payment_schedules_all are different.

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