My Oracle Support Banner

Stage POM--REQEXT_JOB Is Failing With Unable To Get A Stable Set Of Rows Error (Doc ID 2983863.1)

Last updated on OCTOBER 31, 2023

Applies to:

Oracle Retail Merchandising Foundation Cloud Service - Version 23.0 to 23.1 [Release 23.0 to 23.1]
Information in this document applies to any platform.


When attempting to run REQEXT_JOB, the following error occurs.

@0PACKAGE_ERROR@1ORA-30926: unable to get a stable set of rows in the source tab les@2CORESVC_REQ_EXT_SQL.CALC_DIST::MERGE_3

The issue can be reproduced at will with the following steps:
1. Make sure dept_level_transfers = Y in system_options table
2. Ensure the items are from 2 diff departments, ranged to same location - both having different lead times, one 0 other 1, reviewed daily, wh-stocked with automatic ordering
3. Run Replenishment batches.
4. 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

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