1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Managing Buyers for Oracle Purchasing

Discussion in 'Oracle Financials' started by varuntrehan, Oct 28, 2013.

  1. varuntrehan

    varuntrehan Active Member

    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    55
    Hello,
    I am a new member here and not sure if this is the right place of asking a question or starting a thread.

    I would like to know if anybody is managing buyers in oracle or using a tool/ dashboard report to get a summary of what all users got end dated and had buyer access?
    We use spot fire reports at work and would like to create a solution to efficiently manage oracle buyer database.
    Any suggestions or sample reports/ templates/ query?

    Thank you in Advance.
    -varun
     
  2. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,747
    Likes Received:
    147
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
    Can you please specify what all the fields you want in the query ?
     
  3. varuntrehan

    varuntrehan Active Member

    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    55
    Hi Bharat,

    The fields I would like in the query are:
    "Extract Date (Sys Date), Operating Unit (Business Group), Oracle User Name, Full Name, Location, User Start Date, User End Date, Oracle Responsibilities, Responsibility Start Date, End Date, Buyer Status."

    I have attached 2 screenshots for the report we have to Enable Buyers in oracle. I need similar tool/report to know which buyers to end date based on their Job responsibility end date. Hope this helps.

    Thanks
    Varun
     

    Attached Files: