Login
Register

Home

Trainings

Fusion Blog

EBS Blog

Authors

Contact Us

Miscellaneous
  • 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
 

In this article, I would like to explain different possibilities of Forms Personalizations. Surely before explaining what can be done, first we will touch base upon what exactly it is.



Why was forms personalization  introduced by Oracle in 11.5.10?

1. CUSTOM.pll is a programmatic methodology for extending Oracle Forms, even for trivial tasks.

2. Multiple developers working on same CUSTOM.pll could cause version related headaches

 

Does Forms Personalization replace CUSTOM.pll?

Not really, however it does provide an alternative to most common activities for which earlier one would use CUSTOM.pll

Forms personalization is driven by the same set of events as that for CUSTOM.pll.

Keep in mind that Oracle Forms Libraries first invoke the Forms Personalization, and then the CUSTOM.pll too for the same set of events.



How do I enable Forms Personalizations?

Enable the personalizations using the Help/Diagnostics menu.

To personalize any Oracle Forms screen in EBS, firstly navigate to that screen [say "PO Entity" screen].

From the Help menu, select Diagnostics > Custom Code > Personalize

What are the various components of Forms Personalizations?

Different components of Oracle Forms Personalizations are listed below. You begin with recognizing which Triggers/Events that you wish to trap and  under what conditions. The condition can be entered using the syntax as defined in the picture below.



What does the Action Tab do?

Here you will either change form property, or display messages or enable menu etc.



Can I modify SQL Query behind the LOV using Forms Personalizations?

Of course you can. In the below example I am restricting the LOV to less than 3records by introducing where rownum <3 in record group query.

Step 1. Create a new record group

Step 2. Attach the newly created record group to existing LOV in EBS Form.

 

Can I call a PL/SQL Stored procedure passing it form field variables?

Yes,  using the syntax below.

Note: You can also invoke FORMS_DDL built-in to perform DDL.

m'declare

v_field_value VRCHAAR2(200)= -||$(item PO_CONTROL_RULESOBJECT_CODE_DISPLAYED_VALUE value)||-;

begin

xx_test_001_proc(v_field_value);

end"

 

Can I call BuiltIn's?

Indeed, as shown below, you can pick  from all the form built-in's as below.



You can also call a form function and pass it parameters using Forms Personalizations



Processing can be aborted if validation were to fail

 

You can invoke equivalent to app_item_property.set_property.

 

You can  initialize a global variable. Initialization code is executed if and only if the global variable does not already exist.

Use global variables for passing variables back and forth between two forms.

Please do not use Global Variables if your logic is restricted to a Single form  itself.

 

You can assign values to form fields  using global variable.

 

 



Using forms personalizations, you can set the Default where clause of the BLOCK too.

Note: Don't forget to reset this clause after your desired operation has been finished. This will facilitate the form to run in standalone mode too.

ObjectType : Block

Target Object : PO_CONTROL_RULES

Properly Name : DEFAULT_WHERE

Value : RULE_TYPE_CODE="EXCLUDE"



Ditto for Order by Clause on block.

ObjectType : Block

Target Object : PO_CONTROL_RULES

Properly Name : ORDER_BY

Value : RULE_TYPE_CODE 

For displaying messages, you can either enter a plain text, or your message can be displayed from the result of a SQL Statement.

 

Local variables can be defined and they will be active for throughout the session of the current form.

Use global variables if you wish to share the variable between multiple forms.

Below, just for demo, I am setting the local variable to 0.

 

 

In the below picture, I am checking if local variable is 0 then display a message.



You can enable SPECIAL1-15 or MENU1-15, to create new menu entries under the Tool menu.

 

The above two setups have instantiated the new Menu Items

 

SPECIAL16-30 will create entries under Reports menu

SPECIAL31-45 will create entries under Actions menu



You can capture the click on those newly created menu items by trapping event MENU1 or SPECIAL1 [or whatever you defined]

 

 


Anil Passi

Comments   

0 #1 gurumurthy 2007-04-21 00:00
hi anil,
This Forms Personalization Presentation is really helpful .could you help me how to get the return value of an Stored procedure or Function .
thanks.
Quote
0 #2 Omkareswar Masala 2007-04-21 00:00
Hi Mr.Anil,
Very useful to me this article.You are giving the lot of information regarding Oracle Apps in your site. I am thankful to you.

Thanks & Regds
Omkar
Quote
0 #3 m.sridhar 2007-04-22 00:00
thanq u very much this article is very good.
Quote
0 #4 Rajiv 2007-04-22 00:00
Hi Anil,

Thank you so much for your contribution. Apart from the questions mentioned in ur list, where can I find some more material on HRMS Interview questions?

Thanks in Advance
Rajiv
Quote
0 #5 Rakshit 2007-04-23 00:00
Hi Anil,
I tried to put a personalization using WNRI on the quantity field and yes it worked. Now the question is that i tried the same last friday and it did not work for some mysterious reason. I have heard that forms personalization done through this screen in front end is not always stable and may sometimes behave weirdly. Is it True? Thanks a lot for the quick reply.
Quote
0 #6 Anil Passi 2007-04-23 00:00
Hi Rakshit

It appears that your personalization s are being over-ridden either by standard Oracle code or something in CUSTOM.pll

A s you mentioned, the field gets disabled after you move to quantity field of the next record.

Try to re-enable this in WHEN-NEW-ITEM-I NSTANCE of the QUANTITY field itself and also in WNRI

Also, try to open the form and find the code that disables that field. See if any condition is built around and if that can be bypassed my means of FP.

thanks,
anil
Quote
0 #7 Anil Passi 2007-04-23 00:00
Hi Rakshit

Form s personalization [FP] is as consistent as any other form of coding, because internally FP gets translated into a program itself.

Glad to hear that it is working now.

Thanks,
An il Passi
Quote
0 #8 Anil Passi 2007-04-23 00:00
Hi Niraj

Please use the steps listed in URL below

http://docs.google.com/Doc?id=dkg3r3j_310dkmcbg

Thanks,
Anil Passi
Quote
+1 #9 Niraj 2007-04-23 00:00
Amazing....than ks a lot Anil for the initcap solution. Really appreciate it.

Niraj
Quote
0 #10 Joel 2007-04-25 00:00
Hi Anil, I too have an Oracle Apps blog and I was wondering if you can help me with a requirement from one of the readers on my blog. His requirement is that he wishes that when querying a SO in the Sales Order form, the ITEM_DESCRIPTIO N_MIR value of the SO line would populate automatically to the USER_ITEM_DESCR IPTION field if NULL, and this needs to be done for all lines, if there are many lines on the SO. Here what he has done so far: CONDITION: Trigger Event: When-New-Item-i nstance Trigger Object: LINE.USER_ITEM_DESCR IPTION CONDITION: :LINE.USER_ITEM_DESCR IPTION is NULL ACTIONS TAB: Seq 10 Property Object Type: Item Target Object: LINE.USER_ITEM_DESCR IPTION PROPERTY NAME: VALUE VALUE: =${item.line.it em_description_ mir.value} (This works but it requires the user to click on the USER_ITEM_DESCR IPTION field of each line for the value to populate automatically. What is he missing in order for all lines to populate the value from ITEM_DESCRIPTIO N_MIR to USER_ITEM_DESCR IPTION)? The requirement is : When querying a Sale Order, click on the Line tab, they want the system to automatically populate, for all lines, the ITEM_DESCRIPTIO N_MIR field value to USER_ITEM_DESCR IPTION field thru Forms Personalization . Any help would be appreciated... Regards, Joel Asselin
Quote
0 #11 Prabhakar 2007-04-25 00:00
Anil,
You are just awesome..the way things have been explained...jus t unprecedented.. .kudos!!!

