Help required - EP_LOAD_MAIN error
Hi everyone
I hope you can help me, I am on customer site and I am trying to load my own data using SQL scripts onto Demantra via EP_LOAD_MAIN however I encountered the below problem when executing the procedure (KIT is my schema name):
Connecting to the database orcl.
ORA-20002: -20003 ORA-20003: Error in PROCEDURE EP_LOAD_MAIN line 23
executing ACTIVE_PROC_DYN('ep_load_items')
ORA-06512: at "KIT.SEND_ERR_MESSAGE", line 21
ORA-06512: at "KIT.ACTIVE_PROC_DYN", line 13
ORA-06512: at "KIT.EP_LOAD_MAIN", line 23
ORA-06512: at line 2
Process exited.
Disconnecting from the database orcl.
I have populated the staging tables t_src_loc_tmpl, t_src_item_tmpl and t_src_sales_tmpl using insert scripts however when I executed EP_LOAD_MAIN I get the above error message and the staging tables remain populated. I have loaded some data before successfully using the same method so it was a surprise to get this error.