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:
PeopleSoft Enterprise FIN Payables - Version 9.2 to 9.2 [Release 9]Information in this document applies to any platform.
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
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 |
Changes |
Cause |
Solution |