SALEPROCESS.KSH batch is failing with an ORA-00054 Error Because SALES_PRCOESS_ID_SEQ Value is Reaching the Maximum Value
(Doc ID 2476222.1)
Last updated on MAY 28, 2021
Applies to:Oracle Retail Merchandising System - Version 16.0.1 and later
Information in this document applies to any platform.
SALEPROCESS.KSH batch is using the same process_id i.e. In the sequence sales_process_id_seq the max value is 999999. Because of this batch is locking the records.
Steps to Recreate:
1. Process RTLOG and execute the ReSA batches till SALEPROCESS.KSH
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