My Oracle Support Banner

CALCULATE TAX DURING IMPORT FLAG GETTING CHECKED WHEN NULL VALUE IS INSERTED (Doc ID 1679512.1)

Last updated on OCTOBER 12, 2020

Applies to:

Oracle Payables - Version 12.0.0 to 12.1.3 [Release 12.0 to 12.1]
Information in this document applies to any platform.
CALCULATE TAX DURING IMPORT FLAG GETTING CHECKED WHEN NULL VALUE IS INSERTED


Issue Summary: When customer import the data in the interface table with the
source as Invoice Gateway, these invoices are visible from Quick Invoice
workbench.
While inserting the data if the column CALC_TAX_DURING_IMPORT_FLAG is marked
as NULL then in the form this value seems to be checked, but the tax is not
getting calculated.

So customer question is
CALC_TAX_DURING_IMPORT_FLAG should be Y in case of YES and N or NULL in
case of NO. So why is the form showing Y when it is NULL?

The behavior is not consistent with the documentation. The invoice import
also does not calculate tax if the column is null

Symptoms

CALCULATE TAX DURING IMPORT FLAG GETTING CHECKED WHEN NULL VALUE IS INSERTED IN THE PAYABLES OPEN INTERFACE TABLES

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
References


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