My Oracle Support Banner

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.


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."




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
 1. Bug Summary
 2. Fixed Files
 3. Recommended Patches
 4. Solution Steps

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.