Blog dedicated to Oracle Applications (E-Business Suite) Technology; covers Apps Architecture, Administration and third party bolt-ons to Apps

Thursday, July 19, 2007

PARGDR PRC: Generate Draft Revenue for a Range of Projects Errors With Ora-1555

We faced this error during go-live. The concurrent request was erroring out with snapshot too old error after running for 1 hour and 30 minutes. We checked the undo_retention parameter and found that it was set to 1 hour (undo_retention=3600). We increased this to 10 hours (undo_retention=36000). Metalink Note 309690.1 describes this problem and offers this solution:


Increase the undo_retention parameter. The proper setting for this parameter can be determined by querying V$UNDOSTAT view once the database has been running for a while. Change the
UNDO_RETENTION parameter to at least equal the following query:

SQL> select max(maxquerylen) from v$undostat;

In our instance the value returned by above query was 14854.

undo_retention was correctly set as 36000 which is much above the 14854 requirement. The request completed successfully in 4 hours 15 minutes.

No comments: