How to check the process instance has used which user account for xog from DB side ?

[Anon Anon]

Hi All,

 

In the project team tab their are certain resources on which allocations has been changed on particular date, we checked for created data and created by.

It has been done by some process, now we checked the job logs and process instance for that date in which this change happened, we were not able to find anything related to this  change, the process or jobs instance which ran that day day were using some different generic account and not the same which has done the change in team tab.

 

My query is can we check from the DB level that the account using which changes has been done, is associated to which process instance or job instance ?

 

Thanks & Regards

Anant

[Deactivated User]

For the processes build something from

 

SELECT

       BPM_RUN_PROCESSES.START_DATE

      ,BPM_RUN_PROCESSES.END_DATE

       , CMN_CAPTIONS_NLS.NAME

       ,CMN_CAPTIONS_NLS.DESCRIPTION

       ,BPM_DEF_PROCESSES.PROCESS_CODE

 

,(BPM_RUN_PROCESSES.END_DATE - BPM_RUN_PROCESSES.START_DATE)*3600 RUN_SECS

       , (c_users.last_name ||', ' ||c_users.first_name) INITIATOR

       ,BPM_RUN_PROCESSES.INITIATED_TYPE_CODE

       ,BPM_DEF_PROCESSES.SOURCE

       ,BPM_RUN_PROCESSES.USER_ACTION

 

   FROM BPM_DEF_PROCESSES

 

,BPM_DEF_PROCESS_VERSIONS

   ,BPM_RUN_PROCESSES

   ,CMN_CAPTIONS_NLS

   , cmn_sec_users C_USERS

Where

BPM_DEF_PROCESS_VERSIONS.ID = BPM_RUN_PROCESSES.PROCESS_VERSION_ID

AND BPM_DEF_PROCESS_VERSIONS.PROCESS_ID = BPM_DEF_PROCESSES.ID AND CMN_CAPTIONS_NLS.LANGUAGE_CODE = 'en'

and CMN_CAPTIONS_NLS.TABLE_NAME = 'BPM_DEF_PROCESSES'

AND BPM_DEF_PROCESSES.ID = CMN_CAPTIONS_NLS.PK_ID and BPM_RUN_PROCESSES.INITIATED_BY  = c_users.id

= c_users.id

[Deactivated User]

The jobs that leave an entry can be queried with

 

select 

cmn_sch_jobs.name,

cmn_sch_job_runs.start_date,

cmn_sch_job_runs.percent_complete pcnt_compl,

cmn_sch_job_runs.Status_code

,cmn_sec_users.last_name

,cmn_sec_users.first_name

from cmn_sch_job_runs, cmn_sch_jobs, cmn_sec_users, CMN_SCH_JOB_DEFINITIONS

Where cmn_sch_jobs.id = cmn_sch_job_runs.job_id

and cmn_sch_job_runs.user_id = cmn_sec_users.id

AND CMN_SCH_JOB_DEFINITIONS.ID = cmn_sch_jobs.JOB_DEFINITION_ID

 

until the job logs are cleaned

[Deactivated User]

...you could also search the discussions.