GLDIST 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 JUNE 13, 2017

Applies to:

Oracle Receivables - Version 12.1.3 and later
Information 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.

Changes

 

Cause

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