Rplext.ksh Aborts With ORA-30926
(Doc ID 2813069.1)
Last updated on OCTOBER 11, 2021
Applies to:Oracle Retail Merchandising System - Version 19.0 and later
Information in this document applies to any platform.
When attempting to run rplext.ksh the following error occurs.
rplext~20210803171718~EXEC_SQL_T~@0PACKAGE_ERROR@1ORA-30926: unable to get a stable set of rows in the source tables@2CORESVC_REPL_EXT_SQL.PACK_ROUNDING
rplext~20210803171721~PROCESS_ROQ~CORESVC_REPL_EXT_SQL.CONSUME Thread: 1 Failed.
Steps To Recreate:
1) Setup same item for 2 different stores at replenishment attributes screen with the follow main contents:
a. Stock category = L (WH-Cross link)
b. Order Control = Automatic
c. Method = C (Constant)
d. Max stock > 0
e. Increment = 100%
f. Scaling Exempt = Yes
g. Source WH = any WH valid
h. Review cycle = every day
Note: All stock buckets for these items/locations must be Zero, including in Source WH stock.
2) Execute replenishment batches.
3) Note the above error.
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