I have created a process that has an action on a step to launch the Synchronize portfolio Investments job. I hardcoded a specific Portfolio in there (BP&IT Portfolio)
Where in the DB is this parameter stored? I tried looking into BPM_DEF_STEP_ACTION_PARAMS table but that doesn't seem to hold the value.
Any help would be appreciated.
Moving this to the PPM community as this was opened up in the APM community.
CMN_SCH_JOB_RUN_PARAMS I think.
(BPM_DEF_STEP_ACTION_PARAMS is to do with the definition of a process rather than the execution of a job)
David: Even if running the job happens from a step action WITHIN a process?
I defined in a process to run a job with a specific parameter. I didn't schedule the job nor ran it.
Because i see that you need a: job_run_id to link CMN_SCH_JOB_RUN_PARAMS, which i don't have since it's defined in a process definition.
Hmmm interesting not what I expected.
But I did a quick test and they seem to be in CMN_ATTRIBUTE_VALUES - you'll have to read back through the IDs to see how that relates to the process.
Sorry for the delayed reply. But yes, you are right. It is stored in CMN_ATTRIBUTE_VALUES. Nice find
But i cannot seem to read back through the ID's to find the process. This is what i found:
1) Going down using the attribute ID
select *from CMN_ATTRIBUTE_VALUES cavjoin cmn_attributes ca on ca.id = cav.attribute_idjoin CMN_BUSINESS_OBJECTS cbo on cbo.id = ca.pk_idjoin CMN_SCH_JOB_DEFINITIONS csjd on csjd.id = cbo.pk_idwhere cav.id = 5179085
>> will lead to the job definition
2) Going down using the Attribute Set ID
select cavs.*from CMN_ATTRIBUTE_VALUES cavjoin CMN_ATTRIBUTE_VALUE_SETS cavs on cavs.id = cav.attribute_set_idwhere cav.id = 5179085
>> will give the job_id
(replace cav.id by the CMN_ATTRIBUTE_VALUES id found) >> so this will lead to the job definition, but not to the process
Do you see anything i can use in there to relay back to the step_action?
Here are the tables you need:BPM_DEF_STEP_ACTIONS contains the job id, the job definition id, and the step id,BPM_DEF_STEPS contains the stage_id
BPM_DEF_STAGES contains the process_version_id
BPM_DEF_PROCESS_VERSIONS contains the process_id
BPM_DEF_PROCESSES contains the process_code.
If you need the actual name of the process, you can map to the name in the CMN_CAPTIONS_NLS.
And you already have a way to get from the job definition id to the parameters.
Hopefully this will give you the information you need.
Please let me know whether or not this resolves your problem.
Thanks Jeanne_Gaskill_CA_Clarity_Support and urmas for the information. But I was not really looking for this particular information, but more on how to go from CMN_ATTRIBUTE_VALUES (where the parameter for running a job in a process is stored) to the Process definition itself.
As you can see above I cannot seem to find the missing "link". Any help would be appreciated.