Use the below script to list all personalizations in the sytem.
We then can use the functional administrator to disable the personalizations in case it is required.
This would be very useful script at the functional administrator doesnt' provide % search capabilities
I got this from metalink and putting it here for quick reference
SELECT PATH.PATH_DOCID PERZ_DOC_ID,
jdr_mds_internal.getdocumentname(PATH.PATH_DOCID) PERZ_DOC_PATH
FROM JDR_PATHS PATH
WHERE PATH.PATH_DOCID IN
(SELECT DISTINCT COMP_DOCID FROM JDR_COMPONENTS
WHERE COMP_SEQ = 0 AND COMP_ELEMENT = 'customization'
AND COMP_ID IS NULL)
ORDER BY PERZ_DOC_PATH;
Sunday, July 31, 2011
Subscribe to:
Post Comments (Atom)
13 comments:
It is posted from a metalink note I wrote, please give credit.
Thanks a ton to the original author of the Metalink Note -
Is There A Way To List All Personalizations In An Environment? [ID 1332032.1]
And also to Murthy for posting it on this website.
It saved me hours.
Regards,
Richard
Hi, Nice Script to list All OAF personalizations in the system.Thanks, its really helped me......
-Aparna
Theosoft
Nice script. Very Helpful.
Hello Nice Script to all oracle personalization OAF system.Thanks, it really helped me..
If you or your friends are interested then please revert back with your updated resume.
Location: Bangalore,Hydrabad/NOIDA/Gurgaon
Oracle Applications (Finance)
Role: Consultants/Senior Consultants/Team Leads
Experience: 3 to 7 yrs
Relevant Exp: 3 Yrs in Oracle Applications (MUST)
Company: Big MNC
Profiles:
1. Oracle Apps Functional Financials with Project Accounting
2. Oracle Apps Technical with Financial Module
3. Oracle Apps Functional with Financial Module
Contact: +91-120-6518887, +91-8800841677,inquiry@erpocean.com,www.erpocean.com
Its impressive to know something about your note on Oracle apps Course. Please do share your articles like this your articles for our awareness. Mostly we do also provide Online Training on Cub training oracle apps course.
Oracle Apps Technical Online Training by Lead Online Training providing for you extreme chance to enhance shot of arriving at your objectives. ORACLE APPS TECHNICAL Online TrainingOur Institutes giving a wide range of courses like Oracle APPS Technical through online over the Worldwide with continuous ventures furthermore we have over 10 years experience of IT experts in Oracle APPS Technical. So this is the best offer for your better future.
Nice Information
Sekhar
http://ebiztechnics.blogspot.in
Very interesting notes on ebusiness Suite
Please do share your articles like this.This link also useful to Find info On Oracle apps-jobs,interview tips,Resume preparation,functional issuesOracle eBusiness Suite
Regards
Sridevi Koduru (Senior Oracle Apps Trainer Oracleappstechnical.com)
LinkedIn profile - https://in.linkedin.com/in/sridevi-koduru-9b876a8b
Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, SQL, PL/SQL, D2K at sridevikoduru@oracleappstechnical.com | +91 - 9581017828.
Post a Comment