EB-Tax Data Corruption affecting Invoices with Historical_flag='Y'
We have 2 invoices that were placed on LINE VARIANCE hold after a Tax line was discarded but the Tax Amount was not zero-ed out.
So I researched and found Metalink Note: EB-Tax Data Corruption Issues & Recommended Solutions (Doc ID 1316316.1).
Details# 5 of this note (5: Missing Reversal Tax Distributions for Tax Distributions/ Tax lines for discarded or cancelled Transaction Lines are not marked as canceled/ Error AP_ERR_TAX_DIST_SYNC during invoice cancellation), describe the symptoms of our 2 invoices. But when I tried to run the provided IDENTIFICATION SQLs, they did not return our 2 invoices. I found it is because our 2 invoices have HISTORICAL_FLAG = 'Y'.