Oracle Cloud Infrastructure
Coming soon ...
Apps R12.2
  • R12.2 Architecture
  • Cloning Error (RC-50208)
  • Apps R12.1
  • Major changes from 11i
  • R12:HTTP Debug Logging
  • Compile Apps Schema invalid objects in R12
  • Apps 11i
  • Apps Components and Architecture
  • Concurrent managers
  • Patching
  • Using AD Patch
  • Using AD Control
  • FNDCPASS utility
  • Single-node Installation
  • Multi-node Installation
  • Find Apps Version
  • Cloning
  • Upgrade 11.5.9 to 11.5.10.2
  • Upgrade from 11.5.10.2 to R12
  • Upgrading 9i to 10g with 11i
  • 11i/R12 General Topics
  • AppsDBA System Management Utilities Guide
  • Identifying Long Idle Sessions
  • Identifying High Active Sessions
  • Change hostname for EBS
  • Oracle 12c Database
  • Oracle12c PSU Apply
  • Oracle12c Datafile moved Online
  • Oracle 11g Database
  • Upgrade 10g to 11g R1
  • Upgrade 11.2.0.2 to 11.2.0.3
  • Database 9i-10g
  • Top 99 Responsibilities of a DBA
  • General Info
  • Database Patching
  • 10g:ASM
  • 10g:Data Pump
  • 10g:Data Guard Installing
  • 10g:Rollback Monitoring
  • 10g:Flashback Table
  • Tablespace Management
  • Materialized Views
  • 10g:Enterprise Manager
  • 10g:Upgrade
  • Error:Ora-01631
  • DBA Scripts
  • Disk I/O,Events,Waits
  • Tablespace Information
  • Session Statistics
  • Hit/Miss Ratios
  • User Information
  • Rollback Segments
  • Full Table Scans
  • Contention/Locking
  • Redo Log Buffer
  • Data Dictionary Info
  • Oracle10g Application Server
  • Oracle10g Application Installation
  • (Re)Securing OAS Control
  • Oracle AS10g null protocol issue
  • Oracle Backup & Recovery
  • RMAN
  • RMAN Setup
  • Backup Recovery
  • Flash Recovery Area
  • Oracle10g Discoverer with Apps
    Coming soon ..............
    Troubleshooting
  • Discoverer Troubleshooting
  • Access EBS in mozile
  • Linux and Unix Platforms
  • How To configure NFS
  • Unix/Linux Command
  • Change hostname in Linux
  • SENDMAIL configuration
  • This Oracle Application DBA Portal is the biggest knowledge gateway for the people in the world of Oracle...
    Wednesday, October 16, 2019
    Oracle E-Busines Suite R12 : Find all the profile options recently changed

    Oracle E-Business Suite R12 :  Find all the profile options recently changed


    For Oracle E-Business Suite R12 execute the following sql to get all the profile options recently changed.
    select p.profile_option_name SHORT_NAME, n.user_profile_option_name "PROFILE NAME",
    decode(v.level_id, 10001, 'Site', 10002, 'Application',
    10003, 'Responsibility', 10004, 'User', 10005, 'Server',
    10007, 'SERVRESP', 'UnDef') LEVEL_SET,
    decode(to_char(v.level_id), '10001', '',
    '10002', app.application_short_name, '10003', rsp.responsibility_key,
    '10005', svr.node_name, '10006', org.name, '10004', usr.user_name,
    '10007', 'Serv/resp', 'UnDef') "CONTEXT", v.profile_option_value VALUE, v.LAST_UPDATE_DATE  
    from fnd_profile_options p,
    fnd_profile_option_values v,
    fnd_profile_options_tl n,
    fnd_user usr,
    fnd_application app,
    fnd_responsibility rsp,
    fnd_nodes svr,
    hr_operating_units org
    where p.profile_option_id = v.profile_option_id (+)
    and p.profile_option_name = n.profile_option_name
    --and upper(n.user_profile_option_name) like upper('BNE%')
    --and trunc(v.LAST_UPDATE_DATE) > trunc(sysdate-170)
    and usr.user_id (+) = v.level_value
    and rsp.application_id (+) = v.level_value_application_id
    and rsp.responsibility_id (+) = v.level_value
    and app.application_id (+) = v.level_value
    and svr.node_id (+) = v.level_value
    and org.organization_id (+) = v.level_value
    and v.LAST_UPDATE_DATE is not null 
    order by last_update_date desc, short_name, level_set;


    For Oracle E-Busines Suite 11i execute the following sql to get all the profile options recently changed.
    SELECT pot.user_profile_option_name "Profile"
     , DECODE( a.profile_option_value
              , '1', '1 (may be "Yes")'
              , '2', '2 (may be "No")'
              , a.profile_option_value) "Value"
     , DECODE( a.level_id
              , 10001, 'Site'
              , 10002, 'Appl'
              , 10003, 'Resp'
              , 10004, 'User'
              , '????') "Level"
     , DECODE( a.level_id
              , 10002, e.application_name
              , 10003, c.responsibility_name
              , 10004, d.user_name
              , '-') "Location", a.LAST_UPDATE_DATE  
    FROM applsys.fnd_application_tl e
     , applsys.fnd_user d   , applsys.fnd_responsibility_tl c
     , applsys.fnd_profile_option_values a   , applsys.fnd_profile_options b
     , applsys.fnd_profile_options_tl pot
    WHERE pot.profile_option_name = b.profile_option_name
    AND UPPER(pot.user_profile_option_name) LIKE UPPER('BNE%')
     AND b.application_id = a.application_id (+)
     AND b.profile_option_id = a.profile_option_id (+)
     AND a.level_value = c.responsibility_id (+)
     AND a.level_value = d.user_id (+)   AND a.level_value = e.application_id(+)
     AND e.LAST_UPDATE_DATE is not null
     --AND( UPPER( e.application_name) LIKE UPPER( 'username%')
     --OR UPPER( c.responsibility_name) LIKE UPPER( 'username%')
     --OR UPPER( d.user_name) LIKE UPPER( '%username%'))
     ORDER BY a.LAST_UPDATE_DATE desc, "Profile", "Level", "Location", "Value";




    Happy Learning
    --Sreene
    posted by Srinivasan .R @ 9:49 AM   0 comments
    About Me

    Name: Srinivasan .R
    Home: Chennai, India

    About Me:
    I am working as an Oracle Applications DBA specializing in EBS 11i/R12 with Over 14+ years of experience, mainly in different versions of Oracle Database & Application administration on various platforms like HP-UX, SOLARIS, AIX, Red hat Linux & Windows
    See my complete profile
    High Availability
  • Oracle10g RAC Installation
  • A Quick Reference for Oracle Database 10g RAC on Linux and Unix Platforms
  • Implementing Oracle 10g RAC with ASM on AIX
  • Locked objects for whole RAC
  • Monitor Memory RAC
  • Sessions RAC
  • Install Oracle 11g RAC On Linux
  • Migrating Oracle10g DB to ASM
  • Helpful Links
  • Good Metalink Notes
  • Discoverer:Metalink Notes
  • Logs Scripts:Metalink Notes
  • Support:Metalink Notes
  • Previous Post
  • R12.2. Start and Stop Procedure of Services
  • R12.2 Changing APPS or APPLSYS Password on R12.2 I...
  • Oracle E-Busines Suite R12 : Find all the profile...
  • Oracle EBS R12.2.5 New Features
  • EBS R12.2.4 Apps cloning Error (RC-50208)
  • Upgrade Oracle Database 10g to 11g R1 (11.1.X)
  • Oracle EBS R12.2 Architecture
  • Cloning the database from 11.2.0.2 to 11.2.0.3 on ...
  • Oracle12c Datafile moved Online
  • Oracle12c PSU Apply
  • Archives
    Download Software
  • Oracle 11g
  • Oracle 10g
  • 10g Express Edition
  • Oracle 9i
  • Oracle Apps
  • Oracle Linux
  • Oracle VM
  • App Server
  • Solaris
  • Fedora
  • Fedora
  • OpenSUSE
  • Ubuntu
  • Advertisement Links
    INTUIT Technology

    MACHS DATA

    Add Ons
    Locations of visitors to this page

    Add to Google Reader or Homepage

    Template by
    Sreene



    Oracle Application DBA Portal