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: 4 / 5

Star ActiveStar ActiveStar ActiveStar ActiveStar Inactive
 

When it comes to doing forms personalizations in Oracle's eBusiness Suite, it is good to follow certain guidelines.

We all know that forms personalization create a layer of customization on top of the standard Apps D2K Forms.
The Metadata related to forms personalizations is stored in tables FND Tables.

Please find a list of guidelines can be regarded as the best practices when it comes to doing forms personalizations in Oracle Apps.

 

 

 

In case you wish to see different examples of forms personalizations, then please visit link following links

  1. Various examples on Oracle Forms Personalizations

  2. An example for implementation of Oracle Forms Personalizations in HRMS

  3. Comparison between CUSTOM.pll and Forms Personalization in Oracle

 

Anyway, lets have a look through some of the best practices.

If you can add to the list, then feel free to do so by adding that in comment section of this article.



Global Variable Names

All the global variables defined must begin with XX.

This will ensure there is no conflict with global variables that are defined by Oracle’s development team.













FNDLOAD

You must always use FNDLOAD to transfer Forms Personalizations from one environment to another.

However see below point too, which is very relevant to FNDLOAD



Decide a master environment

Decide a master environment onto which all the forms personalization will be entered prior to scripting & patching those personalization using FNDLOAD.

If "Functional Team" makes changes to TST Environment and then the "Development Team" makes changes to DEV Environment for the same form, then, changes done to TST Environment will be lost when FNDLOAD extract from DEV is uploaded onto TST.

Usually developers make their personalization changes to DEV environment, Functional team makes their changes to TEST/UAT environments and Support team sometimes tends to make their FNDLOAD changes straight into production[ I mean without using FNDLOAD]. This is a bad practice. Do not make any Forms Personalization changes manually onto production.

Decide an environment onto which developers, functional personnel & support staff will manually key in their personalization.

Use this as a master environment to download the Forms Personalizations using FNDLOAD.




Tools Menu

To create new Tool Menus, always use MENU1-MENU15, as Oracle guarantees never to use these during development. Same is not true for SPECIAL Menus, as Oracle development may release a patch utilising the same SPECIALx as you may have personalized. MENU1..15 is available starting from 11.5.10 CU2 onwards[I think]




Remember the sequence

Keep in mind that “Forms Personalization” code fires prior to CUSTOM.pll code [in case you have the same form extended in both the places].




Use local variables when its usage is restricted to one single form

If a variable scope is limited to single form which is being personalized, then do not unnecessarily create a GLOBAL Variable.




Clear Global Variables once they have been used

Use global variables when you wish to integrate two different screens using Forms Personalizations. In other words global variable act like a bridge between two forms [of course apart from parameters]

Make sure you clear off the GLOBAL Variables after their usage is finished. This will ensure that screen works under normal scenarios too.




Before reporting a bug/SR in Forms via Metalink, reproduce the issue by disabling customizations

The Forms Personalizations can be disabled by turning the custom code off.

Before reporting any form related bug to Oracle, try reproducing the issue by turning Custom Code off





Identify the best possible triggers to use for personalizations

See this link that explains how to recognise the best trigger to trap for forms personalization.

Both forms personalization and CUSTOM.pll are fed the same set of triggers in Forms.




That’s all that I can think off. If you wish to share your experience of best practices, then please feel to add your experience in the comment section.


Anil Passi

Comments   

0 #1 santhosh 2007-10-25 09:52
Hi Anil,
I have a doubt in Personalisation .

I am currently doing the payment extract interface program for the bank. The point here is that the bank doesn't allow some characters which are considered as special characters like (#,$,%,^,*,&) etc..In most of the information like vendor name and invoice numbers they are using these characters.

In my interface program, i am removing this special characters and replacing it with space or ' ' symbol as prescribed by bank through translate command.
transl ate(VENDOR_NAME ,'/!;"{ 25;[]|=_*&^%$@~ #',' ')

