RAXTRX - Ebtax Code Takes 38 Hours To Process 400 Rows In Autoinvoice
Last updated on DECEMBER 14, 2017
Applies to:
Oracle Receivables - Version 12.0.4 and laterInformation 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 05-MAR-2009 06:16:00
Tkprof file for just on order shows the folowing as TOP SQLs:
: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
Changes
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