AutoInvoice Performance Issue: Inserting Into RA_INTERFACE_ERRORS (Doc ID 1333438.1)

Last updated on AUGUST 03, 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

Find that autoinvoice is running long.

See the following as the long running statement:

insert into RA_INTERFACE_ERRORS (INTERFACE_LINE_ID,MESSAGE_TEXT,INVALID_VALUE)
select L.INTERFACE_LINE_ID ,:b0 ,L.MANDATE_LAST_TRX_FLAG from
RA_INTERFACE_LINES_GT L where (((L.REQUEST_ID=:b1 and L.CUSTOMER_TRX_ID is
not null ) and NVL(L.INTERFACE_STATUS,'~')<>'P') and L.CUSTOMER_TRX_ID in
(select L.CUSTOMER_TRX_ID from RA_INTERFACE_LINES_GT L ,RA_CUST_TRX_TYPES
TT where ((((L.REQUEST_ID=:b1 and NVL(L.INTERFACE_STATUS,'~')<>'P') and
L.CUST_TRX_TYPE_ID=TT.CUST_TRX_TYPE_ID) and TT.TYPE in ('INV','DM')) and
L.LINE_TYPE in ('LINE','CHARGES')) group by L.CUSTOMER_TRX_ID having
count(distinct nvl(UPPER(L.MANDATE_LAST_TRX_FLAG),'N'))>1))



call    count  cpu      elapsed    disk       query      current    rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse   1      0.00     0.00       0          0          0          0
Execute 1      4474.58  4475.06    0          1936351861 0          0
Fetch   0      0.00     0.00       0          0          0          0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total   2      4474.58  4475.06    0          1936351861 0          0

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