Sccext Batch is Aborting When Executed in Multi Thread Mode

(Doc ID 2196728.1)

Last updated on DECEMBER 29, 2017

Applies to:

Oracle Retail Merchandising System - Version 14.1.1 to 14.1.2 [Release 14.1]
Information in this document applies to any platform.

Symptoms

Sccext batch is aborting, when executed in Multithread, with below error:

sccext_7~20160803084737~process~~0~ORA-0000: normal, successful completion~INTERNAL STORED FUNCTION ERROR: function=COST_EXTRACT_SQL.BULK_UPDATE_COSTS, error=@0TABLE_LOCKED@1ITEM_SUPP_COUNTRY_LOC,cost_chg=31483962


Steps To Recreate:

1. Create 1000+ records in COST_SUSP_HEAD with status = 'A' and ACTIVE_DATE  as Sysdate+1.
2. Execute Sccext batch in Multithread .
3. Check that any one thread abort with locking issue.

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