Retail Merchandising System (MOSC)

MOSC Banner

Batch SCCEXT aborted when trying to process cost change

edited Jan 25, 2016 6:18PM in Retail Merchandising System (MOSC) Question

Hi all,

we receive an error like the following:

"INTERNAL STORED FUNCTION ERROR: function=COST_EXTRACT_SQL.UPDATE_COSTS, error=Mandatory input parameter IO_comp_item_cost_tbl program ITEM_COST_SQL.COMPUTE_ITEM_COST_BULK value is null., cost_chg=XXXXX"

This happens on 2 items. Item definitions are ok (standard_UOM, item_status, retail price, etc.), avg_cost and unit_cost is defined in all needed tables (item_supp_country, item_loc_soh, item_loc, etc.).

It happens that the CC shows up in COST_EVENT_SUPP_COUNTRY table and in COST_EVENT_PROCESS_ID, but it is in status 'N'. Also, it's visible in COST_SUSP_SUP_HEAD and COST_SUSP_SUP_DETAIL tables. There is data also in ITEM_COST_HEAD and ITEM_COST_DETAIL tables. Nothing is processed to FUTURE_COST (because COST_EVENTS didn't processed).

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center