Sccext Batch is Aborting When Executed in Multi Thread Mode
(Doc ID 2196728.1)
Last updated on APRIL 16, 2020
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.
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.
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