My Oracle Support Banner

Transactions Workbench Issue: TAX Records Are Missing in RA_CUST_TRX_LINE_GL_DIST Table for the Credit Memo (Doc ID 1908964.1)

Last updated on OCTOBER 10, 2024

Applies to:

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

Symptoms

There are A few TAX records, which are having PREVIOUS_CUSTOMER_TRX_LINE_ID stamped as NULL, in the RA_CUSTOMER_TRX_LINES table for regular Credit Memos.
As a result, the distributions are missing in the RA_CUST_TRX_LINE_GL_DIST table for these TAX Records.

Since the ADJUSTED_DOC_TAX_LINE_ID column is not populated in the ZX_LINES table, the PREVIOUS_CUSTOMER_TRX_LINE_ID is populated as null in the RA_CUSTOMER_TRX_LINES table and TAX records are missing in the RA_CUST_TRX_LINE_GL_DIST table.

Changes

 

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
Changes
Cause
Solution
 1. Bug Summary
 2.  Fixed File
 3. Recommended Patches
 4. Solution Steps
 5. Identify Possible Data Corruption
 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.