My Oracle Support Banner

Receipts Workbench: The TAX_LINK_ID Is Populated With Null On Tax Distribution Of AR_DISTRIBUTIONS_ALL Table (Doc ID 1517574.1)

Last updated on APRIL 02, 2019

Applies to:

Oracle Receivables - Version 12 to 12.0.7 [Release 12.0]
Information in this document applies to any platform.

Symptoms

The ar_distributions_all.tax_link_id not populated on tax distributions but is it is populated on "REC" distributions. Due to this Tax Reconciliation Report failing to report few transactions.
In 11i, this column was null for both source types "REC" and "TAX" or "DEFERRED_TAX".

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
 1. Bug Summary
 2. Fixed Files
 3. Recommended Patches
 4. Solution Steps
 5. Identify Possible Data Corruption
 Script Name: fix_null_tax_link_id.sql
 Still Have Questions?
References

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