Pr abhakar
Quote
0 #12 Joel 2007-04-26 00:00
Anil,

Thank you for your prompt and clear response. The information you have on your site is awsome...

Th anks again.
Quote
0 #13 anil passi 2007-05-04 00:00
for the record history, in your block add a column named current_record_ indicator with appropriate subclass property.

fo r iproc, if you wish to add further sub-tabs, then add form functions via sub menus

thanks ,
anil
Quote
0 #14 BasavanaGowda 2007-05-08 00:00
Hi Anil,
I would like know how to Add the LOV to text field through Forms Personalization ..

Thanks in Advance
B.Gowd a
Quote
0 #15 Anil Passi 2007-05-09 00:00
Greetings Gowda

For the error on Execute stored procedure
use syntax ${item.blocknam e.fieldname.val ue}
instead of :blockname.fiel dname

Thanks ,
Anil
Quote
0 #16 BasavanaGowda 2007-05-16 00:00
Thank u So much Anil for very very quick reply...
pleas e provide me the steps for attaching new LOV(Customized) /Value Set to a text field through custom.pll

R egards,
B.Gowd a
Quote
0 #17 Anil Passi 2007-05-27 00:00
Hi Robert

Pleas e perform this validation in WHEN-VALIDATE-R ECORD. I believe that will guarantee you to display the message.

You can also enable Show Custom Events using Help menu, to see the trigger name that gets transmitted to FP/CUSTOM.pll when the window is getting closed.

However WVR is the ideal candidate for this requirement.

Thanks,
Anil
Quote
0 #18 Robert 2007-05-30 00:00
Hi Anil,
I would like to clarify my issue. My error message always displays when the combination of the 3 fields are not legitimate. My problem is that the assignment screen closes even after throwing the FORMS_TRIGGER_F AILURE.
Specif ically:
1. The user changes data on the assigment screen.
2. The user closes the assignment screen.
3. A seeded message asks if user wants to save the changes.
4. The user responds, Yes.
5. My function finds the changed data not legitimate.
6. The personalization displays a message.
7. The personalization throws FORMS_TRIGGER_F AILURE.
8. The assignment screen closes anyway.
How can I prevent the assignment screen from closing if there is an error. The FORMS_TRIGGER_F AILURE does not prevent the screen from closing. The person screen is displayed and Oracle asks the user to save the changes.

Tha nks for your help
Bob
Quote
0 #19 Robert 2007-05-31 00:00
Hi Anil,
I tried using WHEN_VALIDATE_R ECORD but there are many existing records that produce the personalized error message. The users many times want to just browse the records in production and the error message popup slows them down. They prefer to be presented with the error message only when inserting or updating the assignment record. Is there a way to use WHEN_VALIDATE_R ECORD but not produce the message unless the user has inserted or updated the record. I am currently using POST_UPDATE and POST_INSERT but I run into the problem I described in my earlier post.
Thanks for your help,
Robert
Quote
0 #20 Puja 2007-05-31 00:00
Anil
In the above URL [docs.google.co m]
can you please tell the next step how to do and what builtin to use to move the cursor to the first record.
Thanks
Puja
Quote
0 #21 Anil PAssi 2007-05-31 00:00
Hi Robert

WHEN-VALIDA TE-RECORD must not fire if no changes were done to the record.
Is there anything in POST-QUERY of that block? It is possible that in WHEN-NEW-RECORD -INSTANCE or WHEN-NEW-ITEM or POST-QUERY value in one of the database based fields is being altered.

Hence this causes WVR to fire while scrolling through the records.
Please try to fix the source of the problem, then WVR will not fire unless and until record gets modified.

Thanks, Anil Passi
Quote
0 #22 Puja 2007-05-31 00:00
Hi Anil

Thank you very Much for a such quick Reply
God Bless you
But, anil i oath i am confused can u send me a screen shot if possible

Tha nks
Quote
0 #23 Anil Passi 2007-06-05 00:00
Hi Priya

Unfort unately currently FP does not permit changing block property for Current Record Visual Attribute. If that were to be allowed, then you could have changed the property depending upon the value of attribute column.

As a workaround, you might try changing Visual Attribute for item instance,agains t each and every item in the record. However, you will also need to find a way to reset the Visual Attribute after the cursor moves away from current record.

I guess, given the constraints, the best bet is to use CUSTOM.pll for this requirement

Thanks,
Anil Passi
Quote
0 #24 Priya Viswantha 2007-06-05 00:00
Hi Anil

Thanks for the reply
Well, as you said above i have changed the visual attribute, I am able to change the background colour of an item in a record. But now the problem is the cursor is not going back to the first record.

God Bless You
Thanks
Pr iya Viswantha
Quote
-1 #25 Srinivas 2007-06-06 00:00
my client want to hide the TaxPayerID (SSN) no. for the suppliers accross all modules PO, AP, payments. so i started creating the new recordgroups for the LOV those displaying the SSN info like supplier name, supplier Number columns on Find purchase order form .....

For those record groups which dont have bind variables i am able to hide the ssn info in the LOV but on the find payments form when i tried to create the record group with the same standard record group that was taken from the form which contains bind variables is not working.

Any help will be appreciated.

Thanks in advance
Srini
Quote
0 #26 Priya Viswantha 2007-06-14 00:00
Hi Anil,

Thanks for all your help
God Bless You
I did it.
Once agian thanks for your time.
Quote
0 #27 Avinash 2007-06-15 00:00
Hi Anil,
I am working on Receivables - Transaction Information DFF, there are about 8 segments in the DFF structure which is referenced to $PROFILE$.ORG_I D (context sensitive). As well there are about 8-10 Receivables responsibilitie s, which are having Transactions functions.
Out of the 8 segments I want to disable 2 segments to specific responsibilitie s. How can I achieve this through form personalization ? I tried different ways but not able to catch the DFF form and specific segment Item,property on it on ARXTWMAI form.
Thanks
Avinash
Quote
0 #28 Vamsi 2007-06-18 00:00
I have to call a OA page from form. Can you please provide the steps.....
Quote
0 #29 Anil Passi 2007-06-19 00:00
Hi Vamsi

I think the call to fnd_function.ex ecute [i.e. Launch a Function] should wor for OA Page too provided you have registered your OAF Page as a Function.

Th anks,
Anil
Quote
0 #30 Anil Passi 2007-06-19 00:00
Hi Sudhir

Pleas e see my article on FNDLOAD

Than ks,
Anil
Quote
0 #31 Manoj 2007-06-22 00:00
Hi Anil,
I have a requirement where based on the value selected for a item numeber in the Purchase Order Screen the DFF value set value must change.
Is this possible using Forms Personilization .
Regards,
Ma noj
Quote
0 #32 Anil Passi 2007-06-22 00:00
Hi Manoj

Create a value set dedicated for that DFF Segment.
In that Value Set of type Table, have a OR condition or a UNion to make its SQL sensitive to the desired field.

Alter nately, consider using that that field as the context for DFF.

Thanks,
Anil
Quote
0 #33 Ravi Thota 2007-06-27 00:00
Dear Anil,

First of all, thank you very much for knowledge input.

Can u explain more on creating RECORD GROUPS and attaching to LOV, to restrict the results.

i have gone thru your documents on FP, but something is missing about creating RECORD Groups since the whole process is explaing in short screens in one page.

Please i will be very thankfull, if u can explain more on it...

Thanks in advance
Ravi kumar thota
Quote
0 #34 kiran 2007-06-27 00:00
Hi Anil,

I have got a unique kind of requirement on the ARXTWMAI ( AR -> TRansactions Screen).

