Tax Partner Integration: Credit Memo Tax Lines created via Autoinvoice are not linked to Invoice Lines resulting in missing data in RA_CUST_TRX_LINE_GL_DIST_ALL (Doc ID 2923146.1)

Last updated on JANUARY 23, 2023

Applies to:

Oracle E-Business Tax - Version 12.2 and later
Oracle Receivables - Version 12.2 and later
Information in this document applies to any platform.

Symptoms

Customer has integrated Third Party Partner like Vertex for Tax calculation.
Process Autoinvoicing credit tax line do not link up when more then 1 'same' tax exist on the invoice the credit is against.
For Example:
Invoice has multiple taxable lines (more then 1 tax exist) with the same Rate code and different jurisdiction codes.
Credit Memo is also created with similar Tax lines.
All tax lines jurisdictions match between the invoice and credit.
But for some of the tax lines of the Credit Memo, the PREVIOUS_CUSTOMER_TRX_LINE_ID is missing in RA_CUSTOMER_TRX_LINES_ALL.
Same way the ADJUSTED_DOC_TAX_LINE_ID is NULL in ZX_LINES for those lines.
This causes code no Tax records to be created on RA_CUST_TRX_LINE_GL_DIST_ALL.
The transaction is out of balance and will not post.
The Create Accounting program may show error again the Credit Memo,"The subledger journal entry does not balance in the entered currency. Please verify the entered amounts on the journal entry lines."