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 MARCH 08, 2017

Applies to:

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

Symptoms

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:

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:
INTERFACE_LINE_CONTEXT INTERFACE_LINE_ATTRIBUTE1 INTERFACE_LINE_ATTRIBUTE2
LINE_TYPE AMOUNT TAX_RATE_CODE REFERENCE_LINE_ID
---------------------- ------------------------- -------------------------
--------- ------ ------------- -----------------
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.

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