Process SCCEXT Fails with Message ORA-30926: 'unable to get a stable set of rows in the source tables@2ITEM_LOC_SQL.INSERT_ITEM_COST_LO' (Doc ID 2077695.1)

Last updated on APRIL 03, 2017

Applies to:

Oracle Retail Merchandising System - Version 14.0 and later
Information in this document applies to any platform.

Symptoms

 

When running the SCCEXT batch for a cost change related to an item/origin country id/supplier combination linked to multiple delivery country IDs in the ITEM_COST_DETAIL table, the following error occurs:

 

Steps to Reproduce:

  1. Create a cost change at supplier level for an item/supplier/origin country with more than one record in table ITEM_COST_DETAIL for different delivery countries.
  2. Execute extraction of cost change by executing the batch process “sccext.pc”.

Changes

 

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms