Materialized View Job SCHEDULER

During cutover activity there should not be any Materialized View Job in running state to avoid the delay. Below are the scripts to check the running MV’s and to stop the Jobs. Please note Materialized View Job name will start with MV. 1. SELECT * FROM DBA_SCHEDULER_RUNNING_JOBS; 2. BEGIN DBMS_SCHEDULER.STOP_JOB(job_name => 'MV_RF$J_0_S_116418', force => true); END; /

DB trigger Submit request mandatory initialization set_mode

retval boolean; req_id number begin retval := fnd_request.set_mode(db_trigger=>TRUE); --then call below req_id:=fnd_request.submit_request(....); end; --It can be use as without pragma autonomous and without commit

PLSQL debug seeded global variables for PLSQL unit and PLSQL Line Number

$$plsql_unit --package_name $$plsql_line