But i am planning to restrict them at the form level itself.
I tried using Personalisation with the condition.
:VND R.VENDOR_NAME_M IR != translate(:VNDR .VENDOR_NAME_MI R,'/!;"{&# 125;[]|=_*&^%$@ ~#',' ')
In the Actions, I have given a message of type 'Error' and it is also firing.

My question is
Is there any possibility of giving

RAISE_F ORM_TRIGGER_FAI LURE OR
RAISE_APPLIC ATION_ERROR unless and until they delete/remove the special characters?

Pl ease help me on this.

Regards
Santhosh
Quote
0 #2 Anil Passi 2007-10-25 10:01
Hi Santosh

Sure, you can raise the exception, such that users are forced to rectify the issue.
Use the Action of type Builtin, with BuiltIntype RAISE FORM_TRIGGER_FAILURE


Thanks,
Anil Passi
Quote
0 #3 santhosh 2007-10-25 13:25
Thanks Anil...
Quote
0 #4 Oded 2007-10-31 14:58
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 #5 Anjana Menon 2007-11-09 14:50
Hi Anil,

How can I Enable/Disable Dff for a specific responsibility using Forms Personalization .

Thank You
Anjana
Quote
0 #6 Sravan 2007-11-19 09:47
Can we add button to Apps screen through Forms Personalization ????
Thx
Quote
0 #7 Shashank P 2007-11-26 11:04
hi anil,
its great job. moreover i am looking for job in Oracleapps technical consultant.
so can u guide to prepare myselfe as same
Quote
0 #8 Arunakumari.v 2008-02-26 11:46
how can i populate a message based on a condition in the form using forms personalization
Quote
0 #9 Ashwini 2008-05-09 16:01
hi Anil

I have a requirement to call a custom form from the Standard Requisitions form in Purchasing responsibility on clicking of the Approve Button using Form Personalization .
I'm trying to display all the distribution information on the custom form using the requisition_lin e_id from the standard Requisition form.
In the Standard Form on the Approve Button trigger I have written a Form Personalization builtin to launch the function. Here the function will be my custom function.
In the custom form, I have created a parameter like xx_requisition_lin e_id. The standard form is calling the custom form but not executing the query for the passed parameter value requisition_lin e_id.

Please help me out.

Thanks
Ashwini
Quote
0 #10 Anil Passi- 2008-05-09 20:56
Just passing the parameter may not be enough.
Perhaps you need to execute the query
In FP, you can use built in of type DO_KEY('EXECUTE _QUERY')

Thank s,
Anil Passi
Quote
0 #11 Ashwini 2008-05-12 11:56
Hi Anil

I tried using DO_KEY('EXECUTE _QUERY') in the FP but parameter value is not retrieving in the called form.

In the Standard Calling form FP I have done:
Conditions Tab
Trigger Event: When-New-Record -Instance
Trigg er Object: PO_APPROVE
Acti ons Tab
Builtins: Seq:1 Launch a Function , Function_code: custom function name , Function_name: custom function name, Parameters: ${item.lines.re quisition_line_ id.value}
Built ins: Seq:2 Builtin:DO_KEY('EXECUTE _QUERY')

When I validate the seq 1 builtin it shows me the right requisition_lin e_id.


In the called Form(Custom Form)
I have created a parameter in the Function Creation form as :REQUISITION_LI NE_ID

But the parameter which is fetched the value from FP in the standard form is not getting passed to the called form.

Please help me out.

Many Thanks in advance
Ashwini
Quote
0 #12 Ashwini 2008-05-12 17:25
Thanks a lot Anil for your input.....
It works now....
Quote
0 #13 Anil Passi 2008-05-12 17:39
Great Ashwini
Quote
0 #14 sonu 2008-06-17 01:46
I have done one personalization in assignment form making payroll field mandatory,now my client want that payroll filed should be mandatory only for those people who are joing newly. And previos employees they dont want persoalization, ,,, is there any specific function thru which we can solve this if yes then plz tell me the solutons.
its vey urgent
Regards
sauah srivastava
Quote
0 #15 Anil Passi- 2008-06-17 02:33
Hi Sauah

