Receivables Reports (Adjustment Register Report, Sales Journal by Customer and Sales Journal by GL Account) Fetching Duplicate Records

(Doc ID 888437.1)

Last updated on AUGUST 28, 2017

Applies to:

Oracle Receivables - Version 12.0.6 and later
Information in this document applies to any platform.
This problem can occur on any platform.
ConcurrentProgram:ARRXARPB - Adjustment Register
REPORT:RAXGLA.RDF - Sales Journal By Customer
REPORT:RAXGLR.RDF - Sales Journal by GL Account Report

Symptoms

Attempting to run the following reports and find there are duplicate records in certain scenario causing ORA-01403 no data found in some reports:

Adjustment Register Report
Sales Journal by Customer
Sales Journal by GL Account

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