R12 Upgrade Data Corruption : Zx_rec_nrec_dist.rec_nrec_rate = 100% For All Migrated Data

(Doc ID 2086552.1)

Last updated on DECEMBER 16, 2015

Applies to:

Oracle E-Business Tax - Version 12.2.4 and later
Information in this document applies to any platform.
The tax upgrade (as shown in zxaptrxmigupd.sql) is hard coding the rec_nrec_rate in zx_rec_nrec_dist to 100 (starting with zxaptrxmigupd.sql version 120.39)
Whereas AP upgrades differently the AP_invoice_distributions_all.rec_nrec_rate.
Found that the rec_nrec_rate is hard coded to 100 as per Bug 5460388 - POPULATE REC_TYPE_CODE, REC_RATE_CODE(ID) FROM ZX_RATES_B IN AP MIGRATION.
Bug 7830021 - ISSUE WITH TAX RECOVERY RATE COLUMN VALUE(MIGRATED INVOICES)
Bug 11721328 : REC_NREC_RATE IS STAMPED AS 0 IN AP_INVOICE_DISTRIBUTIONS_ALL FOR HISTORICAL INV


As per above, what of the above values should be used in report processing ?

Goal

Impact Of Rec_nrec_rate Hard Coded As 100 In Zx_rec_nrec_dist by Tax Upgrade On Tax Reporting

Solution

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