Not sure what you mean by "joining newly"?
What is the business logic for that? You can certainly add a Where condition in FP before the Payroll field is made mandatory.

Tha nks,
Anil
Quote
0 #16 sonu 2008-06-17 03:58
Newly join means suppose few employes data are already there in the instance now my client ask me to made that payoll fied mandatory,and they mention that this mandatory field should effect when we enter new employe not for the already enterd people.can you tell me the code and where to add the where clause and and if u can tell me step wise that in personalization form what i have to select ....plz giuide me with the proper steps.
thanks and regards
saurabh srivastava
Quote
0 #17 sonu 2008-06-25 06:07
HI, can i add my pstings in this blog , if yes ten tell me the procedure.Even I want to contribute some of my knowledge in his blog .
rgds
saurabh
Quote
0 #18 Anil Passi 2008-06-25 06:11
Hi Sonu

This is a training portal, not a blog :)

Anyway, jokes apart, thanks for coming forward to contribute. I have emailed you the details.
Will register you as an author after your first article.

Cheer s
Anil
Quote
0 #19 Monique 2008-06-25 13:43
Hi!
I really need your help!
I need to disable the tabs on the Invoices Form, i already disabled 2 tabs (Holds and payments) but i can't disable Scheduled Payments and Prepayments tab (i get an error related to Tab Id) :(
What am i doing wrong?
Regards,
Quote
0 #20 Hernán 2008-07-14 18:19
Hi Anil, I need to disable a DFF with a form personalization and as far as I could research it's not possible as it is a form personalization limitation. Is it correct? I don't need to change any value, just make the UPDATE_ALLOWED/ INSERT_ALLOWED/ ENABLED/DISABLE D or ENTERABLE= FALSE. Up to now, they didn't work.

Please let me know your comments.

Than k you

Hernán
Quote
0 #21 Anil Passi 2008-07-14 18:29
Hi Hernan

You can't do that via forms personalization

Thanks
Anil
Quote
0 #22 Hernán 2008-07-16 11:20
Hi Anil, in the previous post you mentioned that it was not possible to disable a dff with a form personalization . How could I do this? I don't have access to Custom PLL so I'm looking for another option and I couln't find anything yet.

I will really appreciate your help on this as it is an urgent issue.

Thank you again.

Hernán
Quote
0 #23 Anil Passi 2008-07-16 11:37
OK, there is a way of doing this, but I am assuming you want entire DFF to be inactivated under some condition.


1. Set the entire block non-updatable as soon as user navigates to DFF Field
Most likely this will be called DF.
Use Show custom events to see which trigger fires when user navigates DFF field.

2. If the WHEN-NEW-RECORD fires, then trap that with condition :system.current _field='DF'
in this case, set the entire block to update allowed false

This will work, however you will then need to reset the block property as soon as user click on any non-dff field

Thanks,
Anil
Quote
0 #24 German Ernst Casaretto 2008-08-21 12:43
Hi Anil,

I've been reading many of your posts about Oracle Apps and I found them very useful for my work.

We're having a problem with a Form Personalization to set an attribute of a flexfield to Null.

We're using the Person form and created a Personalization that should not allow the user to modify only 4 attributes within the flex field in this form. (Attributes 7,8,9 and 11).
I've created a condition that returns true when the user tries to save the PErson form and the values entered in any of these attributes are different form the original values. Up to now everything's ok.

In the Actions section, I created a Global Variable to save the original value of these attributes.
The n I set the modified attribute to its original value. LIke this:
Target Object: PERSON.ATTRIBUT E7
Property: VALUE
Value: =:global.XX_ATT RIBUTE7 (this is my global variable).

