My Oracle Support Banner

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 later
Information 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


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