My Oracle Support Banner

Stkschedxpld Batch Aborts With Unique Constraint Error "ORA-00001: unique constraint (PK_STAKE_SKU_LOC)" (Doc ID 2556599.1)

Last updated on SEPTEMBER 17, 2019

Applies to:

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


Stkschedxpld batch aborts with following error:

Steps to Recreate:

1. RESTART_CONTROL.COMMIT_MAX_CTR set to 1000 for batch stkschedxpld.
2. Create an item list. The item list should contains a pack item and components of that pack.
3. Run the stkschedxpld batch to create entries in STAKE_HEAD, STAKE_SKU_LOC and other tables.
4. The batch aborts with the below mentioned error in the ADD_TO_SSL_STUCT_FUNCTION() while inserting into STAKE_SKU_LOC table.
'post_ssl_struct~stake_sku_loc~-1~ORA-00001: unique constraint (XXX.PK_STAKE_SKU_LOC) violated~insert for count_id failed'




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.