CUSTOM.pll versus Forms Personalization
Written by Anil Passi   
Tuesday, 23 October 2007
It is indeed time to stop using CUSTOM.pll
If you are on 11.5.10, then it is important for development team to enforce the usage of Forms Personalization over CUSTOM.pll, where possible.


Most of the things that can be done using CUSTOM.pll can now be done via Forms Personalization.
However there are certain gaps for which we have no option but to rely on CUSTOM.pll

This article compares the two techniques i.e. CUSTOM.pll versus Forms Personalizations

Why should we prefer FP over CUSTOM.pll ?
1.    CUSTOM.pll is a single file/entity, hence only one developer can make changes to CUSTOM.pll at any given point in time.
You may also read best practices in CUSTOM.pll at this link
2.    If for some reasons CUSTOM.pll causes issues in Production, you will have to re-release the code changes after another round of UAT.
Form Personalizations makes this much simpler by allowing you to disable specific personalizations.
3.    You do not need to resort to programming for trivial tasks like changing prompt, and more so for changing prompts in Muli-Lang environment




Lets do a quick comparison between Forms Personalization and CUSTOM.pll

Task/Business Requirement

CUSTOM.pll

Forms Personalization

Change LOV Query

Yes

Yes

a. Create a New Record Group

b. Attach new RG to LOV

Change field properties like Mandatory/Display etc

Yes

Yes

Zoom to another screen

Yes

Yes

a. Enable Menu
b. Trap the Menu event

Disable a Menu entry when certain conditions are met

Yes

No
See Note-1

Display messages, warnings, hints etc

Yes

Yes

Display message with Questions, and conditionally execute code based on users response to the question

Yes

No

Execute PL/SQL Stored procedures

Yes

Yes

Change Navigation and Navigational Properties

Yes

Yes

Change block properties like “Query Where Clause” etc

Yes

Yes

Change is applicable across multiple screens, like Changing window title for all screens within one Organization/Responsibility

Yes

Yes
See Note
-2

Show FND Messages with their tokens replaced

Yes

See Note-3


Important: Oracle will keep on improving capabilities in Forms Personalizations.
Hence some of these limitations that we see now in Forms Personalization might disappear over a period of time.


Note-1

Once a menu has been enabled using Forms Personalization, it then can not be conditionally disabled. However the proposed workaround over this issue is to display a message when MENU is clicked in the scenario’s it was meant to be disabled.



Note-2
Lets say you want to change the window title for all the screens within a responsibility. In this case, in CUSTOM.pll you could do so by a pseudo code similar to below
    If fnd_global.responsibility like ‘XX%CASH%’ THEN
        Set window title ( ‘Note: All transactions are audited’);
    End if
As you can see, this can be achieved quite easily in CUSTOM.pll  and the changes will be visible across multiple screens in the context.
However, for Forms Personalization, you will have to go and personalize each and every screen for which you want this change to be effective.


Note-3
The proposed workaround is to display the message that is returned as a result from SQL Statement.





Time for some Q&A


Question: Should we migrate code from CUSTOM.pll into Forms Personalization?
Not really, there is no value in doing so, given that CUSTOM.pll is still supported and will remain so within the realms of Apps Unlimited.


Where is the metadata for Forms Personalization stored?
These personalizations are stored in FND tables



What is called first? Forms Personalization or CUSTOM.pll
First your form personalization is called, and then CUSTOM.pll is called.



Is forms personalization called for additional set of triggers vis-à-vis CUSTOM.pll?
Not really, the same set of triggers are passed to both CUSTOM.pll and Forms Personalization. To understand the fundamentals, visit this link CUSTOM.pll concepts
Comments (12)add
informative
written by Krishan , October 24, 2007
this article is very informative.
...
written by Srini C , October 24, 2007
Hi Anil,
Your Article is excellent and informative.
I have a question on the forms personalization, I want to make the entire tab form as read only. (EX: My requirement is to make the Addressed, amount, profile tab forms as read only and remaining pages as normal. Is it possible to make this with the forms personalization.)

