My Oracle Support Banner

Is it Possible to Increase RPM_FUTURE_RETAIL_SEQ Value? (Doc ID 2721401.1)

Last updated on OCTOBER 28, 2022

Applies to:

Oracle Retail Price Management - Version 16.0.1 and later
Information in this document applies to any platform.


Is it possible to increase  RPM_FUTURE_RETAIL_SEQ Value to Avoid ORA-00001 on RPM_FUTURE_RETAIL_SQL.PUSH_BACK?

All Price Events are failing with error below:-

The Sequence on RPM_FUTURE_RETAIL has been cycled. All types of price events (price changes, clearances, and promos) all of them are not going through. The max sequence value is 9999999999(10) can it be increased to a higher size.


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

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