Demantra Solutions - EBS (MOSC)

MOSC Banner

Chaining failed with error -ORA-00984: column not allowed here Error in PROCEDURE line 464

edited Jul 13, 2015 7:36AM in Demantra Solutions - EBS (MOSC) Question

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; ')".

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

EBS Demantra Tags

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center