Act ually this works fine, but there's one exception when the Attribute was originally set to NULL and the user tries to change its value to a not NULL one.

What happens here is that NULL is saved into the Global Variable and then it tries to set NULL in the Attribute. This gets an error message in the status bar and te Attribute remains with the modified value, not null.

So, there's any way to set an attribute within a flex field to NUll without re-setting the whole flex field?

Because what I thought is to save every original value of the flex field and then re-set the whole flex field with those original values, but I don't think it's very tidy...

I'd really appreciate you help on this.

Thanks,
German
Quote
0 #25 PJ 2008-10-07 09:15
When extracting from DEV using FNDLOAD, is there a way to only extract specific personalization s? I have multiple developers workingin the same form and only one personalization has been approved to move to the next environment. The way we do the FNDOAD now, it extracts everything and I only want one.

Thanks,
P J
Quote
0 #26 Peter 2008-10-10 02:57
Is ther any provision to use the Trigger Events like (WHEN-BUTTON-PR ESSED,PRE-FORM) which are not in the LOV.
Quote
0 #27 Meeta 2008-10-16 06:02
Hi all, I need to restrict users from querying all the items in the item master form by using only "%" in the item code. I want to display a message to the user to give some input parameters for querying else cancel the query.

Can I do this via forms personalization ?

Thanks.
Quote
0 #28 Kavita Badhani 2008-10-22 11:32
Hi Anil,

I have a question regarding the above Subject line.
I am not able to pass multiple parameters in form through personalization .

Kindly help

Thanks,
K avita Badhani
Quote
0 #29 Samia Razak 2008-11-09 10:43
How does one document the XML personalisation s. As far as I can see there isn't any AIM recommended approach to do this. One way is to have a navigation path linking the XML files. The seond, very laborious route is to docuemnt each any every line of the XML file as these relate to an inidvidual page personalisation - but then we are talking about approx. 3000 personalisation s for Talent Mnagement. Does anyone have any ideas of thoughts here?

Thanks
Quote
0 #30 Anil Passi- 2008-11-09 10:54
Which personalization s are you refering to...Forms Personalization ? or OA Fwk Personalization s.
Forms personalization s are stored in database, but not in XML format.

Given that you mentioned XML, I assume you refer to OA Framework personalization s.
Good luck if you are trying to document those 3000 Personalization s :)
Its like chasing a moving target.

If will be quicker and accurate to write some scripts on JDR Attributes, which prodouces Personalization documentation on the fly.
You can join the pages to the menus, and those to responsibility via tables, and document which personalization is effective to which screen, and what is changed.

If not for fusion being on horizon, I am sure Oracle would have produced a javadoc styled engine to document those personalization s.

Anyway, no matter how much manual documentation you do for personalization , it will be impossible to keep it accurate and upto-date.
Half information is dangerous as they say.
Single source of truth for personalization is MDS Repository in database, and no document can replace that.

Perhaps your organization should put procedures in place to ensure no one manually updates personalization s on production system.

Thanks ,
Anil Passi
PS- Similar principles apply to Oracle Forms Personalization s as well
Quote
0 #31 miki 2009-02-05 06:30
Hello Anil or all I see that on FP you operate the build in of execute query.
Can yopu please explaine haw you solved the issue applied by Ashwini May last year.
An example specific for order organizer form will be appriciated.
Mi ki
Quote
0 #32 Waquar Khan 2009-05-06 12:11
Hi Anil,

mY problem is exactly the same as of German Ernst Casaretto , I need to update a DFF attrribute with NULL value through foprm personalization s, but this seems not achievable.
Can you please guide me through this.

It would be a great help.

Thanks
Quote
0 #33 Damon Cool 2009-05-27 12:58
You have explained so many things to me! Thank you so much!
Quote
0 #34 Vives 2009-06-03 10:03
Hi Anil, it's my first post here, and i'm glad to, finally , have the opportunity to ask you something.

