Thank you Thomas for your response. Those links are really helpful.

Thanks ORA-01033/John Keymer for the information. Could you please share the app to raghu.nagadasari@gmail.com so that we can try to implement this. Thanks again.

Thanks Charles M for you prompt response. We got below query from my friend. Execute the below Query in the ODIREPO Schema of the respective instance: SELECT --SSF.SCEN_FOLDER_NAME, SLP.I_LOAD_PLAN, SLP.LOAD_PLAN_NAME, RT.I_LP_INST, RT.NO_OF_RUNS, RT.START_TIME, RT.END_TIME, RT.total_duration FROM SNP_LOAD_PLAN SLP,…