1. We have a DFF on TRansaction Headers (Transaction Information) where we capture the Company segment of Acct FF for Deposit Class.

2. Now I have to Duplicate the Value in this DFF into the Segment4 of Accounting FF. we have Rec and Rev Accounting for Deposits.

Ca n this be achived using FP or any other alternative is there?

Appre ciate your help.

-kiran
Quote
0 #35 Mohan 2007-06-27 00:00
Hi Anil,

Thanks a lot for your great explanation.

We have a requirement to create a new LOV based on a Record group, which will display 10 fields. As soon as the user selects a value in the LOV, we should default few other fields.

You explained in the earlier threads that it is not possible through Forms Personalization s. Can we do it using CUSTOM.PLL??

Or is it possible to modify an existing Record group to add couple of additional columns and allow the user to search based on the new columns?

How do we address these kind of requirements?

If we open up the form and create a new LOV, the changes will go off if we apply a patch that has newer version of the form.

Thanks in advance,
Mohan.
Quote
0 #36 Anil Passi 2007-06-28 00:00
Hi Mohan

Struct ure of the Record Group must not change, because you can not define the mappings to LOV columns using FP.

In this case, do the below steps:-
1. Create a Custom form that lets you search on your data and it presents results[10 fields] in Multi Record block
2. using FP in main screen, call that form function via tools menu. Tell users that its going to work via tools menu if they wish to see 10 fields in LOV
3. in the custom form, provide a button to select one of the records. on selection initialize global variables. program this custom form to navigate back to main form after global variables have been set
4. back in main form, assign the values from global variable into main screen, using FP


Thanks
Anil
Quote
0 #37 Vamsi 2007-07-10 21:55
Anil,

My requirement is to call OA page from form with 2 paramters.

As you mentioned above I have created Menu Items and attached function to call OA page......

Can you tell me how to pass parameters ?

I have given paramters like this "InvoiceNumber = :TGW_HEADER.TRX _NUMBER&Invoice SeqNumber = :TGW_HEADER.ATT RIBUTE4" but when am opening the page it is giving error as "Illegal String passed need to encode it"

Appreciate your help....
Quote
0 #38 Marcus 2007-07-12 09:03
Hi Anil,

do you know of a way to create new menu items in the tools menu with PL/SQL?

Thanks
Marcus
Quote
0 #39 Anil Passi 2007-07-12 09:06
Hi Marcus

Have a look at the fndload lct file that creates menu.
You will find your pl/sql there.

Thanks
Anil
Quote
0 #40 veera 2007-08-15 03:45
Hi Anil

I would like to know what queries are used by a perticular form (for ex: PO creation form) when i perform save opertation.

Is there any consolidated help page from oracle where it displays all the operations like search, update etc queries?

Rgds,
Veera
Quote
0 #41 mv 2007-08-18 10:17
Anil..Really useful site...Good source of contributions from yourself and others...

Ques tion to you now regarding one area of personalization which I am getting confused and not able to get the syntax right...
Using the 'Execute Procedure' builtin, I need to read and assign values from form fields.
for eg: There is a block 'ADDR_SU' with a field name 'TAX_CODE'
I need to write a condition in the procedure that if TAX_CODE is null then set TAX_CODE to be 'Exempt'

I am able to do this using
Object_type->I tem
Target object->ADDR_SU .TAX_CODE
Property Name->VALUE
Value->nvl(:ad dr_su.tax_code, 'Exempt')


But would like to know how to handle this from within 'execute procedure' builtin.
I have been reading the SPEL and the R12 doco but I should admit I am just going bonkers getting the syntax right..

Thanx
Quote
0 #42 Ashwathy 2007-08-28 21:44
Hi,

This site is really good.
I need some help. In the PO form,I need to set the invoice match option to PO when the match approval level is set to 2-way and when it is 3-way i need to set it to receipt.How do i acheive this using forms persnalization?

Thanks
ashwat hy
Quote
0 #43 Sridhar A R S 2007-09-01 16:59
Hi Anil

The articles on your site are simply Awesome .We are implementing Oracle HRMS here in Middle east .My question is can we launcgh a URL with parameters at run time through Form personalisation .for example


An ORACLE user is navigating an ORACLE form that is displaying the “annual leave” information of an employee dated 12/11/2006, the parameters to be sent to url are:
a.Employee Number: 1123
b.Document Type: Leaves
c.Docume nt Sub Type: Annual
d.Docume nt Date: 12/11/2006

The button should call the custom integration page; The following HTTP Request will summarize the above:
http://. ........../Inte grationPage.jsp ?EmpNo=1123&Doc Type=Leaves&Doc SubType=Annual& DocDate=2006111 2

Thanks in advance

Rgds
S ridhar
Quote
0 #44 Anil Passi 2007-09-01 18:22
Hi Sridhar,

Of course you can.
Register this JSP page as a FUNCTION
This jsp page will reside in OA_HTML
Next, simply use fnd_function, with the syntax detailed in link www.google.com/search?q=site:apps2fusion.com+call-oa-framework-page-from-oracle-forms-passing-parameters-2

The jsp page can be registered as

Do let me know if the jsp page in question is hosted outside of eBusiness Suite environment. In which case I can suggest you a separate approach.


Tha nks,
Anil Passi
Quote
0 #45 Sridhar A R S 2007-09-03 07:02
Hi Anil

You guessed it right this JSP page is a third party page and resides outside the EBS

Thanks a ton for the above suggestions

Rg ds
Sridhar
Quote
0 #46 Sridhar A R S 2007-09-04 13:48
Hi

The JSP resides outside the E Business Suite (a third party page) .Please suggest how to call that web url by passing the parameters at runtime like employee number etc ;

thanks a ton for the help

Rgds
Sridhar
Quote
0 #47 Paw 2007-09-05 09:37
Hi,

I have one issue in sales order form in lines block(other tab).

I added column intmed_ship_to_ location.in intmed_ship_to column has lov attached.
i'm selecting intmed_ship_to loke(10072DE).o n the basis in another field means
intmed_sh ip_to_locations hould be apeear like as name.Now i'm using custom.pll
bloc k='line' and event='when-new -item-instance' .
when i select value for intmed_ship_to and click on that item.then location name come,
intmed _ship_to_locati on is not store in database.

when i again query the same order what i see the same value is appering in intmed_ship_to_locati on
like intmed_ship_to( 10072DE).

Plea se also let me know can i do this by form personalization .
I already enter this queries ib ur portal

Please help me for this issue

Thanks in advance.

Regar ds
Pawan
Quote
0 #48 Andrew 2007-09-07 17:54
Hi Anil,
I follwed the directions you gave in
"Can I modify SQL Query behind the LOV using Forms Personalization s?"
to overwrite country of birth LOV on the PERWSHRG form with the following SQL:

select v.Description, v.Lookup_Code
f rom Fnd_Lookup_Valu es v
Where lookup_Type = 'PQP_US_COUNTRY _TRANSLATE'
And Language = fnd_global.BASE _LANGUAGE
And Enabled_Flag = 'Y'
Order by 1

When applying and navigation back to the person form. The LOV returns no list of values. When running this SQL outside the application, it returns 238 rows. Any ideas on what I am doing wrong.

Thank You for some great documentation
Quote
0 #49 Deepak Prabhakar 2007-09-11 13:57
Dear Anil, Can you please suggest how to disable delete button on Oracle standard Toolbar for any oracle form.

Apprecia te your any suggestion
Than ks
Deepak
Quote
0 #50 Suree 2007-09-17 23:38
Hi Anil.

Thanks a lot of such a great article.
I have a question here.

