My Oracle Support Banner

R12: AP/EBTAX: When the User Queries an Invoice With CALC_TAX_DURING_IMPORT_FLAG As NULL, the Quick Invoices Form Is Showing the Value As Checked (Doc ID 1679512.1)

Last updated on FEBRUARY 04, 2025

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

When the user queries an invoice with CALC_TAX_DURING_IMPORT_FLAG as NULL, the quick invoices form is showing the value as checked.

Steps to reproduce:

============

1. Payables Manager
2. Quick Invoice form: Invoice > Enter > Invoice
3. Quick invoices form shows the fields 'Calculate Tax During Import' and 'Add Tax to Invoice Amount' as checked when the underlying values in the interfaces table
are NULL.

 

Changes

 

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
Changes
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.