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.
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:
store WHERE store = TO_NUMBER ( :b0 )
store st , vat_region vr WHERE st . store = :b0 AND st . vat_region = vr .
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