Reporting and Analytics for ERP

Get Involved. Join the Conversation.

Topic

    Janusz Jasinski
    Where is WF_ROUTING_RULES located? Vacation Rules table?Answered
    Topic posted November 28, 2018 by Janusz JasinskiBronze Crown: 15,000+ Points, tagged BI Publisher, Fusion Procurement reporting, Fusion Project reporting, Fusion Supply Chain Management reporting, OBI Answers, OBIEE Answers, OTBI, Public Sector, Reports, Sample Reports 
    316 Views, 7 Comments
    Title:
    Where is WF_ROUTING_RULES located? Vacation Rules table?
    Content:

    Hi,

    I'm trying to do reports for vacation rules and I have read I can use WF_ROUTING_RULES but or the life of me I can't find where these reside

    Any clues? Do I even need WF_ROUTING_RULES or is there a new version?

    I'm on the latest version of FUSION

    Thanks,

    JJ

    Best Comment

    Alexey Shtrakhov

    :)))
    What is your e.g. Financials Application version? something like this: Oracle Cloud Application Revision 13.18.05 (11.13.18.05.0)?
    Check if these release documentation is applicable to you: https://cloud.oracle.com/saas/readiness/overview

    Comment

     

    • Alexey Shtrakhov

      Hi,

      If you want to make a report or just get listed your Vacation rules, then this is not possible at the moment. There is following ER open: 23585330 : NEED A REPORT WITH THE LIST OF VACATION RULES DEFINED BY USERS IN THE SYSTEM

      With respect
      Alexey

    • Janusz Jasinski

      Ok thanks - what about all these articles referencing this table, how come they are able to report against it?

      https://www.oracle.com/webfolder/community/oracle_e-business_suite/3949142.html and http://oracleappstechguide.blogspot.com/ for example

    • Alexey Shtrakhov

      these documents reference EBS...

      I think vacation rules resides actually in some xml files and it is impossible at the moment to get access to those in the cloud.
      We have done this in onPrem Fusion solution. We have created a package for this to retrieve the rules from those underlying objects. But here we have to wait for this ER.
      It is quite hotly desired feature :) and you can add some pressure on it if you create an SR and add yourself (your client) to that ER.

      Alexey

    • Janusz Jasinski

      We have EBS - specifically the HCM, Financials, Precourement etc products

      • Alexey Shtrakhov

        oh... then I step out from this discussion...
        but I think here should be only Fusion related topics, so I suspect that this is the wrong forum to discuss this...

        Alexey

    • Janusz Jasinski

      This is where it gets embarrassing for me - what is the difference between EBS and FUSION


      We are on FUSION but it looks to be the same as EBS

    • Alexey Shtrakhov

      :)))
      What is your e.g. Financials Application version? something like this: Oracle Cloud Application Revision 13.18.05 (11.13.18.05.0)?
      Check if these release documentation is applicable to you: https://cloud.oracle.com/saas/readiness/overview