My Oracle Support Banner

When Running Batch Job Saimptlogi - There is Excessive Time/waits Spent On VAT Related Queries when not using VAT (Doc ID 2622161.1)

Last updated on DECEMBER 23, 2019

Applies to:

Oracle Retail Sales Audit - Version 16.0.2 and later
Information in this document applies to any platform.

Symptoms

When not using VAT (DEFAULT_TAX_TYPE = 'SALES'), however when running saimptlog the trace file shows excessive waits related to VAT based queries. Regardless of the reason for the waits, the code should not run for a client not using VAT (i.e. US based client). The following queries are being executed many times:

SELECT vat_include_ind
FROM
store WHERE store = TO_NUMBER ( :b0 )

and

SELECT vat_calc_type
FROM
store st , vat_region vr WHERE st . store = :b0 AND st . vat_region = vr .
 vat_region


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.