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

Last updated on JUNE 06, 2024

Applies to:

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

Goal

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.

Solution

	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

Goal

Solution

References

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

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

Applies to:

Goal

Solution

To view full details, sign in with your My Oracle Support account.

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