About Me.

My self Adinarayana working as Implementation Application DBA with advanced technologies like RAC/PCP,OID/SSO,DMZ,Exadata and Fusion Middleware i.e Demantra,Application Server,SOA,FMW,BPEL and UPK. Created this blog to share the useful information related to DBA and Application DBA Your comments and suggestions are most welcome. Disclaimer: Please note all the views and opinions expressed in this site are my own. It's not recommend to use the fixes/suggestions provided in this site directly in production instance, please test them before implementing.

Monday, July 22, 2013

Cloning

1.Script to find when it was cloned from front-end profiles

SELECT A.PROFILE_OPTION_NAME,B.PROFILE_OPTION_VALUE FROM APPS.FND_PROFILE_OPTIONS A, APPS.FND_PROFILE_OPTION_VALUES B WHERE A.PROFILE_OPTION_ID=B.PROFILE_OPTION_ID AND A.PROFILE_OPTION_NAME='SITENAME';
Posted by at
Labels:Database, Applications

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)