My Oracle Support Banner

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

Last updated on AUGUST 10, 2020

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



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
 1. Bug Summary
 2. Fixed Files
 3. Recommended Patches
 4. Solution Steps
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.