My issue is that users has a lot of work when they do a batch receipt and have to check it out which receipt should not be on the list, and so they start looking for receipts and then uncheck them before format

So, my question is, can we uncheck some specific receipts automatically that have been selected before. I mean, i want to create a batch which transactions are between Jan/2009 and feb/2009 (due_date)..... but i want to uncheck those one that their due_date is Gen-15. Could this be done.

I'll appreciate any kind of information.
Th ank you!

Vives
Quote
0 #35 Vives 2009-06-03 10:04
I forgot to say that....could thos be done with FP??

Apollogiz e :D
Quote
0 #36 Anil Passi 2009-06-04 01:39
Hi V

You can surely uncheck/check those checkboxes via Forms Personalization .
You can use do key - Next record as the action

See details in

docs.google.com/Doc?id=dcfd8fsc_62fdfvz9

Also- have a look at
apps2fusion.com/apps/apps/oracle-apps-articles/147-forms-personalizations

Thanks,
Anil Passi
Quote
0 #37 aliceyy 2009-06-16 23:40
I managed to achieve this via the following steps:
1. Application Developer: DFF> Register> (To register the DFF)
2. Application Developer: DFF> Segments> (To define the DFF fields), assign Value Set to each segment (create a value set if you dont already have one).
3. Check the Security Enabled flag (enable Security for the value Set, use Tools>Examine to enter 'Y' if field is protected).
4. System Admistrator: Security> ValueSet> Define (Query the value set assigned to the DFF segment).
5. Enter security rule name.
6. Exclude everything.
7. Include nothing.
8. Assign the security rule to a responsibility.
9. Navigate to Form Personalization of the form:
Condition s=When-New-Form -Instance
Conte xt>Level>Select Responsibility and assign to the same responsibility (if you dont do this, you can still enter the DFF just cannot save)
10. Now navigate to the DFF, you cannot enter any value there.
Quote
0 #38 IndiraS 2009-07-31 05:46
Hello Anil,
I have one problem similar to Ashwin's. We want to call a procedure with username as parameter whenever a new user is created or responsibility is changed/updated /added. I want to know the following things:
1) Which event should I use - I want to call procedure when 'Save' button is clicked.
2) I'm getting following error, when trying to call procedure with parameters(Kind ly note that procedure call without parameter is working fine.
I did the following: Action Type : Builtin ,Builtin Type : Execute Procedure, Argument ='declare
BEGIN
user_resp_singl e_signon ;
END' -- This is running fine.

When I try to pass parameter as below:
='declar e
BEGIN
user_resp_singl e_signon_p('Test');
END'
I get error :The string '=declare End' could not be evaluated because of error ORA-000923: FROM keyword not found where expected.

Pls help. This is urgent
Quote
0 #39 Vinay kumar Datrak 2009-08-08 06:43
Hi Anil,

When you enter the PO number into the Oracle, AP Invoice data entry screen , if the PO is fully billed we require a prompt to tell us at this point that one i have done

Now on the same screen one more req is there

The second prompt we want is when the tax amount from the invoice is entered , if this will over bill the PO, we require a prompt to tell us that it is Overbilled . This must happen before the invoice is committed to the system and the voucher number is created. We may also want to build in a 5% tolerance at this point

If the value entered (after tax – which will give you the net figure) is greater than the PO value then we want a prompt to I inform us of this………if tolerance then build in.

How can i acheive this second requirement
Whi ch trigger to be written and how to build in this tolerance level

Thanks,
Vinay
Quote
0 #40 Rakesh Jain 2009-09-29 10:50
I want to check if duplicate Divisional Controllers are not enetered thru Project Key Members Form. Is it something I can do thru Forms Personlization ? Key members are basically persons and Divisional Controller is a role name. I want to make sure that there is only one Divisional controller for a given Project Number.

