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.

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

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


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.