Automic Workload Automation

  • Private Community

  • 1.  Can we get the SQL query with which we can fetch the Workflow names ?

    Posted Dec 06, 2016 05:28 AM
    Can we get the SQL query with which we can fetch the Workflow names by providing the request ids of the Oracle apps concurrent  programs  which has been triggered in oracle apps in remote side agent.


  • 2.  Can we get the SQL query with which we can fetch the Workflow names ?

    Posted Dec 07, 2016 09:18 AM
    Hi Deepak,

    Can you clarify your question please. You're looking for a SQL query that will return the workflow name by.. Oracle concurrent program request ID ? 
    How does your process work?
    Is the workflow triggered somewhere, by something? If so, what?

    Below is another discussion that retrieves workflows and dependencies:
    https://community.automic.com/discussion/8061/sql-to-extract-processflow-dependancies-from-automation-engine-database


  • 3.  Can we get the SQL query with which we can fetch the Workflow names ?

    Posted Dec 08, 2016 11:47 AM
    Hi Deepak,

    Good day!

    You opened an incident for the same request. Did the link provided by Christine_Chavez_6412 help ?


    Thanks
    Bob


  • 4.  Can we get the SQL query with which we can fetch the Workflow names ?

    Posted Dec 19, 2016 12:25 PM
    hi Christine,
    Below are my answers for your questions -
    Can you clarify your question please. You're looking for a SQL query that will return the workflow name by.. Oracle concurrent program request ID ? 
    Yes, the oracle concurrent programs that submits their request id at oracle side and from that request id i want to know that the particular program which gets submitted belongs to which workflow.

    How does your process work? 
    We have oracle processes in the  UC4 workflows that gets submitetd to remote OAE Agent.
    Is the workflow triggered somewhere, by something? If so, what?
    Above comment i think answers your question. 


  • 5.  Can we get the SQL query with which we can fetch the Workflow names ?

    Posted Dec 20, 2016 09:55 AM
    Yes, the oracle concurrent programs that submits their request id at oracle side and from that request id i want to know that the particular program which gets submitted belongs to which workflow.
    We have oracle processes in the  UC4 workflows that gets submitted to remote OAE Agent.

    Unless the request ID is hard-coded in the Automation OEBS job (if it is then it is stored in the AE database), your SQL request is not possible.

    The request ID, I think, can be found in the activation/job report (can you verify).

    It would be best if you can provide screen shot of the OEBS job (and details, not just an overview) of how your process works (what is in the Process tab, what is the activation/job report, etc). Either a screen shot or XML export. That way other community users can easily provide their input.


    Regards,

    Christine



  • 6.  Can we get the SQL query with which we can fetch the Workflow names ?

    Posted Dec 29, 2016 04:23 PM
    Hi DeepakChatrath604743

    Good day!

    Sorry for the long delay.

    Could you please check if the following query works for you? Basically, the sql script takes the requestID generated by the Oracle job. You can replace requestID by the actual request id generated by the Oracle job as well the Client. This was tested on MSSQL but the idea is the same if you want to rewrite it  in Oracle.

    select  OH_Name as WorkFlow from OH wrkflw where OH_Otype = 'JOBP' and OH_DeleteFlag=0 and Oh_Client=1 and wrkflw.OH_Idnr in ( select jobp.JPP_OH_Idnr from AH               INNER JOIN OH jobs on AH_OH_Idnr = jobs.OH_Idnr            INNER JOIN JPP jobp on  jobp.JPP_Object=jobs.OH_Name               where AH_Idnr = (                                select RT_AH_Idnr from RT                       where RT_Content LIKE '%requestID%' and RT_Type='REP'                      )               and AH_DeleteFlag=0 and AH_SType='JOBP'               );


    Thanks Bob