My Oracle Support Banner

SCCEXT Fails with "sccext_1~20210809210039~process~~0~ORA-0000: normal, successful completion~INTERNAL STORED FUNCTION ERROR: function=COST_EXTRACT_SQL.BULK_UPDATE_COSTS, error=@0STKLEDGR_DATE@1CAL_TO_454@2OTB_SQL.ORD_INFO,cost_chg=<COST_CHANGE_VALU1>" (Doc ID 2800200.1)

Last updated on AUGUST 21, 2021

Applies to:

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

Symptoms


The SCCEXT.PC (Supplier Cost Change Extract) pro*C module fails on null Order dates: not before date, not after the date, and Open to Buy (OTB).

Error

"sccext_1~20210809210039~process~~0~ORA-0000: normal, successful completion~INTERNAL STORED FUNCTION ERROR: function=COST_EXTRACT_SQL.BULK_UPDATE_COSTS, error=@0STKLEDGR_DATE@1CAL_TO_454@2OTB_SQL.ORD_INFO,cost_chg=<COST_CHANGE_VALU1>"


Steps to Reproduce

1. Take any Order in worksheet status and remove the 3 dates.
2. Click Save.
3. Click Cancel.
4. Open the Order again and note the Order in worksheet status with the 3 dates missing, allowing the SCCEXT batch to fail when an item receiving a cost change is on this same Order.


Changes

 

Cause

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
Symptoms
Changes
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.