Chaining failed with error -ORA-00984: column not allowed here Error in PROCEDURE line 464
Hi Team,
I am trying to copy the value of Adjusted Baseline Fcst series from existing combination to new combination using CHAINING Management. When i perform chaining i am getting the status as failed.In chains_queue table the error message is as follows """-20003 ORA-20003: No combinations for target Error in PROCEDURE line 76
dynamic_ddl( 'BEGIN chaining_generation('810'); END;')"
" and in DB_EXCEPTION_LOG table Error message is
"
"-20002 ORA-20002: -984 ORA-00984: column not allowed here Error in PROCEDURE line 464 dynamic_ddl( 'INSERT INTO SALES_DATA ( item_id, location_id, sales_date , syncro_sig ,manual_stat) VALUES (9,714,'11-13-2015 00:00:00', -1 ,vs_1)') Error in PROCEDURE line 2862 dynamic_ddl( ' BEGIN dyn_chain_8E8953209F77B98; END; ')".