GLDIST Table Missing Tax Lines Due To Corrupt Tax Lines in ZX_LINES and RA_CUSTOMER_TRX_LINES Tables
Last updated on JUNE 13, 2017
Applies to:Oracle Receivables - Version 12.1.3 and later
Information in this document applies to any platform.
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.
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