Performance: CALCULATE TAX Takes Long Time For Migrated Regimes When There Are Huge Number Of Taxes. (Doc ID 1540515.1)

Last updated on NOVEMBER 23, 2015

Applies to:

Oracle Payables - Version 12.1.2 to 12.1.2 [Release 12.1]
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, EB Tax

Performance problem in the Invoice workbench (APXINWKB) when entering a new invoice:

The problem only happens when the date of the invoice being created is before the 'end date' of the regime.
The performance problem happens when CALCULATE TAX button is clicked.
The tax calculation takes almost 10 minutes.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. End date the regime at an specific date ie: jan 24th
2. Enter an invoice for Jan23rd (prior to the end date)
3. Click on CALCULATE TAX. It takes almost 10 minutes to complete the calculation.
4. This performance problem does not happen for invoices that are entered with a date Jan 25th or forward.

The TKPROF does not show any SQL statement that takes long time.

However the trace file ( extension .trc ) shows that
the call to AP_ETAX_PKG.CALLING_ETAX is taking long time.

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