Receivables - EBS (MOSC)

MOSC Banner

slow insert into ra_interface_errors during the Autoinvoice Import

edited May 12, 2016 5:03AM in Receivables - EBS (MOSC) 2 commentsAnswered

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center