OPM Accounting Pre-processor - Error ORA-01555: snapshot too old for Order Management Transaction Source
(Doc ID 2902748.1)
Last updated on JANUARY 26, 2023
Applies to:
Oracle Process Manufacturing Financials - Version 12.2.8 and laterInformation in this document applies to any platform.
Symptoms
On : 12.2.8 version, Subledger Accounting Preprocessor
OPM Pre-Processor is completing with the following error when running for Source: OM transactions.
This occurred on GMFXLAPB.pls version 120.48.12020000.18 when the profile GMF_LC_IV_TRANSFER is set to 0.
ERROR
-----------------------
OTHERS EXCEPTION IN Insert_RmaReceipts:ORA-01555: snapshot too old: rollback segment number 351 with name "_SYSSMU351_992663013$" too small
PROGRAM_EXCEPTION IN Match_RevenueCOGS at (20):
Unexpected error in CST_RevenueCogsMatch_PVT . Insert_RmaReceipts ( 10 )
Error in CST_RevenueCogsMatch_PVT . Match_RevenueCOGS ( 20 )
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. OPM Financials > Run OPM Pre-Processor
2. Review OPM Pre-Processor Debug Log
Changes
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 |
| References |