Sunday, July 31, 2011

Script to list All OAF personalizations in the system

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;

14 comments:

Anonymous said...

It is posted from a metalink note I wrote, please give credit.

prichard said...

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

aparna john said...

Hi, Nice Script to list All OAF personalizations in the system.Thanks, its really helped me......

-Aparna
Theosoft

Anonymous said...

Nice script. Very Helpful.

Sherlyn Torbett said...

Hello Nice Script to all oracle personalization OAF system.Thanks, it really helped me..

Vijay SHarma said...

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

Sridevi Koduru said...
This comment has been removed by the author.
Cub Training said...

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.

Prologic Corporation said...

This is a good article & good site.Thank you for sharing this article. It is help us following categorize:
healthcare, e commerce, programming, multi platform,inventory management, cloud-based solutions, it consulting, retail, manufacturing, CRM, technology means, digital supply chain management, Delivering high-quality service for your business applications,
Solutions for all Industries,
Getting your applications talking is the key to better business processes,
Rapid web services solutions for real business problems,
Web-based Corporate Document Management System,
Outsourcing Solution,
Financial and Operations Business Intelligence Solution,

Our address:
2002 Timberloch Place, Suite 200
The Woodlands, TX 77380
281-364-1799

prologic-corp

Victoria Spencerr said...

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.

Sekhar Byna said...

Nice Information
Sekhar
http://ebiztechnics.blogspot.in

Sekhar Byna said...

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

Sridevi Koduru said...
This comment has been removed by the author.
Sridevi Koduru said...


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.