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
For the processes build something from
,(BPM_RUN_PROCESSES.END_DATE - BPM_RUN_PROCESSES.START_DATE)*3600 RUN_SECS
, (c_users.last_name ||', ' ||c_users.first_name) INITIATOR
, cmn_sec_users C_USERS
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
The jobs that leave an entry can be queried with
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
...you could also search the discussions.