Fusion Blog

EBS Blog


Contact Us

  • Register

Oracle Gold Partners, our very popular training packages, training schedule is listed here
Designed by Five Star Rated Oracle Press Authors & Oracle ACE's.

webinar new Click here to raise Support Ticket. Get reply within 48 hours.

Search Courses

User Rating: 5 / 5

Star ActiveStar ActiveStar ActiveStar ActiveStar Active
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


Forms Personalization

Change LOV Query



a. Create a New Record Group

b. Attach new RG to LOV

Change field properties like Mandatory/Display etc



Zoom to another screen



a. Enable Menu
b. Trap the Menu event

Disable a Menu entry when certain conditions are met


See Note-1

Display messages, warnings, hints etc



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



Execute PL/SQL Stored procedures



Change Navigation and Navigational Properties



Change block properties like “Query Where Clause” etc



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


See Note

Show FND Messages with their tokens replaced


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.


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.

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.

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

Anil Passi


0 #1 Krishan 2007-10-24 17:20
this article is very informative.
0 #2 Srini C 2007-10-24 20:29
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
0 #3 Anil Passi 2007-10-24 21:12
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 www.google.com/search?q=site:apps2fusion.com+forms-personalizations

Anil Passi
0 #4 JayaraJ 2007-10-27 12:41
Hi All,

Can anybody say me how to upload the employees pictures thru PER_IMAGE_UPLOA D_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

0 #5 dsgnidhi 2007-10-30 09:41
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,
Srinid hi.
0 #6 Ashwathy 2007-11-08 15:57
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.

0 #7 sanjay kumar 2007-11-16 10:32
How to translate custom report from US language to FRENCH Language.
0 #8 Suryakanta sahoo 2007-11-20 07:26
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.

Pleas e let me know how this can be done.

0 #9 Suryakanta sahoo 2007-11-20 07:30
Hi Anil, my correct e-mail id is .

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.

0 #10 Vijay Goyal 2007-12-13 21:06
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?

Vij ay
0 #11 WRISHIN BHATTACHARYA 2008-02-04 07:15
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).

Thank s,
0 #12 silpa kuna 2008-02-07 10:59
Hi Anil

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

0 #13 Eduardo 2008-05-01 14:25
Hello Anil, I would like to make some changes to the custom.pll
I am using Oracle HRMS version 11.5
However, our Oracle installation is not in local servers of our own, but rather it is installed in Oracle servers that are mantained by Oracle On-demand
I can access the servers from a SSH connection, which I used to download the custom.pll to my local machine. When I tried to open it in the forms builder, it woudn't open because it asked me for other libraries that I must have locally and I don't.

Could you tell me what are the steps I need to follow to be able to edit the custom.pll locally and then upload it back to the server so I can test it (of course I would be using the test instance first)?

Thank you very much for your help

Eduardo Schñadower
0 #14 Anil Passi 2008-05-01 15:33

Custom .pll depends on libraries like appcore2.pll etc
You need to ftp all the dependent libraries from $AU_TOP/resourc e into a directory which is within your forms path

An il
0 #15 Cavelle 2008-07-15 14:57
The following only occurs for the 1st SO line, not all lines. The logic should be when the SO ststua is changed to Booked, then all lines should be set to 'Freeze Price'
The triggering event is WHEN-NEW-RECORD -INSTANCE on ORDER
:ORDER.ST ATUS = 'Booked'
the action to be carried out is:
The requirement is : When a Sales ORder is Booked all the lines get set to 'Freeze Price' for the calculate price

Any help would be appreciated

.. . Regards, Cavelle Toolsie
0 #16 Ajay Hazra 2008-08-22 12:15
Need some tips on how to use SQL validation in form personalization s.

Is it possible to use SQL in the condition section of the Forms Personalization s form?
0 #17 kritika 2008-08-27 03:14
I am very new to oaf so can u guyz please help me out.
I need to change the prompt of button as soon as it is clicked.

The button is in a table column. say its a update button not image as soon as it is clicked then the prompt is suppose to be changed to save and the message style text columns in that row r to be change to message input please guide me how to access the property inspector of each field...
0 #18 Parthasarathy 2008-09-19 02:43
Hi Anil,
I want to restrict the invoice matching by doing form personalization when the users enter more than the ordered qty on matching window.

Thank s,
0 #19 sara 2009-10-21 05:48

I want to loop through records in a block by doing first_record and next_record within a loop.
is this possible by FP?

0 #20 Rajapps 2009-11-05 07:50

Do anyone know how to call a procedure while clicking on the 'Book Order' Button in sales order.?

