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;

13 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

Unknown 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.

Unknown said...

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

Vijay 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

Unknown said...
This comment has been removed by the author.
Unknown 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.

Unknown 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

Unknown said...
This comment has been removed by the author.
Unknown 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.