Autoinvoice Import Program Running Over 30+ Hrs (Doc ID 1906579.1)

Last updated on APRIL 17, 2023

Applies to:

Symptoms

On : 12.1.3 version, Transactions Related

Attempting to run the Autoinvoice Import Program and it runs for over 30+ hrs.

The following, from the tkprof, seems to be the most expensive:

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.01 0.00 0 0 0 0
Execute 1 1247.22 1249.26 0 0 2 0
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 2 1247.23 1249.26 0 0 2 0

The 2nd most expensive SQL, after the above, is INSERT INTO RA_INTERFACE_ERRORS

Cause

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