Thanks ,
0 #21 Tomas Mazurek 2011-11-19 07:18
Please, how can I do it in CUSTOM.pll: Display message with Questions, and conditionally execute code based on users response to the question... Any little example? Thanks.
0 #22 AAnbxxd 2021-06-25 09:57
http://clck.ru/Vhqmh http://clck.ru/VhqsP http://clck.ru/VhqtS http://clck.ru/VhqsM http://clck.ru/Vhqtp http://clck.ru/Vhqsq http://clck.ru/VhqtG http://clck.ru/Vhqso http://clck.ru/Vhqss http://clck.ru/VhqsT http://clck.ru/Vhqtc http://clck.ru/VhqtY http://clck.ru/Vhqsj http://clck.ru/VhqsX http://clck.ru/Vhqtv http://clck.ru/VhqtA http://clck.ru/Vhqtr http://clck.ru/VhqtC http://clck.ru/VhqsK http://clck.ru/Vhqta http://clck.ru/Vhqsf http://clck.ru/Vhqsm http://clck.ru/Vhqti http://clck.ru/Vhqsh http://clck.ru/Vhqsd http://clck.ru/Vhqte http://clck.ru/VhqtL http://clck.ru/VhqsH http://clck.ru/VhqsV http://clck.ru/Vhqtg http://clck.ru/VhqtQ http://clck.ru/Vhqt6 http://clck.ru/Vhqt8 http://clck.ru/VhqtW http://clck.ru/VhqsR http://clck.ru/VhqtU http://clck.ru/Vhqt4 http://clck.ru/Vhqsw http://clck.ru/VhqsZ http://clck.ru/VhqsF http://clck.ru/VhqtJ http://clck.ru/Vhqsy http://clck.ru/Vhqtt http://clck.ru/Vhqtk http://clck.ru/VhqtE http://clck.ru/VhqtN http://clck.ru/Vhqtx http://clck.ru/Vhqsb http://clck.ru/Vhqt2 http://clck.ru/VhqvQ http://clck.ru/VhqvL http://clck.ru/Vhqv8 http://clck.ru/Vhqu9 http://clck.ru/VhquK http://clck.ru/Vhqva http://clck.ru/Vhqub http://clck.ru/VhqvG http://clck.ru/VhquM http://clck.ru/VhqvS http://clck.ru/VhquR http://clck.ru/Vhqvg http://clck.ru/Vhqu3 http://clck.ru/Vhqv2 http://clck.ru/VhqvU http://clck.ru/VhquT http://clck.ru/Vhquh http://clck.ru/Vhqu5 http://clck.ru/VhquD http://clck.ru/VhquP http://clck.ru/Vhqum http://clck.ru/VhqvN http://clck.ru/VhqvC http://clck.ru/VhquX http://clck.ru/Vhqvc http://clck.ru/VhqvJ http://clck.ru/Vhquy http://clck.ru/VhqvW http://clck.ru/Vhqvi http://clck.ru/VhqvE http://clck.ru/VhquV http://clck.ru/Vhquf http://clck.ru/VhquF http://clck.ru/Vhqvk http://clck.ru/Vhqu7 http://clck.ru/VhquZ http://clck.ru/VhqvY http://clck.ru/Vhqud http://clck.ru/Vhqv6 http://clck.ru/Vhquj http://clck.ru/Vhqvn http://clck.ru/VhquB http://clck.ru/Vhqv4 http://clck.ru/VhquH http://clck.ru/Vhqve http://clck.ru/Vhquo http://clck.ru/Vhquw http://clck.ru/Vhquu http://clck.ru/Vhquq http://clck.ru/Vhqus http://clck.ru/VhqxL http://clck.ru/VhqxJ http://clck.ru/VhqxQ http://clck.ru/VhqxN http://clck.ru/VhqwK http://clck.ru/VhqxU http://clck.ru/VhqwT http://clck.ru/Vhqws http://clck.ru/VhqwF http://clck.ru/VhqxY http://clck.ru/VhqwR http://clck.ru/Vhqvv http://clck.ru/Vhqxc http://clck.ru/VhqwM http://clck.ru/Vhqwq http://clck.ru/VhqxS http://clck.ru/VhqwP http://clck.ru/VhqwH http://clck.ru/Vhqvt http://clck.ru/Vhqvz http://clck.ru/Vhqw7 http://clck.ru/VhqwD http://clck.ru/Vhqx4
jjimdzcvcxbnwoh dkk

Add comment

Security code

Search Trainings

Fully verifiable testimonials

Apps2Fusion - Event List

<<  Aug 2021  >>
 Mon  Tue  Wed  Thu  Fri  Sat  Sun 
  2  3  4  5  6  7  8

Enquire For Training

Fusion Training Packages

Get Email Updates

Powered by Google FeedBurner