Oracle Database Discussions

Hi

I work on 11.2.0.3 Database. Recently started testing my application with 12 C Database. I have a package which calls dbms_scheduler and creates new jobs for parallel processing. I use sysdate to set the time, so that the job is created and immediately executed. This worked fine in old version. I faced some problem with 12C where the session goes into plsql lock timer wait event. I changed the sysdate to systimestamp and the execution is fine. Can someone help me in finding what can be the problem ?

Here is the code: Changed start_date from sysdate to systimestamp.

      DBMS_SCHEDULER.create_job (

               job_name        => 'JOB_INHOUSE_STR_VAL_'||p_supplier||substr(p_cycle,3)||corept_processes_execution.p_run_number,

               job_type        => 'PLSQL_BLOCK',

               job_action      => v_str,

               start_date      => SYSTIMESTAMP,

               enabled         => TRUE

             );

Thanks

Ram