Please let me know If I am not making myself clear.

Any help is appreciated.

Thanks
Rakesh
Quote
0 #41 MehulP53 2009-12-17 20:52
Hi Anil,

I am working on the custom web application for the Order Management module. Where users use the standard oracle forms to enter the header level details. To enter the line level details, they will use the custom web application which I am calling from the custom menu entry created under Actions menu. This custom web application is not developed in OAF, it is a stand alone web application.
Th e problem i m facing is that the lines created by the web application are not visible in the forms immediately as they are created in a different session.
I have created a local variable which gets set to TRUE when the menu entry is clicked and I want to use that local variable to reload the order when users goes to the lines block.
Is there an event which can requery the order? Can this be done using personalization ?

Thanks,
Mehu l
Quote
0 #42 Nidhi 2010-01-22 01:18
Hi Anil,

I have modified one LOV, below is the query modified by me

SELECT jpv.segment1,
jpv.po_release_ id,
jpv.po_header_i d,
jpv.release_num ,
jpv.vendor_id,
jpv.vendor_site _id
FROM jai_57f4_po_v jpv,
JAI_PO_OSP_HDRS jpoh
where jpv.po_release_ id = jpoh.oth_doc_id (+)
and jpv.vendor_id = jpoh.vendor_id (+)
and jpv.vendor_site _id = jpoh.vendor_sit e_id (+)
and jpv.po_header_i d = jpoh.po_header_ id (+)

I need to add one column and show it with existing columns (Segment1 or Release Num), but I execute following query, it gives error, let me know how can i concatenate form_number with any of them, segment1 or release num.

SELECT jpv.segment1,
jpv.po_release_ id,
jpv.po_header_i d,
jpv.release_num || '-' || jpoh.form_numbe r,
jpv.vendor_id,
jpv.vendor_site _id
FROM jai_57f4_po_v jpv,
JAI_PO_OSP_HDRS jpoh
where jpv.po_release_ id = jpoh.oth_doc_id (+)
and jpv.vendor_id = jpoh.vendor_id (+)
and jpv.vendor_site _id = jpoh.vendor_sit e_id (+)
and jpv.po_header_i d = jpoh.po_header_ id (+)

Thanks
Quote
0 #43 Vibha Pandey 2010-05-27 03:33
Hi...I have made a custom form. It working fine. But when I try to personilze it, the personalize option is not active.Also the examine option under diagnostics is not available.
Quote
0 #44 JJ 2010-06-08 03:23
Hi Anil

I read ur post that we can do Disabling DFF thru Personalization and u suggested that

" Set the entire block non-updatable as soon as user navigates to DFF Field.Use Show custom events to see which trigger fires when user navigates DFF field."

I have tested this but its is not working as there is no event fires when we go to DFF field.
Pl suggest is there any other solution for this??

Joohi
Quote
0 #45 JJ 2010-06-08 03:25
Hi

Is there any possibility to disable a single tab(not the whole block) in tab canvas

Joohi
Quote
0 #46 prasan 2010-07-22 08:58
When we select a context value from the drop down of a DFF which even gets fired. Can we handle or get that event in OA page.
Suppose I have two context one is global context and other one was custom context. When Page opens for the first time it shows the global context.
When We select the custom context from the drop down it shows the corresponding segments of that context.
I just wanted to know hw to handle or capture that even of selecting the custom context.

Regar ds
Prasan
Quote
0 #47 chrys 2010-08-06 14:20
Hi -

