ORACLE

ORACLE
Let us share our knowledge to the world of oracle apps. I am trying my best to do so and I request every one to contribute their part. If you have any thing useful related to oracle apps, do send me I will post in my blog on behalf of you. If you like my blog tell the world about it, else tell me i will improve. You can suggest me, what exactly you want on oracle apps. Mail your queries.

Wednesday, December 28, 2011

Script to list the forms in Oracle Applications that have been customized using Forms Personlization:

This blog is about to find list of forms in oracle application which has been
customized using Forms Personlization.

This script will be very useful to identify the customization while migrating and also will usefull to prepare
Customization lisits while upgrading ,reimplementation
select distinct a.form_name ,
         a.enabled,
         c.USER_FORM_NAME,
        d.APPLICATION_NAME
from FND_FORM_CUSTOM_RULES a,
         FND_FORM b,
         FND_FORM_TL c,
        fnd_application_tl d
where enabled = 'Y'
and a.form_name = b.form_name
and b.form_id = c.form_id
and b.application_id = d.application_id
order by application_name

No comments:

Post a Comment