Clarity PPM

Expand all | Collapse all

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

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

    Posted 03-17-2016 05:07 AM

    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



  • 2.  Re: How to check the process instance has used which user account for xog from DB side ?

    Posted 03-17-2016 02:51 PM

    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



  • 3.  Re: How to check the process instance has used which user account for xog from DB side ?

    Posted 03-17-2016 02:55 PM

    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



  • 4.  Re: How to check the process instance has used which user account for xog from DB side ?

    Posted 03-17-2016 02:58 PM

    ...you could also search the discussions.