slow insert into ra_interface_errors during the Autoinvoice Import
sometimes the below insert statement is very slow, overtimes which causes processing error/confusion: currently we have Receivables 11.5.10 (dbase 9) ; also raavdf.lpc version is 115.15.15103.2 from 2005/03/25
INSERT INTO RA_INTERFACE_ERRORS
(INTERFACE_LINE_ID,
MESSAGE_TEXT,
INVALID_VALUE, ORG_ID)
SELECT /*+ cardinality(il 1) */
INTERFACE_LINE_ID,
:b_err_msg6,
'trx_number='||T.TRX_NUMBER||','||'customer_trx_id='||TL.CUSTOMER_TRX_ID,
IL.ORG_ID
FROM RA_INTERFACE_LINES_GT IL, RA_CUSTOMER_TRX_LINES TL, RA_CUSTOMER_TRX T
WHERE IL.REQUEST_ID = :b1
AND IL.INTERFACE_LINE_CONTEXT = 'DNR FINANCIAL GATEWAY'
AND T.CUSTOMER_TRX_ID =TL.CUSTOMER_TRX_ID