Saturday, January 10, 2009

Forms

Tips:
1.If you think that form is not rendering due to personalization, you can make it off using Help-->Diagnostics-->Custom code-->Off
2.Profile options to hide this property:
FND: Hide Diagnostics menu entry
Utilities: Diagnostics

Development/Customization:
1.copy TEMPLATE.fmb from $AU_TOP/forms/US to local machine and rename it
2.delete unnecessary blocks & create windows/block/items
3.Modify APP_CUSTOM program unit to write logic
4.Modify standard libraries like APPCORE,APPDAYPK,FNDSQF to modify standard toolbar or menu or calendar or messages or profiles or concurrent processing...
5.Modify CUSTOM.pll if you want to modify standard forms without modifying them
like hide/show or enable/disable or mandatory/optional fields. Include business rules like supplier name should be in CAPITAL LETTERS.

How to open multiple forms in single session
In menu form Tools --> Uncheck ( Close Other Forms) That's it

How to see form personalizations from DB?
Select Distinct
A.Id,
A.Form_Name , A.Enabled, C.User_Form_Name, D.Application_Name ,A.Description,Ca.Action_Type,Ca.Enabled,Ca.Object_Type,
ca.message_type,ca.message_text
from FND_FORM_CUSTOM_RULES a,
     FND_FORM b,
     FND_FORM_TL c,
     Fnd_Application_Tl D,
     Fnd_Form_Custom_Actions ca
where a.form_name = b.form_name
And B.Form_Id = C.Form_Id
And B.Application_Id = D.Application_Id
And D.Application_Id = 660 --For Order Management
And C.User_Form_Name Like 'Sales%'  --All the Forms that Start with Sales
And A.Enabled ='Y'
and a.id = ca.rule_id

No comments: