Self Service Procurement

Get Involved. Join the Conversation.

Topic

    Madhu Chalamalasetty
    Report on Users who have Delegation Set
    Topic posted October 18, 2019 by Madhu ChalamalasettyGreen Ribbon: 100+ Points, tagged Approvals, Approvals/Notification, Setup 
    27 Views, 1 Comment
    Title:
    Report on Users who have Delegation Set
    Summary:
    Report on Users who have Delegation Set in setting up Vacation Period
    Content:

    We want to run a report to see who all have active "Delegation" or "Re Assign" set in BPM for Vacation Period.  Does Oracle has a delivered report for this or there is a SQL which I can run to get this data?  Also, we want to restrict a user to delegate based on the approval amount.  Eg: If a user had to approve the requisition and the approval dollar amount is greater than 100K, this transaction cannot be delegated and can only be approved by assigned user.  We are trying to create a rule but we could not find a column for Dollar Amount.  Any ideas on how to get this done?

     

    Thanks,

    Madhu.

    Version:
    19C

    Comment

     

    • Ashok

      Madhu

      There is no such canned report that is available out of the box. On the Sql related aspect, I will ask if we have something and revert if I have something to get back with.