My Oracle Support Banner

RLM Inbound Transactions (830, 862, 866) Jobs Are Failing Due To Sequence. (Doc ID 2701343.1)

Last updated on AUGUST 09, 2021

Applies to:

Oracle Release Management - Version 12.2.4 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.4 version, Demand Processor Related Issue


RLM Inbound Transactions (830, 862, 866) finishes with warning

ERROR
-----------------------
  Program level EC_INBOUND_STAGE.LOAD_DATA: Please check the log file, correct the problem, and try again.
  SQL error message ORA-08004: sequence ECE_STAGE_ID_S.NEXTVAL exceeds MAXVALUE and cannot be instantiated.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Submit the Concurrent program 'RLM Inbound Transactions (830, 862, 866)'
2. View results

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, Plants are not able to process even a single demand for customers and it has major impact on supply chain

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


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