Performance Issue Bill Of Material Loop Report GUI (BOMRBOMS)
(Doc ID 2731472.1)
Last updated on NOVEMBER 30, 2020
Applies to:
Oracle Bills of Material - Version 12.2.7 and laterInformation in this document applies to any platform.
Symptoms
On : 12.2.7 version, Bills
Performance Issue Bill of Material Loop Report GUI (BOMRBOMS)
Experiencing a performance issue with the BOM Loop report. Used to finish in under an hour, now takes 8+ hours to finish, sometimes failing with error.
ERROR
-----------------------
BOMPEXPL[exploders] ORA-01555: snapshot too old: rollback segment number
REP-0004: Warning: Unable to open user preference file.
MSG-01000: BOMPEXPL[exploders] ORA-01555: snapshot too old: rollback segment
number w
REP-1825: Before Report trigger returned FALSE.
REP-0069: Internal error
REP-57054: In-process job terminated:Terminated with error:
REP-1825: MSG-01000: BOMPEXPL[exploders] ORA-01555: snapshot too old:
rollback segment number w
REP-1825: Before Report trigger returned FALSE.
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
Run the Performance Issue Bill of Material Loop Report GUI (BOMRBOMS)
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 |