I'm working in Purchasing Form and one of the requirements is to check if the buyer entered is valid or not. I tried forms personalization using when-validate-b utton trigger, object trigger- PO_APPROVE and use this condition:
:PO_HEADERS.AG ENT_ID IN (
SELECT emp.person_id
FROM per_all_people_ f hr,
per_all_assignm ents_f emp
WHERE emp.person_id = hr.person_id
AND emp.primary_fla g = 'Y'
AND emp.assignment_ type = 'E'
AND hr.current_emp_ or_apl_flag = 'Y'
AND hr.current_empl oyee_flag = 'Y'
AND emp.effective_e nd_date
Quote
0 #48 chrys 2010-08-06 14:24
continuation:
A ND emp.effective_e nd_date
Quote
0 #49 Joe Espinosa 2011-03-10 15:13
Anil--
I'm wondering if there is a way, through form personalization , for the comment (the paperclip icon) to display the comment when the form is accessed. This is within HRMS, when someone in HR brings up an employee's Assignment, the comment is displayed, instructing HR what to do for this employee because of special circumstances? I only want to the comment to display if the papf.comment_id IS NOT NULL.

thx
Joe Espinosa
HRIS Sys Admin
Quote
0 #50 prasuna 2011-06-16 06:42
Hi Anil,

I am facing a problem while making the fields as mandatory in the standard form 'Create Contact' in CRM module.

Actual ly the form behaves like ,after filling the first name or last name for a customer, the party number will be generating and saves the contact of a customer for a perticular Sevice id. But, my requirement is that i have to make two more fields phone number and email as mandatory.

I have done this using forms personalization . After making this also, if i have entered first name or last name only and clicking on the save button it is showing pop up as 'field must be entered' and generaing the party number and the form gets closed.
Here its just showing the pop up as filed must be entered but i m unable to enter the date .
After filing the mandatory fields only the party number should be generated. How to do this one?

Regards,
Prasuna.
Quote
0 #51 Kalyanip 2011-07-11 02:35
Hi Anil,

I have developed a custom form for one of my client. Of course this is my first form...
The form is working fine when it is independent. But according to the req. it should get invoke from the standard form.
my custom form should capture the Doc id value from the standar form and depending on that value it should display the value
in my custom form.

I have added the parameter for capturing the Doc Id..And added the form personalization in the stadard form also. When I click on validate the Doc id value is capturing and dispalying in the smal note...But it is not capturing in the custom form... I have written code in the pre-query trigger in the custom form.

Please help me in this issue. My work delivery is got stopped due to this issue. Please help me...

Thanks In Advance,
Kalyan i Prema.
Quote
0 #52 Anindya 2011-11-07 11:03
Hi Anil,

A big fan :-). I've a requirement to insert some information in a custom table after the records in a form are saved. How can I achieve this?

Anindya
Quote
0 #53 Guruprasad 2013-10-08 06:25
My requirement is to call a 'Define Modifier' Form from custom form through Form Personalization by populating the value from the custom form to standard form.
I am able to call the form, but not able to pass a parameter to it.
I have created a menu for special45 and i am able to call the Define modifier form through 'Launch a Function' of type Builtin.

Now i want to pass a parameter from custom form (calling form ) to Standard Form (Called form).

Please help me on this issue.

Thanks in Advance.
Gurupr asad.
Quote
0 #54 Harish123 2015-03-31 11:14
Hi can anybody know how to personalize form to
disable button depending upon particular field value
e.g..
Form Order Management Super user
Error Correction form
where ORDERS.ORDER_SO URCE_ID=20 for line button should be disabled else for all records it should be enable.
Quote
0 #55 Abhinav 2015-07-03 14:56
Dear Anil,
I am able to hide all the DFF attributes at invoice header workbench for a specific 'AP inquiry' responsibility . But how can I just hide any 1 attributes for a specific responsibility and remaining attributes can be seen. Is it possible.

Can some please advise.

Regards
Abhinav
Quote
0 #56 เครดิตฟรี 2021-07-12 01:42
I'm really loving the theme/design of your web site.
Do you ever run into any internet browser compatibility problems?
A number of my blog audience have complained about my blog not operating correctly in Explorer but looks great
in Safari. Do you have any suggestions to help fix this issue?
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