My Oracle Support Banner

AutoInvoice: Problem Importing When Transactions Has Two Tax Lines (TAX_REGIME_CODE) - Tax Code for Adjusted Document Information is Missing NOT in ZX Repository (Doc ID 1902318.1)

Last updated on JUNE 12, 2018

Applies to:

Oracle Receivables - Version 12.2.1 and later
Information in this document applies to any platform.


Attempting to import a credit memo that has the two or more tax lines (or two TAX_REGIME_CODE) through AutoInvoice and receive the following error:

Tax code for adjusted document information is missing or not in ZX repository

Steps to Reproduce:
1.  Create a transaction which has the following lines:

LINE ID Type Amount Tax Classification
-------- ------ ------ ------------------
4430387 Line 1000
4430392 Tax -204 JPN211
4430393 Tax      0 JPN111

2.  Insert a credit memo data into ra_interface_lines_all with following information:
---------------------- ------------------------- -------------------------
--------- ------ ------------- -----------------
XXG00_AUTO_INVOICES 20140219T-002 1
LINE -1000 4430387
XXG00_AUTO_INVOICES 20140219T-002 2
TAX 0 JPN111 4430393
XXG00_AUTO_INVOICES 20140219T-002 3
TAX 204 JPN211 4430392

3.  Run Autoinvoice Master Program.

Populate either TAX_RATE_ID or TAX_RATE_CODE to create a valid tax line.
If you deactivate one of the TAX_REGIME_CODE, the transactions will import without error.


To view full details, 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 a vibrant support community of peers and Oracle experts.