The Due Date and Invoice Date in AR Customer Balance Statement Letter Are Wrong (Doc ID 1611341.1)

Last updated on APRIL 03, 2025

Applies to:

Symptoms

The Due Date and Invoice Date  in AR Customer Balance Statement Letter report are wrong. It happens for old transactions and the issue is not reproducible for new invoices.

Example:
1.  PDF output of the report shows for one of the invoices:
Invoice Number Transaction Type Invoice Date  Due Date       Currency Amount      Amount Due
60023349         Invoice              18-NOV-2010 18-NOV-2010  GBP       90,000.00   42,100.00

2. Per transaction diagnostics Trx Date 01-AUG-2007 and Due Date 01-AUG-2007 should be displayed instead:

Customer Trx Id 432804
Transaction Number 60023349
Trx Date 01-AUG-2007
Due Date 01-AUG-2007

3. The latest PDF output of the report shows different dates:

Invoice Number Transaction Type  Invoice Date     Due Date          Currency  Amount     Amount Due
60023349         Invoice                19-SEP-2007    31-DEC-2010     GBP        90,000.00  42,100.00

There is no consistency in displaying dates for this invoice.

Cause

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