Autoinvoice Import Program Running Over 30+ Hrs
(Doc ID 1906579.1)
Last updated on APRIL 17, 2023
Applies to:
Oracle Receivables - Version 12.1.3 and laterInformation 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
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 |