Thans in Advance,
Srini C
...
written by Anil Passi , October 24, 2007
Hi Srini

You can do that using forms personalization.
Using that, you can set the block's update property to False or else you can set the individual item properties to false too.

Have a look at article in this link http://oracle.anilpassi.com/fo...tions.html

Thanks,
Anil Passi

UPLOAD Employees Picture
written by JayaraJ , October 27, 2007
Hi All,

Can anybody say me how to upload the employees pictures thru PER_IMAGE_UPLOAD_PKG.LOAD(). Here i am having 2500 employees photos.
and if it is step wise manner it will be more helpful and where we have to place the pictures in server , in which location

Regards
Jai
Blocking master org for different forms
written by dsgnidhi , October 30, 2007
hi anil ,
I have a requirement to block the master org in the lov of Change organization form for some of the forms .
please let me know i can i achieve this.
thanks and regards,
Srinidhi.
Disable OK button on PO Control Actions
written by Ashwathy , November 08, 2007
Hi Anil,

I need to disable the OK button when the COntrol ACtions in the PO Summary FOrm is Finally Close.

Please let mw know how this can be done.

Thanks,
ashwathy
custom report translation
written by sanjay kumar , November 16, 2007
How to translate custom report from US language to FRENCH Language.
How to call the BPEL process in form personalization
written by Suryakanta sahoo , November 20, 2007
Hi Anil,

I would like to know how to call a BPEL process thru form personalization.Whenever customer will click on a URL a new window will be open and customer will select/update the data thru that new screen.After selecting the data will be update again in oracle data process.

Please let me know how this can be done.

Regards,
Surya
...
written by Suryakanta sahoo , November 20, 2007
Hi Anil, my correct e-mail id is suryakant.sahoo@media24.com.



I would like to know how to call a BPEL process thru form personalization.Whenever customer will click on a URL a new window will be open and customer will select/update the data thru that new screen.After selecting the data will be update again in oracle data process.

Please let me know how this can be done.

Regards,
Surya


How to disable standard warning message
written by Vijay Goyal , December 13, 2007
Hi,
I need some suggestion to suppress the standard warning message in stabdard form.
If user select value one from LOV, i don't give warning message but if user select value two, it will give warning message. User don't want to see the warning message. Please suggest, how should i tackle it?

Thanks
Vijay
Getting parent form Instance thu CUSTOM.pll
written by harjit , February 04, 2008
Hi Anil,
I am having teh below scenario.

1) On some event/Zoom of a Form X , i have to open a form Y where a user selects some address.
2) When user selects some address on Form Y,I have to copy the selected address to one specific field in the opening form i.e. X .

Custom.pll is the only change that i can make....

Rt now i am doing the following
1) On the evnt of for X, i open a form Y
2) When user selects a address, i copy it to a Local Variable ... and fire on event on this form (Y) ..( Whose handler copies the selected address to the Global Variable ) ... i.e. now the address is in the Global variable accessible to the Custom .pll .... and then i exit this form i.e. Y.
3) Wait for any event to accor on the Form X and block B .. so that the value of the Global variable gets copied to the correct field in this X form. (THIS THING IS NOT WORKING CONSISTENTLY and the user has to seometimes manually click on other field in this Bloack to force copying of the value).

What i need to know ?
I need to know that while i am in the Form Y ... is it possible for me to get Hold of the Opening form (X) and fire a event on that (Because in Custom.pll i have written a handler for that event which will copy the value from Global variable to the Form X fields).

Thanks,
Harjit
Call procedure thru Forms Personalization and based on the output of procedure do further validation
written by silpa kuna , February 07, 2008
Hi Anil

I need to use forms personalizations and call a procedure with out parameters through it. Based on the output from the procedure I have to do further validations.
Could you tell me how this can be done?

Regards
Silpa
You must be logged in to a comment. Please register if you do not have an account yet.

busy