Error in loading data from Demantra Staging table to Demantra

Hi All ,

We are encountering errors while loading data from Demantra Staging table to Demantra in Ep_load procedure

below are the details of error from db_exception_log table .

error details :

==============

dynamic_mdp_add -24344 ORA-24344: success with compilation error

DYMANIC_DDL -20002 ORA-20002: -24344 ORA-24344: success with compilation error BEGIN mdp_add('MDP_LOAD_ASSIST'); END;

EP_LOAD_MAIN "-20003 ORA-20003: Error in PROCEDURE EP_LOAD_MAIN line 33

   executing ACTIVE_PROC_DYN('mdp_add('MDP_LOAD_ASSIST')')"

=========================================================================

If anyone has encountered similar scenario, Please advise for the action plan to be followed for resolving this issue .