Om_job_pkg.resubmit_jobs Doesn't Work When It Is Run With SYS User (Doc ID 1991165.1)

Last updated on APRIL 05, 2015

Applies to:

Oracle Communications Order and Service Management - Version 7.2.2 and later
Information in this document applies to any platform.

Symptoms

 1. Login to OSM DB as SYS user

Test1:
--------

2. alter SESSION SET CURRENT_SCHEMA = OSM_PRIMARY_SCHEMA_NAME
3. select user from dual;
--> OUTPUT: SYS
4. select sys_context( 'userenv', 'current_schema' ) from dual;
--> OUTPUT: OSM_PRIMARY_SCHEMA_NAME
5. Run the below command -

BEGIN
om_job_pkg.resubmit_jobs(om_const_pkg.v_notification_type_poll,1);
END;

6. Login to DB as OSM_SCHEMA_NAME
7. select * from user_jobs;

10971019 SYS ORDERMGMT_COM ORDERMGMT_COM 28-JAN-15 18:32:11 0 N null 5 SYS.om_job_pkg.invoke_notif_engine; NLS_LANGUAGE='AMERICAN' NLS_TERRITORY='AMERICA' NLS_CURRENCY='$' NLS_ISO_CURRENCY='AMERICA' NLS_NUMERIC_CHARACTERS='.,' NLS_DATE_FORMAT='DD-MON-RR' NLS_DATE_LANGUAGE='AMERICAN' NLS_SORT='BINARY' 010200000A000000 0

8. select what from user_jobs
--> SYS.om_job_pkg.invoke_notif_engine;

Test2:
--------
2. Run the below command -

BEGIN
OSM_PRIMARY_SCHEMA_NAME.om_job_pkg.resubmit_jobs(OSM_PRIMARY_SCHEMA_NAME.om_const_pkg.v_notification_type_poll,1);
END;

3. select what from user_jobs
--> SYS.om_job_pkg.invoke_notif_engine;

Conclusion: DBA - using the OS authentication to login to the DB - is unable to perform the resubmit_jobs operation.
 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms