EAP: Resumed Matching Process Ends With the Following Error, SQL error Stmt #: 1851 Error Position: 12 Return: 1555 - ORA-01555: snapshot too old: rollback segment number 2 (Doc ID 3001730.1)

Last updated on FEBRUARY 01, 2024

Applies to:

Symptoms

Matching process failed after process is resumed after Step AP_MATCH.ClearRec.Step02


ERROR
-----------------------
SQL error. Stmt #: 1851 Error Position: 12 Return: 1555 - ORA-01555: snapshot too old: rollback segment number 2 with name "_SYSxxxx_1111111111$" too small
Failed SQL stmt: INSERT INTO PS_VCHR_RECV_TAO7 (PROCESS_INSTANCE, BUSINESS_UNIT, VOUCHER_ID, VOUCHER_LINE_NUM, BUSINESS_UNIT_RECV, RECEIVER_ID, RECV_LN_NBR, RECV_SHIP_SEQ_NBR, BUSINESS_UNIT_PO, PO_ID, LINE_NBR, SCHED_NBR, QTY_SH_ACCPT_VUOM, MERCHANDISE_AMT) SELECT 4104057, F.BUSINESS_UNIT, F.VOUCHER_ID, F.VOUCHER_LINE_NUM, G.BUSINESS_UNIT, G.RECEIVER_ID, G.RECV_LN_NBR, G.RECV_SHIP_SEQ_NBR, G.BUSINESS_UNIT_PO, G.PO_ID, G.LINE_NBR, G.SCHED_NBR, G.QTY_SH_ACCPT_VUOM, G.MERCHANDISE_AMT FROM PS_VOUCHER E, PS_VOUCHER_LINE F, PS_RECV_LN_SHIP G, PS_VCHR_RECV_MTCH V WHERE E.PROCESS_INSTANCE = 4104057 AND E.IN_PROCESS_FLG = 'Y' AND E.BUSINESS_UNIT = F.BUSINESS_UNIT AND E.VOUCHER_ID = F.VOUCHER_ID AND F.BUSINESS_UNIT_RECV = G.BUSINESS_UNIT AND F.RECEIVER_ID = G.RECEIVER_ID AND F.RECV_LN_NBR = G.RECV_LN_NBR AND F.RECV_SHIP_SEQ_NBR = G.RECV_SHIP_SEQ_NBR AND F.BUSINESS_UNIT_PO = G.BUSINESS_UNIT_PO AND F.PO_ID = G.PO_ID AND F.LINE_NBR = G.LINE_NBR AND F.SCHED_NBR = G.SCHED_NBR AND F.BUSINESS_UNIT = V.BUSINESS_UNIT AND F.VOUCHER_ID = V.VOUCHER_ID AND F.VOUCHER_LINE_NUM = V.VOUCHER_LINE_NUM AND F.BUSINESS_UNIT_RECV = V.BUSINESS_UNIT_RECV AND F.RECEIVER_ID = V.RECEIVER_ID AND F.RECV_LN_NBR = V.RECV_LN_NBR AND F.RECV_SHIP_SEQ_NBR = V.RECV_SHIP_SEQ_NBR AND F.BUSINESS_UNIT_PO = V.BUSINESS_UNIT_PO AND F.PO_ID = V.PO_ID AND F.LINE_NBR = V.LINE_NBR AND F.SCHED_NBR = V.SCHED_NBR AND (G.MERCHANDISE_AMT <> V.MERCH_AMT_RECV OR G.QTY_SH_ACCPT_VUOM <> V.QTY_SH_ACCPT_VUOM)


STEPS
-----------------------
1. Matching is running for All Business Units

2. There are a total of 8 BU's

3. Process was resumed after  Step AP_MATCH.ClearRec.Step02

4. Matching process failed

Changes

Matching process was resumed after Step AP_MATCH.ClearRec.Step02.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.