Performance - EBS (MOSC)

MOSC Banner

Long running request getting ORA-1555:snapshot too old error

edited Dec 24, 2013 4:03AM in Performance - EBS (MOSC) 3 commentsAnswered
Hi All,

From the past few months we are getting the error for long running request like the below...

+---------------------------------------------------------------------------+
Inventory: Version : 11.5.0

Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.

EMRIGRN module: EMRI Goods Receipt Note
+---------------------------------------------------------------------------+

Current system time is 04-JAN-2012 13:07:51

+---------------------------------------------------------------------------+


+-----------------------------
| Starting concurrent program execution...
+-----------------------------

Arguments
------------
p_organization='203'
P_REPORT='Y'
------------

 Current NLS_LANG and NLS_NUMERIC_CHARACTERS Environment Variables are :
American_America.US7ASCII

'.,'

ORA-01555: snapshot too old: rollback segment number 1 with name "_SYSSMU1$" too small
     from  ==> rcv_shipment_headers a, rcv_shipment_lines b,RCV_TRANSACTIONS C,po_line_locations_all d

Report Builder: Release 6.0.8.25.0 - Production on Wed Jan 4 13:07:53 2012

(c) Copyright 1999 Oracle Corporation.  All rights reserved.

Enter Username: 
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
+---------------------------------------------------------------------------+
End of log messages from FND_FILE
+---------------------------------------------------------------------------+
Program exited with status 1
Concurrent Manager encountered an error while running

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

EBS Performance Tags

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center