Form Personalization and CUSTOM.PLL are two utilities provided by Oracle E-Business suite to alter the standard behaviour of user interfaces. They are handy to perform tasks such as disabling the fields, implement zoom functionality, change caption (prompt) values, display custom message and create custom menus for a particular form. CUSTOM.PLL and form personalization both are equally capable to change working process of all the modules. Yet they still have minor differences which surpass the power of one over the other depending on the situation.
PLL in CUSTOM.PLL stands for programming link library provided in Oracle E-Business Suite package to modify the standard working of function using PL/SQL programming language while form personalization accomplishes the same thing using an fairly easy user interface.
Difference between CUSTOM.PLL and form personalization is a well-known question asked to Oracle E-business Suite developers during their Oracle Apps technical interviews.
Difference between Form Personalization and CUSTOM.PLL
|Form Personalization is a graphical user interface||CUSTOM.PLL is a programming linked library|
|Multiple developers can work simultaneously in form personalization activity||Only one developer can work in CUSTOM.PLL if an ideal version maintenance process is followed|
|PL/SQL programming knowledge is a must to perform tasks such as disabling the fields, changing the prompts etc.||No need of programming knowledge to disable fields, change prompts etc.|
|Form personalization changes can be previewed using Validate button||CUSTOM.PLL changes cannot be previewed. The library needs to be compiled every time you make changes|
|You have to visit multiple forms equally multiple times to disable form personalization||All the codes of CUSTOM.PLL can be commented at once|
|Multiple choice of action message box is not possible with form personalization||Multiple choice of actions message box can be created using CUSTOM.PLL|
|Module specific form personalization is not possible||Module specific CUSTOM.PLL changes such as XXCUSTOMPO.PLL or XXCUSTOMAR.PLL are possible|
|Easier to implement than CUSTOM.PLL||Requires UAT testing, impact analysis and re-release of CUSTOM.PLL in case of errors in the same|
|Menu cannot be disabled conditionally in the form personalization||Menu can be disabled conditionally through CUSTOM.PLL|
|Form Personalization have less precedence over CUSTOM.PLL||CUSTOM.PLL have more precedence over form personalization|
Hope you like this article and find it useful. We highly appreciate comments and feedback.
Hi I am Paras.
Thanks for stopping by at OracleMine.com. Speaking about my brief introduction, I work for a multinational organisation in Oracle related technologies. Being an avid blogger, I would like to inform you about my productivity and motivational blog XpressPlanet.com. Speaking of OracleMine.com, I will try my best to share knowledge on technologies in as simple and understandable manner as possible. You can also contribute your knowledge on OracleMine by writing to us at firstname.lastname@example.org. Again I appreciate your visit. Hope to see you again and again!