This discussion is archived
3 Replies Latest reply: Aug 20, 2012 12:06 PM by Hussein Sawwan-Oracle RSS

How to get profile values

Hawkeye 11 Newbie
Currently Being Moderated
How can I get the profile option values if I have all the details about minisite,sections,products -R12
Anybody suggests some queries?
  • 1. Re: How to get profile values
    Sanjay Desai Journeyer
    Currently Being Moderated
    pl.visiit following link.

    http://www.shareoracleapps.com/2011/05/profile-options-in-oracle-apps-r12.html

    HTH
    sanjay
  • 2. Re: How to get profile values
    Srini Chavali-Oracle Oracle ACE Director
    Currently Being Moderated
    Pl also see if these MOS Docs can help

    How To Check If a Profile Option Is Set In Oracle Applications? [ID 470102.1]
    How to Search all of the Profile Options for a Specific Value [ID 282382.1]
    How To List E-Business Suite Profile Option Values For All Levels Using SQLPlus [ID 201945.1]

    HTH
    Srini
  • 3. Re: How to get profile values
    Hussein Sawwan-Oracle Employee ACE
    Currently Being Moderated
    Please see these docs.

    Script To List The Values Of A Profile Option At All Levels [ID 803587.1]
    How to Search all of the Profile Options for a Specific Value [ID 282382.1]
    How To Find All Users With A Particular Profile Option Set? [ID 367926.1]
    How to Change Profile Option Value Without Forms? [ID 943710.1]

    Also, please see old threads since this topic was discussed many times in the forum before -- https://forums.oracle.com/forums/search.jspa?threadID=&q=Profile+AND+Option+AND+List+AND+Query&objID=c3&dateRange=all&userID=&numResults=15&rankBy=10001

    Thanks,
    Hussein

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points