RA_CUST_TRX_LINE_GL_DIST_ALL Table Missing Tax Lines Due To Corrupt Tax Lines in ZX_LINES and RA_CUSTOMER_TRX_LINES Tables
(Doc ID 2073799.1)
Last updated on JULY 26, 2024
Applies to:
Oracle Receivables - Version 12.1.3 and laterInformation in this document applies to any platform.
Symptoms
Tax rows to not generate in the ra_cust_trx_line_gl_dist_all table causing unbalanced distributions and the credit memo fails posting.
The ra_customer_trx_lines_all table is missing the previous_customer_trx_id and previous_customer_trx_line_id for several rows.
The underlying causes of this is that the zx_lines table is missing several ADJUSTED_DOC_TAX_LINE_ID values
Because this table is missing some values, the lines table is not picking up the 'previous' column references correctly.
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 |
References |