Incorrect calculation of the Functional Currency amount in the Invoice Workbench APXINWKB after running the Payables Open Interface Import APXIIMPT .
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
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
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.
During the import process the invoice amount will be adjusted and a TAX line will be created.
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
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