My Oracle Support Banner

R12: AP: Open Interface Import Program (APXIIMPT) Validation Process Created a New Tax Line Causing a Line Variance Hold (Doc ID 1980100.1)

Last updated on APRIL 20, 2023

Applies to:

Oracle Payables - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On :  12.1.3 version, Open Interface and Inv Import

ACTUAL BEHAVIOR  
---------------

When running the Submit Payables Open Interface Import program, the invoice shown below imported successfully.  But after validation, a new tax line was added, which caused a Line Variance hold to be applied to the invoice.

 

EXPECTED BEHAVIOR
-----------------------

After invoice validation, no new tax line will be added, invoice can pass the validation.

 

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Original interface data:

AP_INVOICE_LINES_INTERFACE

LINE_TYPE_LOOKUP_CODE LINE_GROUP_NUMBER PRORATE_ACROSS_FLAG AMOUNT
ITEM     100
ITEM     200
ITEM     0
ITEM 1   400
TAX 1 Y 32

 

2. Invoice data, after importing:

AP_INVOICE_LINES_ALL

LINE_TYPE_LOOKUP_CODE LINE_GROUP_NUMBER LINE_SOURCE AMOUNT
ITEM   IMPORTED 100
ITEM   IMPORTED 200
ITEM   IMPORTED 0
ITEM 1 IMPORTED 400
TAX 1 IMPORTED 32

 

3. Invoice data, after invoice validation:

AP_INVOICE_LINES_ALL

LINE_TYPE_LOOKUP_CODE LINE_GROUP_NUMBER LINE_SOURCE AMOUNT
ITEM   IMPORTED 100
ITEM   IMPORTED 200
ITEM   IMPORTED 0
ITEM 1 IMPORTED 400
TAX 1 IMPORTED 32
TAX   ETAX 24

*the new added tax line

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
 Have more questions?
References


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