European Sales Listing Report Not Printing The Accounts Receivable Transaction Number (Doc ID 1924917.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Fusion Tax - Version 11.1.7.0.0 and later
Information in this document applies to any platform.

Symptoms

The European Sales Listing Report is not printing the Accounts Receivable transaction number in the transaction number column. Instead of the Accounts Receivable transaction number (which is the document sequence number), the transaction source sequence is printed.

The number of the same invoice is different between the tables ZX_LINES and RA_CUSTOMER_TRX_ALL.

A number of SQL statements were run to review the contents of the tables and confirm whether or not there was an issue with the tracking of the Transaction Number as follows :

 

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