Job is faling with use_current_session => true in 11.2.0.4 (Doc ID 2830512.1)

Last updated on APRIL 17, 2023

Applies to:

Symptoms

Job is faling with use_current_session => true in 11.2.0.4.
Job is successful while using use_current_session => false as below.

BEGIN dbms_scheduler.run_job(job_name => '{job_name}',use_current_session => false); END;

Otherwise it is failing with below error. With true it is failing and also it fails if not using use_current_session parameter

BEGIN dbms_scheduler.run_job(job_name => '{job_name}',use_current_session => true); END;
Error report -
ORA-20003: Refresh type XXX unable to access XXX database. Refresh failed.
ORA-06512: at "XXX.PKG_ENTITLEMENTS_UTL", line 465
ORA-06512: at line 1
ORA-06512: at "SYS.DBMS_ISCHED", line 196
ORA-06512: at "SYS.DBMS_SCHEDULER", line 486
ORA-06512: at line 1

SQL> begin
  dbms_scheduler.run_job(job_name => 'XXX.job_name');
end;
/

begin
*
ERROR at line 1:
ORA-20003: Refresh type XXX unable to access XXX database. Refresh failed.
ORA-06512: at "XXX.job_name", line 465
ORA-06512: at line 1
ORA-06512: at "SYS.DBMS_ISCHED", line 196
ORA-06512: at "SYS.DBMS_SCHEDULER", line 486
ORA-06512: at line 2

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.