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

Last updated on JULY 24, 2017

Applies to:

Oracle Receivables - Version 12.1.3 and later
Information in this document applies to any platform.

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

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