In Action: Building and Builtin Type: Execute a Procedure, I am calling a procedure as below:
='Declar e
l_chr_retcode Varchar2(1000);
l_chr_errbuf Varchar2(1000);
l_chr_out_value Varchar2(1000);
Begin
xxx_pkg.xxx_pro c(out_chr_errbu f => l_chr_errbuf,
out_chr_retcode => l_chr_retcode,
out_chr_out_val => l_chr_out_value );
End'
Now, in this procedure, I need to assign l_chr_out_value that I got from the procedure call to a form item. There are way of doing it like assigning this to package variable and then assigning the package variable back to the form item. But is there any way that I can direcly assign it to form item?

Warm Regards,
Suree
Quote
0 #51 Mohan1 2007-09-26 23:22
Hi Anil,

I have a requirement to calculate Collectable Amount (Amount_due_rem aining - amount_in_dispu te) in Collections Screen (Advanced Collections). It's a weird looking form and its not like other forms.

Can I use FP to calculate the Collectable Amount at run-time and display it on the screen using one of the DFF attributes???

If yes, where should I write my logic?? Which event should i use to reflect this change on each and every record in Transactions Tab of Collections Form?

I'm not able to capute the when-new-record -instance trigger on the "Transactions" Tab. Also, I'm not able to get the values of Amount_due_rema ining and Amount_in_dispu te fields for a particular Transaction on Transactions Tab.

Please advise.

Thanks ,
Mohan.
Quote
+1 #52 anjali 2007-10-04 11:13
hi Anil
I want to retrieve a value from a stored procedure during Forms Personalization

In Action: Building and Builtin Type: Execute a Procedure, I am calling a procedure as below:


='begin
genP KG.COUNT_ALL(â €â€™|| ${item.po_ lines.desc_flex .value}||à ¢â‚¬ÂÃ¢â‚¬â„¢, ,”â€℠¢||${globa l.g_null.value& #125;”â⠂¬â„¢);
END'
i dnt know if the code is ok but im getting error from executing this statement
in fact i want to call the procedure and retrieve a value from the procedure and use it back in the form
how can i do that?
ive tried several ways but could not find any
Quote
0 #53 Harshad Poogalia 2007-10-25 12:54
Hi Anil,
I am writing an action on When-Validate-R ecord on Item Cross References form.
But When I click on save button the When-Validate-R ecord is getting triggered multiple times, thereby casuing the action (Message in this case) to occur multiple times.

Is there any way to specify that the action be performed only once ?
Quote
0 #54 Anil Passi 2007-10-25 13:02
Indeed there is, that is if you raise an form trigger failure.

That can be done using the action described below.


Thanks,
Anil Passi
Quote
+1 #55 Prashanth 2007-10-26 02:44
Is it possible makeing the DFF as read only?
How can we do it.
Quote
0 #56 Sachin Ahuja 2007-10-26 13:04
Hi Anil,

As you have shown in 2nd screen shot that we can enter upto 100 personalization . It's basically sequence should be in the range of 1-100 but we can repeat the sequence number and I guess personalization can also by this can be more than 100.

Please correct me if I am wrong.

Once again thanks for putting such a wonderfull efforts on documents all are almost near to perfection.

Ha ppy Diwali to you in Advance.

Thank s Again...!!!!

R egards
Sachin Ahuja
Quote
0 #57 Mani 2007-10-29 07:02
Hi Anil,
I want to add a new lov for an Item in satndard form.
How to do that...

Regard s,
Mani
Quote
0 #58 Sachin Ahuja 2007-10-29 13:23
Hi Mani,

I think Anil has already covered the point under section below on this page only

Can I modify SQL Query behind the LOV using Forms Personalization s?


Check if this is what you are looking for.

Regards
S achin
Quote
0 #59 Oded 2007-10-31 15:23
Hi Anil,

I have gone thru the examples you have given on forms personalization .I got a request to personalize the form and I want to use the Type = "Builtin" and Builtin Type = "Create Record Group from Query" for that form personalization which you have given as an example in the link "http://www.goo gle.com/search? q=site:apps2fus ion.com+forms-p ersonalizations ".But I could not find Bultin Type = "Create Record Group from Query". I am using 11.5.10.2 version of Oracle Apps.I checked in earlier version 11.5.8 also.But I could not find. May I know by using which version you have given that example and in which versions it is available?

Tha nks
Vinay
Quote
0 #60 Anil Passi 2007-10-31 15:28
Hi Vinay

It certainly works on CU4. This feature was added in a later release of 11.5.10, which explains why this option isn't available for CU2

Thanks,
An il Passi
Quote
0 #61 Oded 2007-10-31 16:25
Hi Anil,

CU4 is not available to download in metalink. So may I know what is the appropriate patch # to apply. I am planning to personalize the "Reason" field (which is LOV) in the form INVTTMTX.fmb in Inventory module of R11.5.10.2. I will be thankful if you can provide the exact info that we needed.Apprecia te your reply.

Thanks
Vinay
Quote
0 #62 Vivek Jain 2007-11-05 16:28
Hi Anil,

I have been through all your threads on form personalization but couldn't find solution to my problem. I want to enter Lot/Sublot/Qty through FP while receiving goods. The problem is that there can be multiple lot/sublot for the item being received. We normally scan the lot/sublot info from the item barcode and store it in a custom table. Now i want is that when i click on lot entry form it should automatically fill the lot/sublot/qty for that item in the form.

I hope entering multiple records can be done through form personalization .

TIA
Vivek
Quote
0 #63 Anil Passi 2007-11-05 16:36
Hi Vivek

You can loop through the records in the table and create multiple records.
See my response to the query raised by Joel on April 25, 2007 [in above thread]

You need to implement something similar to what is described below
docs.google.com/Doc?id=dcfd8fsc_62fdfvz9

Basically, the idea behind this approach is to force a recursive loop.
You make an exit from the recursive loop when all the cursor records have been looped through


Thank s
Anil Passi
Quote
0 #64 Ron 2007-11-09 18:52
I would like to replace a user entered value during a query function. Say the form has a varchar field and the user enters 'ABC' and when the execute query (Ctl/F11), the actual value is 'XYZ'. This hidden value is derived from a standard plsql function. Any idea?
Quote
0 #65 Vivek Jain 2007-11-12 07:36
Thanks a lot ANIL. Your solution worked.
Quote
0 #66 S.Kumar 2007-11-19 09:02
Hi Anil,

I am a new learner of Form Personalization .Today I tried to practice
some of them.I tried to get the field values in Purchasing form and
assign it as default value for another field in the form at header level.
For example Agent Name in Po Headers as Po Header Description.
It worked fine.Now I am trying to put the Promised Date in Line Level
as deafult for Need By date.I am facing some Problem.The problem is
After entering the value in Promised date the curosr is automatically moving to
Need By Date and the default value is not getting populated.If i click back in Promised date then the default value is getting populated.Pleas e suggest.Thanks for the Help.
Thanks
Sk umar
Quote
0 #67 Sachin Ahuja 2007-11-19 12:43
Hi Anil,

I have a doubt in performing FP.

I have entered the Order line. Now I'll be calling some procedure which will either return Y or N.

Based on the return value I want to set one attribute on line to this Y or N.

I want all this to happen before line is saved. So I am using FP and trigger When-Validate-R ecord with Action = Property
Object Type= Item
Target Object=LINE.ATT RIBUTE16
Proper ty Name=Value
Valu e = *************

Here I am confused how to return the value and assign it to line so that it gets saved when i save my record.

Thanks in advance for your kind help.
Quote
0 #68 Satya 2007-12-04 01:05
Anil,

When I open a catalog form from PO form, Add and Remove buttons are grayed out in the order pad. Is there any way to enable these buttons. But these buttons are enabled when I open the catalog window from Requesition form.

Please help me in this regard.


Thank s.
Quote
0 #69 Sandhya Nagarajan 2007-12-04 19:12
Hi Anil,

Is there any way we can call the inbuilt program unit(package.pr ocedure) of a standard oracle form using forms personalization ? I tried the below code for FORMS_DDL and "Execute a Sotred Procedure" builtins but went invain.
='decla re
v_event VARCHAR2(50) := 'WHEN-VALIDATE- ITEM';
begin
pr of_local.class_ profile(v_event );
end'

Do you think it could be made to work. Any help is highly appreciated.

S ayeed
Quote
0 #70 Lucie 2007-12-05 19:10
Anil,
I am a big fan of your website. Thank you so much for all of your documentation and examples.

Ques tion... I'm trying to change the visual attribute of a field, the font color using form personalization and have not been successful... Have you tried or know how or is it even possible?

Hope you can help.
Thanks
Quote
0 #71 Krishna reddy81 2007-12-10 02:23
Not able to see the images of the personalization s.
Quote
+1 #72 AN 2007-12-14 18:55
Hi Anil,

Your website helped me a lot in creating an LOV using Forms Personalization . I am struck up with a problem and I need your advice on this if I am missing some thing. I am using Forms Personalization to create an LOV using builtin. In the Builtin, I have put the sql query under create record group from query. In the query, when I hardcode a value, in a where condition, the LOV works fine but when I replace the hardcoded value with :block.field value, it gives the error, FRM-40502: ORACLE error: unable to read list of values. Below is the part of the sql query where I am facing this issue.
"WHERE related_custome r_id = :ORDER.INVOICE_ TO_CUSTOMER_ID"
Please get back to me if you have faced with this kind of problem.

Thanks all in advance,

Regards,
AN
Quote
0 #73 Wolfie 2007-12-17 09:29
Hi,

How can i use a procedure, that returns boolean value, in persinalization condition field?
Thanks.
-- Wolfie
Quote
0 #74 Gord 2007-12-21 22:36
Hello; I'm trying to order contact names (vendor site form; contact tab) so that inactive contacts are listed at the bottom and active contacts are at the top.
Using the Target Object: CONTACTS I used the Property Name: ORDER_BY and Value: INACTIVE_DATE DESC but this didn't work. Any suggestions?
Th anks in advance.
Gord
Quote
0 #75 Aravind Gorthy 2007-12-28 14:35
Hi Anil,
I have a requirement in Order Management - Shipping Transactions - in which I need to default the Ship Confirm Rule with a new value based on the responsibility the user gets into. But the Document Set is also attached with this rule and based on this rule the document set should change. When I am trying to do it I dont any errors but dont get even the value populated. I tried using the When new item instance and when new block instance by trying to put forth all the possible conditions in defaulting it to some value. I logged in re-logged in and tried several times but no value is appearing. If I try to restrict it with some particular value for the DLVY_SHIP_CONFI RM_RULE_NAME then I find the app hangs out with some wierd errors. Could you please help me out in putting this straight.

Thanks
Aravin d
Quote
0 #76 Vivek Jain 2007-12-28 17:11
Hi anil,

In purchase order lines, i have a DFF with value set as yes/no. What i want is that if there are n lines(records) then only one of them has DFF value as yes and rest of the lines should have value no. I tried using when-validate-r ecord instance but it validates only for the current record and does not compare t with other records. Is there any way we can do it through form personalization

Regards,
Vive k
Quote
0 #77 V V Bhargav 2008-01-05 07:18
Hi Anil,

I am trying to do a forms personalization , for AP (Invoice Batches - Distributions)

The personalization is done for the activity when the user enters invoice through invoice batches, and enters distribution info for each invoice line. and now when the user selects a code combination in the account field it is verified from the account code segment (as to whether it is not a liability account). Now i have restricted the user to move ahead or back in the form, and have also shown him an error message through personalization . But ironically if the user just presses the OK button of the message box, he can still save the record. I dont want the users to save the record after entering restricted account codes
Quote
0 #78 Anil Passi 2008-01-05 07:30
Hi VV Bharghav
You need to raise form trigger failure.
Please see a comment above posted on October 25, 2007

Thanks
An il Passi
Quote
0 #79 V V Bhargav 2008-01-05 08:51
Hi Anil,

I agree for raising the form trigger failure. But the distributions window has many lines. so suppose if didnt have that personalization and the user had entered some few correct lines and some few wrong codes in some lines. how to stop the user from saving.. that is if i put the code in when-validate-r ecord... the trigger will only verify the latest record... will the trigger get fired for all lines in the block.

Please help.

Thanks and regards,
Quote
0 #80 Anil Passi 2008-01-05 09:07
Hi Bhargav

WHEN-V ALIDATE-RECORD will fire for each record that gets modified. Hence when you raise exception, user will not be allowed to proceed to next record

Thanks
Anil
Quote
0 #81 V V Bhargav 2008-01-05 09:51
Thanks a ton dude.

Thanks once again.. it worked.. i had different ideas about when-validate-r ecord.

And by the way i have the same kind of issue but its a bit varied..

like i have done one more personalization in Order management (Sales Orders) form. When you enter the line items for a sales order.. the requirement was that we need to disable the DFF when the user selects an item of the same company but different organization ID.. so when i disable the DFF for the first line with personalization .. and if the user again selects a valid item in the next line.. then the dff which was disabled in the previous line(s) gets enabled again :(

how to beat that...!!!

Tha nks and regards,

V. V. Bhargav
Quote
0 #82 Santhosh ND 2008-01-05 12:52
Dear Anil,
I have a basic doubt in Form Personalization .
Level - Function
Trigge r Event - WHEN_VALIDATE_R ECORD
Trigger Object - ASSIGNMENT
cond ition - 1=TRIDENT_UNIQU E_POSITION(:ASS IGNMENT.POSITIO N_ID)
Processin g Mode- Not in Enter-Query Mode
Level - Site
in Action Type - Message
Message Type - Error
Message - You have entered a Position Flexfield combination which is already assigned to an employee. Please choose an unassigned Position Flexfield combination.

H ere TRIDENT_UNIQUE_ POSITION is a function
CREATE OR REPLACE FUNCTION TRIDENT_UNIQUE_ POSITION(p_pos_id in NUMBER) RETURN NUMBER
IS

l_co unt NUMBER:= 0;
BEGIN

SELECT COUNT(*)
INTO l_count
FROM per_all_assignm ents_f
WHERE position_id = p_pos_id;

IF l_count >0 THEN

RETURN( 1);
ELSE
RETURN(0);
END IF;
EXCEPTION
WHEN OTHERS THEN
return (9);
END;
/

He re the error message is coming always ie. whenever the record is querying from db also.
Could u pls suggest one solution to prevent the error message whenever the record is querying.

Than ks
Santhosh
Quote
0 #83 Madhubala 2008-01-13 11:11
Dear Anil,
I have 1 requirement in FP.. I have enable a DFF in Purchase Requisition form at header level.Also 1 DFF with the same name in PO at header level.My requirement is when going thru Autocreate , the value entered in the requisition form should come default in the PO form when using Autocreate. How to do this?
Quote
0 #84 Maneesha M 2008-01-18 03:14
Hi Anil,
It woud be great if you can help me with this. I'm a beginer in Oracle froms.

I've used when-validate-i tem trigger to validate the item field there by calling a procedure in it. The procedure is validating and when failed raising an exception which is gettign captured as folows.
begin
if then
EXCEPTION
WHEN error_location THEN
message('Invali d carton for this transaction, please check carton location.');
raise form_trigger_fa ilure;
end if;
Exception
WHEN error_pick_rele ased THEN
message('Order is already Pick Released');
raise form_trigger_fa ilure;
.
.
this is the proc which is gettign called in when-validate-i tem trigger
as
begin
if then

validate_cc; --Proc given above

end if;
exception
when others then
raise form_trigger_fa ilure;
end;

in the form when the validation fails I do see the error message 'Order is already Pick Released' thrice. The trigger is getting fired thrice. When the validation fails the control it movign back tot eh same field and it gets fired again i guess..How can I overcome this.

thanks
MAnu
Quote
0 #85 Joel 2008-02-05 10:39
Good morning Anil,
Would you be able to show me how to disable the attachment icon in the Supplier form using form Personalization ?. I need to make unavailable for a group of users.

Best regards,
Joel Asselin
Quote
0 #86 NARSIMHULU SANIKA 2008-02-07 15:07
Hi Anil

I need to call a pocedure with out parameter using forms personalization and based on the value of the out parameter need to do some more validations.
Ca n you tell me how this can be done?
or do we have to use custom.pll only??

Thanks & Regards
Silpa
Quote
0 #87 Sanjay Bhatia 2008-02-13 20:58
Hi Anil,
Is it possible to add Sub Menu's under the Tools Menu using Forms Personalization . For eg under Tools if I have Menu 1, can I have Sub Menu 1, Sub Menu 2 etc under Menu1.
Thanks

Sanjay
Quote
0 #88 Ravi Nuka 2008-02-15 17:07
Hi Anil,
I want to fire a form block level trigger when the user clicks on one of the menu item which is a standard menu item but not custom menu item. I am able to add a new menu item which is custom menu item and fire the trigger when the new custom menu item is clicked but im unable to fire the trigger when it is for standard menu item ( for me its "Actions" menu item in the form). How can I handle this through personalization .
Quote
0 #89 kris 2008-02-28 09:58
Hi.

Is it possible to update a key flexfield definition through personalization (like with custom.pll)?
I would only need to update the where_clause:
FND_KEY_FLEX.U PDATE_DEFINITIO N(
BLOCK => 'BLOCK_NAME',
FIELD => 'FIELD_NAME',
ENABLED => 'N',
WHERE_CLAUSE => '1=1'
);

I searched, but found nothing i could use.

Keep the good work.
Kind Regards,
Kristj an
Quote
0 #90 aaron 2008-03-05 07:40
Hi Anil,
one of my requirement is to hide the location field in the oracle internet expenses page(the screen user uses to enter their expenses). Is it possible to achieve it using forms personalization ?

i hope you will help me

Thanks for your help.

Regards
Jason
Quote
0 #91 Anil Passi 2008-03-05 18:51
Jason

For Internet Expenses, you need to use OA Framework personalization s.
Forms Personalization is not applicable in this case

Thanks
An il
Quote
0 #92 SNEED Philippe 2008-04-14 02:03
hi anil,
This Forms Personalization Presentation is really helpful .could you help me how to get the return value of an Stored procedure or Function. and on the basis of return value i want to perfom certain action like prompting a message
Quote
0 #93 Anil Passi- 2008-04-26 18:46
Hi Premal

I haven't really tried that.

But surely, in that pl/sql procedure/funct ion, you can set a pl/sql package session variable.
Next, in FP, you can create another personalization , which has a where clause depending upon that pl/sql package session variable.
Needl ess to say, you will define a function in package that returns the value of package variable.

Form s uses one single session, hence package variable values will be retained between different trigger calls

Cheers
A nil
Quote
0 #94 Mahesh 2008-05-08 15:18
Hi Anil, I am new to oracle apps and would appreciate any response from you.

I have a customization to do in Oracle Projects and I am not sure if I can go with forms personalization . While creating projects the users are now entering all the attributes of location (like area, district etc), what they want to do is, to enter a location and the information related to location(area, district etc) should be sent to projects instead of them entering the data. The area, district are the fields in the same form. Can I put the condition as location not null and in the action Value 'select district from *** where location=locati on_value?. Would appreciate your help
Quote
0 #95 Anil Passi- 2008-05-08 18:48
Hi Sharmila

You can achieve that by altering the query of the record group.
THere is example to achieve the same in this article, just seafrch on record group on thihs page

Thanks
An il Passi
Quote
0 #96 adi 2008-06-02 09:13
Hi,
I am new in FP and I have a questions regarding FP. I want to do this: in a Purchase Order, when I enter an item, the default price should be populate with the minimum price that I bought that item or 0. Can i do that using Form Personalization ?

Thanks
Adi
Quote
0 #97 Melchor 2008-06-25 17:38
hi
i need help,
i need make a personalization to Sales order form, I have a sales order but i need validate an item when user press the book-order button,


any suggestion?
tkn s
Quote
0 #98 Anil Passi 2008-06-25 17:40
Hi Melchor

I suggest you use WHEN-VALIDATE-R ECORD

If that is not suitable, then find out the trigger that fires using show custom event in help diagnostics menu.

Have a look at this article apps2fusion.com/apps/apps/21-technical/144-custompll
Thanks,
Anil Passi
Quote
0 #99 Melchor 2008-06-25 18:01
Hi Anil Passi,
I try WHEN-VALIDATE-R ECORD, :( but the user want save order sales without validate this item, and when press the button validate the item.



sorry i no speak and write english good :)
Quote
0 #100 Anil Passi 2008-06-25 18:27
If that trigger is not being passed to FP or CUSTOM.pll, then your options are limited.

I suggest you read this link fully to get insight
apps2fusion.com/apps/apps/21-technical/144-custompll

Thanks,
Anil
Quote
0 #101 Mahesh 2008-08-11 16:57
Hi Anil,

Can we use SQL to give value to an item, just like using SQL for message text?

Thanks,
Sharmila
Quote
0 #102 Anil Passi 2008-08-11 17:07
Hi Sharmila

Sure you can use syntax as shown below, to default value into a field from result of a SQL Statement.
The syntax is exactly the same as that of SQL used in displaying message text.

Quote:
= select fnd_global.user_name from dual




Will be great if you post future queries on apps2fusion.com/forums/

Thanks,
Anil Passi
Quote
0 #103 Richard D. Chisnick 2008-10-03 14:23
Hello Anil,

Somethin g strange is happening in apps when I work with a custom form. So far, none of my teammates have had any ideas, so of course I turn to you :) By the way, this is not directly related to personalization s - I just wasn't sure where else I could post this.

When I have a custom form open, I may want to look at some properties of the form. So I go to Help -> Diagnostics -> Properties -> Item. When the properties window opens, it takes the exact shape of the custom form (i.e., its height and width). This can become a hassle for the user, since parts of the properties form can be cut off by the dimensions of the custom form (for example, items below the Object 1 and Object 2 drop downs may not be visible). Some kind of inheritance is occurring and I'm hoping to stop it from happening.

If you have encountered this issue, could you tell me how I can stop it from happening?

Reg ards,

Rick
Quote
0 #104 Ashish 2008-10-08 07:04
hi Anil Passi,
For few days I am experimenting on Forms Personalization . My requirement is in AP, for a particular Responsibility, Invoices Form should only display few invoices, the display criteria is Context (ATTRIBUTE_CATE GORY) field which is configured for DFF. If this field contains some specific char, say 'CAPS' then only display those invoices.
For this I have setup a Profile option called, 'TEST_CAPS' and attached it to a responsibility.
I am trying to compare this in the form personalization . Things I am doing are:
In Action tab Object Type: Block
Target Object: INV_SUM_FOLDER
Property Name: Default_WHERE
I n Values I want to compare the above mentioned profile ($PROFILES$ .TEST_CAPS) to attribute_categ ory.
But since I am not aware of SPEL I am finding it difficult to retrieve this profile value.
I tried: =${$PROFILES$.T EST_CAPS} but it is giving me an error.
For testing I have directly compared VENDOR_NAME to a existing VENDOR and form is displaying only that vendors invoices.
But when I am trying to compare it to profile value somehow I am not able to get the profile value to compare. I am not sure on how to extract data from profile in the SPEL (for form personalization )
I have confirmed that value is coming in the profile value, as I have used it in defining a VALUE SET, and it is getting reflected in it.

it would be great if you could help me in finding a solution for this issue
Many thanks
Ashish
Quote
0 #105 Anil Passi 2008-10-08 07:08
Hi Ashish

You can simply make your personalization s applicable to a specific set of Responsibilitie s.
Hence you do not need a profile option in the first place

Thanks
A nil Passi
Quote
0 #106 Ashish 2008-10-10 01:55
Hi Anil Passi,
Thanks for the response. i am sorry that i missed one more point that, those invoices should not be visible for other Responsibilitie s. For this reason I have used profile and used DECODE statement to verify the profile value.
I am new to personalization so I am not sure if this can be done, it will be great help if you could help me on this.
More over it will be great if you could tell me how to retrieve Profile value using SPEL in Personalization . It will help me in future!!!!

Tha nks for your prompt response.
Ashis h
Quote
0 #107 Vishal_h 2008-11-12 06:29
Hi Anil,

My requirement is that every time a value is entered in ordered_quantit y column in Order lines, it should get validated against MIN_MINMAX_QUAN TITY column from mtl_system_item s_b table for that item. If the user enters line quantity as 5, whereas the minimum quantity defined in MIN_MINMAX_QUAN TITY column for the item is 10, the value should get changed to 10. Please let me know how this is possible. If possible, please mention steps for the same in personalization as I am new to it.

Thanks,

V ishal
Quote
0 #108 ZIA 2008-12-01 05:27
Dear Anil,

I tried what you suggested in the previous posting like I want to pass user_id to FND_REQUEST.SUB MIT_REQUEST as $PROFILES$.USER _ID.value but it didn't work.
Now I am going for a different approach. I have written another procedure an called FND_REQUEST.SUB MIT_REQUEST in it and call that procedure from Form Personalization and hardcoded the user id.

The question is how can I pass a literal argument to my proceudre in form personalization which in turn calls FND_REQUEST.SUB MIT_REQUEST.
I am calling the procedure in Form personalization as follows:
= 'declare
v_field_value NUMBER;
begin
XX_SUBMIT_JOURN AL_REPORT('''|| ${item.HEADER.B ATCH_NAME.value }||''');
end'

My database procedure XX_SUBMIT_JOURN AL_REPORT calls FND_REQUEST.SUB MIT_REQUEST as follows:

request_id := fnd_request.sub mit_request(app lication => 'SQLGL'
, program => 'GLGENJRN2'
, description => NULL
,start_tim e => NULL
,sub_reque st => FALSE
, argument1 => 1061
, argument2 => 'L'
, argument3 => 'U'
, argument4 => 'USD'
, argument5 => 1
, argument6 => NULL
, argument7 => NULL
, argument8 => NULL
, argument9 => NULL
, argument10 => B_NAME
, argument11 => 180
);


How can I achive this objective?
Quote
0 #109 Bala 2008-12-09 10:52
Hi,
I have defined a local variable called XXPA_USED_BY_MS G
I populate it and later I want to show it in a message. However - I cannot figure out how to reference it.
If it was a global variable I could use =:GLOBAL.XXPA_U SED_BY_MSG, which works.
I tried =:LOCAL.XXPA_US ED_BY_MSG as well as =${VAR.XXPA_USE D_BY_MSG} and many other combinations, without any luck.

Any ideas?

Best regards, Søren Moss
Quote
0 #110 NM 2009-01-04 00:03
Hi,
I have a requirement. In the MO form I need to pop up the DFF screen as soon as the MO form in opened. I tried using Go-Item, but it does not work for DFF fields. So how do i achieve this

Thanks in Advance
Quote
0 #111 lakshminath 2009-02-09 04:10
Hi Anil,
I have to do form personalization in iprocure modules.
while creating requisition in iprocure modules.
if user did not change account from ZZZZ when he is going to approve or save this requisition we need display a pop up message as
"please enter account number "


could you please help me to complete this task.

Regards
Lakshmi
Quote
0 #112 Manisha 2009-04-22 01:11
hi...cn some1 plz help me....i need to run a custom report thru FP and store its output in document of records....well i cud solve the part of running the report..but m absolutely clueless as to how to store its output automatically in the document of records using FP....plz help..thnx in advance
Quote
0 #113 Ellen 2009-05-15 06:58
Hi,

I'm trying to customize a LOV (when searching voor vendors while creating an invoice). I want to add a item in displayed field.
I thougt i could modify the sql query behind the LOV.
How can i do that??


Thanks .
Quote
0 #114 Ninan Issac 2009-05-18 12:14
Anil,

Thanks a lot for sharing your knowledge with others thru your columns.

Can you please tell me whether we can change the Window Title in APPS Form thru Forms personalization .

Ninan
Quote
0 #115 pooja 2009-07-29 05:24
Hi Anil,

I'm need the entire PNTLEASE form as read only except for the notes block. I'm tried creating a new function for the same form
with parameter as QUERY_ONLY ="YES". But still some of the blocks in the form is updatabe. Can you please help me resolve this.

Thanks
P ooja
Quote
0 #116 Syed.l 2009-11-10 05:49
Hi,

Its urgent. My custom module is going UAT within 2 days. I have one requirement pending. I need to display and change Keyflexfield Segments value Dynamically. For Example.
I have one field on First Form in that we are having the value in Tree Structure. After Saving the Data the value is showing in this field is like "A.B.C". Now if i press Button it
should open Second Form and we have one field in the Second form call Category Code if i click on that field LOV it should display only 3 segments call A.B.C. If i have A.B.C.D
value in First Form Field it should Display 4 Segments call A.B.C.D in second Form. Please give me some idea to work on this field.


Thanks and Regards,
Quote
0 #117 PhaniReddy chittiolu 2009-11-11 07:04
hi,
Hope every thing is good at ur end.
Can you please guide me how we can add a new column to the existing form and want to show DFF attrubute in that column.

Apprec iate your early response.

thanks,
Phani Reddy
Quote
0 #118 Fiona Gallagher 2009-11-27 12:07
Hi

this is a superb site, thank you.
Do you know if its possible to use personalisation to set the LOV for grouping in autocreate form to 'Requisition' instead of Default.
I know there is a profie option but it won't be working until release 12 and we're on 11.5.10.2.
I need a solution to get grouping to automatically be requisition.
th anks
Fiona
Quote
0 #119 wasim 2009-12-15 20:43
Hi

I want to submit a concurrent request in my personalization form and it has to view or print directly from there.

I need a solution

Thanks
Wasim
Quote
0 #120 CGS 2011-01-19 15:32
Hi Anil,

To make the “Destination subinventory” field on PO form Distribution block a required field

I want to make the “Destination subinventory” field (PO_DISTRIBUTIO NS.DESTINATION_ SUBINVENTORY) mandatory on PO form Distribution block (PO_DISTRIBUTIO NS).
I tried on the following things.
1. Property : Item-->PO_DI STRIBUTIONS.DES TINATION_SUBINV ENTORY-->REQ UIRED
2. Property : Item-->PO_DI STRIBUTIONS.DES TINATION_SUBINV ENTORY-->REQ UIRED (APPLICATIONS COVER)

The fields seems to be made mandatory(colou r turned YELLOW). But, system allow me to save and Approve the PO without providing a value to this field. If I click on the “Destination subinventory” field at PO form Distribution and then try to save the PO without providing a value, system is displaying a message that the field is mandatory. Could you please help me to make me fix this so that the system will not allow the user to save and Approve the PO without providing a value to this field?

Thank you very much in advance.

Thank s
Shankar
Quote
0 #121 Ericqo 2011-03-15 15:56
I am working on restricting the number of characters on the sales order form and placed the condition below but I am getting the error "invalid relational operator". I am quite new to forms personalization so any assistance is greatly appreciated.

if length (:order.cust_po _number ) > 5 then
raise_applicat ion_error (20101, 'Exceeded length of column')
end if;
Quote
0 #122 Manisha 2011-04-07 17:26
Hi Anil,

I want to know if there is any way where we can restrict the values seen in the LOV of additional lines DFF based on order status.
For example what I am trying to acheive is:

In DFF we have a column Event Name. This comes from a value set based on table and where condition as event status = ACTIVE.
We will end date ( status = CLOSED) for the events whose order status = closed

So the issue is when we try to query the closed orders, we have this error pop up "Flexfield Event doesnt exit in the value set.."
This is so becaue we are pulling in the ACTIVE events only.

Now I need to get rid of this error. But I do not want to show up closed events when a new SO is entered.
Can I have a way to hide these closed events in LOV or can i personalise the form to be able to show only ACTIVE for new record entry and all events for closed orders..

Pleas e suggest on this.
Thanks in advance.

Thank s,
Manisha
Quote
0 #123 ajays 2012-11-03 01:52
AR Collection user>Collection s>collections>a ging tab>transaction s button

After transaction page is opened ,when i right click .View notes item is disabled.
Requi rement:I need the view notes to be enabled when the type is payment.
Can it be done using form personalization ?
If not in what way i can get the solution.
Pleas e help.
Thank you.
Quote
0 #124 Naveen Venkatachalam 2012-12-04 03:39
Hi Anil,

The document link which you provided to Vivek on the above thread and the answer you provided to Joel is required for the form personalization which I am doing. The link is throwing an error. Requesting you to post the current link.

Thanks,
Naveen
Quote
0 #125 J 2013-10-31 15:07
Hi there...I originally came across this document on your first site (anilpassi.com) . They didn't appear there either, but I thought it was due to you moving things to the new site, however I see they don't appear here either...can you please fix? :) (147-forms-pers onalization)

T hank you!!!
Janel
Quote
0 #126 Pranav 2014-05-02 16:51
Hello

Thanks for giving step by step instruction but i could not see the screen you pested on this page.

I have one question.

i have assigned new record group to existing LOV in AR adjustment screen. now i would like to dynamicaly change LOV result by user entered value in one of the field.

i.e, i would like to show only specific Adjustment reson code based on Adjustment activity user entered.


I tried to use ${item.adj_adju st.activity_nam e.value} in create recored group query but validation giving error.

does oracle have any limitation ?

your response will be appriciated.

thanks
Pranav
Quote
0 #127 Ganesh Lakade 2014-09-01 15:15
Hello Anil,

When I am calling "go_record()" inside a plsql code which is called using Built in "Execute a Procedure" under forms personalization , I am getting error "Identifier GO_RECORD must be declared."

Similar error is coming for GET_GROUP_NUMBE R_CELL and also giving error for datatype GROUPCOLUMN.

Can you please help

Regards,

Ganesh
Quote
0 #128 Swapnil Kashid 2014-11-21 10:20
Hi Anil,

We have a requirement to create a DFF on PO Lines Form .

Could you please suggest.

Regards,
Swapnil Kashid
Quote
0 #129 Suman 2014-12-15 16:16
Hi Anil,

I need to personalize AutoCreate form in such a way that background color should change to green for the requisitions belonging to given supplier name.

I am able to change the bg color but its not working when providing supplier name condition and also color is getting changed for all the rows.
Could you please suggest on this..

Thanks,
Suman
Quote
0 #130 Swapnil Kashid 2014-12-16 07:15
Hi Anil,

I went through our website and found it extremely useful , the way Functional and technical concepts are being explained in detailed manner.

Could you please provide a solution for below requirement.

* We have to prohibit updation of Recoverable Flag in Tax Form inside Receipts Form.

We have made the below personalization :

The field name is Modvat Flag

Object Type : Item
Target Object : JA_IN_TAX.MODVAT_FLAG
Property Name: ENABLED
Value: FALSE

The above personalization gives an error saying that cannot set Insert Allowed Property of a Disabled Item.

Could you please help.

Regards,
Swapnil Kashid
Quote
0 #131 Swapnil Kashid 2014-12-17 11:17
Hi Anil,

I went through our website and found it extremely useful , the way Functional and technical concepts are being explained in detailed manner.

Could you please provide a solution for below requirement.

* We have to prohibit updation of Recoverable Flag in Tax Form inside Receipts Form.

We have made the below personalization :

The field name is Modvat Flag

Object Type : Item
Target Object : JA_IN_TAX.MODVAT_FLAG
Property Name: ENABLED
Value: FALSE

The above personalization gives an error saying that cannot set Insert Allowed Property of a Disabled Item.

Could you please help.

Regards,
Swapnil Kashid
Quote
0 #132 Kumar_1988 2015-07-06 10:24
Hi Anil,

I have a requirement. in the form header there is an DFF which is displaying the list of values from the value set. How to change the list of values in run time..
Is it possible in Form personalization?

Please let me know.

Thanks & Regards
Kumar.
Quote
0 #133 ush 2015-08-22 18:20
Quoting Joel:
Hi Anil, I too have an Oracle Apps blog and I was wondering if you can help me with a requirement from one of the readers on my blog. His requirement is that he wishes that when querying a SO in the Sales Order form, the ITEM_DESCRIPTION_MIR value of the SO line would populate automatically to the USER_ITEM_DESCRIPTION field if NULL, and this needs to be done for all lines, if there are many lines on the SO. Here what he has done so far: CONDITION: Trigger Event: When-New-Item-instance Trigger Object: LINE.USER_ITEM_DESCRIPTION CONDITION: :LINE.USER_ITEM_DESCRIPTION is NULL ACTIONS TAB: Seq 10 Property Object Type: Item Target Object: LINE.USER_ITEM_DESCRIPTION PROPERTY NAME: VALUE VALUE: =${item.line.item_description_mir.value} (This works but it requires the user to click on the USER_ITEM_DESCRIPTION field of each line for the value to populate automatically. What is he missing in order for all lines to populate the value from ITEM_DESCRIPTION_MIR to USER_ITEM_DESCRIPTION)? The requirement is : When querying a Sale Order, click on the Line tab, they want the system to automatically populate, for all lines, the ITEM_DESCRIPTION_MIR field value to USER_ITEM_DESCRIPTION field thru Forms Personalization. Any help would be appreciated... Regards, Joel Asselin


please answet theabove query...
Quote

Add comment


Security code
Refresh

Search Trainings

Fully verifiable testimonials

Apps2Fusion - Event List

<<  Aug 2021  >>
 Mon  Tue  Wed  Thu  Fri  Sat  Sun 
        1
  2  3  4  5  6  7  8
  9101112131415
16171819202122
23242526272829
3031     

Enquire For Training

Fusion Training Packages

Get Email Updates


Powered by Google FeedBurner