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'
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.
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:
- 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.
- Execute extraction of cost change by executing the batch process “sccext.pc”.
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