RAXTRX - Ebtax Code Takes 38 Hours To Process 400 Rows In Autoinvoice (Doc ID 800674.1)

Last updated on FEBRUARY 03, 2019

Applies to:

Oracle Receivables - Version 12.0.4 and later
Information in this document applies to any platform.
Executable:RAXTRX - Autoinvoice Import Program

Symptoms

On 12.0.4 in Production:
When running Autoinvoice Import, it is having serious performance problems when calling EBTAX

Log file shows the following for the long execution:

raaebt()+ Current system time is 03-MAR-2009 18:37:17
raaebt()- Current system time is 05-MAR-2009 06:16:00

Tkprof file for just on order shows the folowing as TOP SQLs:

begin arp_etax_autoinv_util . calculate_tax ( :request_id , :phase ,
:num_tax_failures , :return_status:i_return_status ) ; END ;

call    count cpu      elapsed    disk       query      current    rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse   1      0.00     0.00       0          0          0          0
Execute 1      8.28     540.94     74924      129229     445        1
Fetch   0      0.00    0.00       0          0         0         0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total   2      8.28     540.94     74924      129229     445        1

SELECT NVL(ZD.PARTNER_MIGRATED_FLAG, 'N')
FROM
ZX_LINES_DET_FACTORS ZD WHERE ZD.EVENT_CLASS_MAPPING_ID = :B4 AND ZD.TRX_ID =
:B3 AND ZD.TRX_LINE_ID = :B2 AND ZD.TRX_LEVEL_TYPE = :B1 AND EXISTS
(SELECT 'Y' FROM ZX_LINES ZL WHERE ZL.APPLICATION_ID = ZD.APPLICATION_ID
AND ZL.ENTITY_CODE = ZD.ENTITY_CODE AND ZL.EVENT_CLASS_CODE =
ZD.EVENT_CLASS_CODE AND ZD.TRX_ID = :B3 AND ZD.TRX_LINE_ID = :B2 AND
ZD.TRX_LEVEL_TYPE = :B1 AND TAX = 'LOCATION' AND ROWNUM = 1)

call    count cpu      elapsed    disk       query      current   rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse   1      0.00     0.00       0          0         0          0
Execute 1      0.00     0.00       0          0          0         0
Fetch   1      5.48     487.05     70890      70895      0          0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total   3      5.48     487.06     70890      70895      0          0