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

Last updated on AUGUST 31, 2016

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

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