AR Financial Tax Register Showing Duplicate Lines for Numerous Transactions

(Doc ID 1622033.1)

Last updated on MARCH 08, 2017

Applies to:

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

Symptoms

Financial Tax Register is showing duplicate lines for numerous transactions.

This report is showing receipts on the report multiple times, with different amounts coming from the column: AR_RECEIVABLE_APPLICATIONS_ALL.TAX_EDISCOUNTED

CE-AR288999 for example is listed 20 times on the report. Others rows are duplicated 49 times.

This is causing the tax register to be off from the GL Vat accounts, and it cannot be reconciled.

File Versions:
"/* $Header: zxricoreplugpvtb.pls 120.12.12010000.67
"/* $Header: zxriextractwpkgb.pls 120.43.12010000.23
"/* $Header: zxriextrajgppvtb.pls 120.4.12010000.15
"/* $Header: zxrigextractpvtb.pls 120.26.12010000.14
"/* $Header: zxripextractpvtb.pls 120.44.12010000.34
"/* $Header: zxriextrajlppvtb.pls 120.38.12010000.30
"/* $Header: zxrirpopulatpvtb.pls 120.41.12010000.53
"/* $Header: zxrippopulatpvtb.pls 120.35.12010000.42
"/* $Header: zxrirextractpvtb.pls 120.60.12010000.77

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