Incorrect calculation of the Functional Currency amount in the Invoice Workbench APXINWKB after running the Payables Open Interface Import APXIIMPT . (Doc ID 1313505.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Payables - Version 12.0.6 to 12.1.3 [Release 12.0 to 12.1]
Oracle Inventory Management - Version 12.0.6 to 12.1.3 [Release 12 to 12.1]
Information in this document applies to any platform.
Report:APXIIMPT.RDF - Payables Open Interface Import
Executable:POXPOIV - Pay On Receipt AutoInvoice
Form:APXINWKB.FMB - Invoice Workbench


Symptoms

On Applications
Find incorrect calculation of Functional Currency amount in the Invoice Workbench after running the Payables Open Interface Import when the interface table flag Add Tax To Invoice Amt is set Yes.

-- Expected Behaviour
Expect to adjust the functional currency amount (BASE_AMOUNT) if CALC_TAX_DURING_IMPORT_FLAG and ADD_TAX_TO_INV_AMT_FLAG are
set to 'Y' like the amount in the table AP_INVOICES_ALL

-- Steps
1) populate the AP interface tables via the Pay on Receipt process.
Only one ITEM line with the columns CALC_TAX_DURING_IMPORT_FLAG and ADD_TAX_TO_INV_AMT_FLAG set to Yes is created.
2)
During the import process the invoice amount will be adjusted and a TAX line will be created.
3)
Check the BASE_AMOUNT from the table AP_INVOICES_ALL which shows only the converted
net (ITEM) amount rather than the converted ITEM plus TAX amount

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