Ep load main is failing in Demantra 12.2.6 - ORA-00936: missing expression Error in PROCEDURE line
Hi,
I have one question.
EP load is failing with the failing with below error :
ORA-00936: missing expression Error in PROCEDURE line 1088
dynamic_ddl( 'UPDATE MDP_MATRIX
SET p1 = 0,
p2 = 0,
p3 = 0,
p4 = 0,
p5 = 0,
p6 = 0,
p7 = 0,
p8 = 0,
p9 = 0,
p10 = 0,
p11 = 0,
p12 = 0,
glob_prop = 0,
prediction_status = '99',
level_id = 0,
item_node = ,
loc_node = ,
prop_changes = 0,
new_member = 0
WHERE 1 = 1
AND item_id = 12
AND location_id = 687')
2.
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at "DEMANTRA122.DYN_PROPORT_SALES_1", line 1424
ORA-20002: -936 ORA-00936: missing expression Error in PROCEDURE line 1088
dynamic_ddl( 'UPDATE MDP_MATRIX
SET p1 = 0,
p2 = 0,