Sccext Batch is Aborting When Executed in Multi Thread Mode
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.
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.
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