Running QP: Maintains Denormalized Data in QP Qualifiers Errors with ORA-01555: Snapshot Too Old

(Doc ID 362249.1)

Last updated on APRIL 10, 2017

Applies to:

Oracle Advanced Pricing - Version 11.5.9 and later
Information in this document applies to any platform.
This problem can occur on any platform.
Concurrent Process "QP:Maintains the denormalized data in QP Modifiers"



Symptoms

After running "QP:Maintains the denormalized data in QP Modifiers", log shows error "ORA-01555: snapshot too old: rollback segment number 5 with name "R04" too small"

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms