AP Invoice for Inter company transaction

The Payables Open Interface Import program is creating additional tax line in a multiple lines scenario.

scenario #1:Single line item

AR Invoice {single line trx)
Dr. Receivables 180
Cr. Revenue 150
Cr. Tax 30 [20% tax rate]

AP Invoice {single line trx)

Dr. Purchases 150
DR. Tax 30 [20% tax rate]
Cr. Payables 180
------------------------
scenario #2:Multiple line item

AR Invoice {multi 2 line trx)
Dr. Receivables 180
Cr. Revenue 100
Cr. Revenue 50
Cr. Tax 30 [20% tax rate]

AP Invoice {multi 2 line trx)

Dr. Purchases 100
Dr. Purchases 50
Dr. Tax 30 [20% tax rate]
Dr. Tax 30 [20% tax rate]
Cr. Payables 210

Extra tax line added [error]
------------------------

scenario #3:Multiple line item

AR Invoice {multi 3 line trx)
Dr. Receivables 180
Cr. Revenue 100
Cr. Revenue 30
Cr. Revenue 20
Cr. Tax 30 [20% tax rate]

AP Invoice {multi 3 line trx)

Dr. Purchases 100
Dr. Purchases 30
Dr. Purchases 20
Dr. Tax 30 [20% tax rate]
Dr. Tax 30 [20% tax rate]
Dr. Tax 30 [20% tax rate]
Cr. Payables 240

Extra 2 tax line added [error]
------------------------

Problem:
Payables Open Interface program creates extra tax line for each additional line item inherited from Receivables.
------------------------
scenario #4:Multiple line item

AR Invoice {multi 4 line trx)
Dr. Receivables 180
Cr. Revenue 60
Cr. Revenue 40
Cr. Revenue 30
Cr. Revenue 20
Cr. Tax 30 [20% tax rate]

AP Invoice {multi 4 line trx)

Dr. Purchases 60
Dr. Purchases 40
Dr. Purchases 30
Dr. Purchases 20
Dr. Tax 30 [20% tax rate]
Dr. Tax 30 [20% tax rate]
Dr. Tax 30 [20% tax rate]
Dr. Tax 30 [20% tax rate]
Cr. Payables 270

Extra 3 tax line added [error]
-----------------------

The Total AR Invoice amount is constant at 180, while Total AP Invoice is incremental with additional tax line for each additional intercompany line transaction.

Please, what could be the cause? Bug in Payables Open Interface Import program or configuration settings in AGIS?

Please I would appreciate your quick assistance. Thanking you in anticipation of your help.

jimi.akinola@yahoo.co.uk
Jimi Akinola
+447527 260 073

Oracle Applications Fusion Cloud - Inventory

Oracle Cloud/Fusion Procurement training will help you develop the fundamental skills required to set up and use the Procurement module. This training covers all the tasks, setups, forms and reports used in Procurement and related modules