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 training article (for the readers of http://getappstraining.blogspot.com ), we will learn the steps needed to develop a custom Oracle Apps form from the very scratch.


In the previous chapter we learnt "how to customize an existing oracle delivered form"

Question: Why bother teaching this when Oracle fusion is destined to replace oracle forms by OA Framework?
Answer: Well firstly I am yet to hear an official word from Oracle in this regard, but  I agree it is highly likely that fusion will se demise of Oracle Forms. However more importantly Oracle will support current tech stack indefinitely, I.e Release 12 will be supported for foreseen time as per Apps Unlimited statement. Hence, many of the clients will keep using this technology for decades. Yes, I won't bother my kid learning Oracle form though.


Question : Ok, what are the steps for building a screen from scratch?
Answer: Below steps in brief
A) Open up TEMPLATE.fmb, and save this as XXHELLOAPPS.fmb
B) Create a new window, by right clicking on Window/new
Name this window as XXHELLOAPPS,and assign it SubClass Type “WINDOW” from picklist.
C) Create a new canvas and name it XXHELLOAPPS , ensuring its Sublcass Type is “Content”
D) Make the windows property reference canvas XXHELLOAPPS and vice versa make the canvas reference windows XXHELLOAPPS.
E) Now create a block named XXHELLOAPPS . Lets keep this a control block for simplicity.
F) go to form level property, and set first navigation block to XXHELLOAPPS.
G) Add a label and a field named “Hello_World” to this block.
H) Generate the form on PC using Control-T keystrokes. This will ensure that nothing critical has been missed out.
I)  FTP the form file to $XXPO_TOP/forms/US
Surely, this XX will be replaced by the naming convention at your client/company.
J)  cd to  $XXPO_TOP/forms/US
And f60gen on XXHELLOAPPS.fmb
This will create a file executable as XXHELLOAPPS.fmx
K) Go to Application Developer responsibility
Menu /applicaton/form
Register the form
L) Register the Forms Function
Have you read he article form functions[http://getappstraining.blogspot.com/2006/10/oracle-forms-functions-menus-and-their.html] yet?
This forms function must be registered against application "XX Purchasing".
M) Now add a menu item so that this forms function becomes available to specific responsibility.

Thats it, you will be able to open up this form from the responsibility.

Now some important notes:-
1. If you have a table based block, and if that block has some description type fields, then try not to fetch them from post query trigger. Instead, develop a view in apps schema and assign that view as base tale to this block. This has a benefit that users will be able to query on the description field if need be. Indeed you will need to do dml on the actual table yourself by overriding on-insert, on-update, on-delete and on-lock triggers.
2. For each block in the screen, create a form level package spec and package body. Your triggers in the block/block fields will make calls to that package.
3. Try not to do to much pl/sql within the form. Always do such database intensive operations in a database level package.
4. Try not using global variables, unless really needed. Give preference to the creation of form package variables.
5. In a multi record block, always add a field for Current Record Indicator.

Please let me know if anything is unclear. Feel free to ask your questions.


Anil Passi

Comments   

0 #1 santosh 2006-11-04 00:00
I have a small suggestion. I think it will be better if you have cbox in your website. you can look at it http://cbox.ws/?box=2004670.
I feel it will be useful to chat directly with each other who is online and get answers instantly. Its only a suggestion.
Quote
0 #2 santosh 2006-11-04 00:00
I have a small suggestion. I think it will be better if you have cbox in your website. you can look at it http://cbox.ws/?box=2004670.
I feel it will be useful to chat directly with each other who is online and get answers instantly. Its only a suggestion.
Quote
0 #3 Anil Passi 2006-11-15 00:00
THanks Santosh.
I am looking for some other commenting tool, as this commenting tool is not ideal, it does not send me emails. I will have a look at cbox
Quote
0 #4 Anil Passi 2006-11-15 00:00
THanks Santosh.
I am looking for some other commenting tool, as this commenting tool is not ideal, it does not send me emails. I will have a look at cbox
Quote
0 #5 AragoRn 2006-11-22 00:00
Hi Anil
i would like to add a few more points when developing a custom form

1. After u open the Template.fmb n change the module and window names ... go to pre-form to specify the new window and also the new module name in When-New-Form-I nstance triggers.

2. Open the program unit app_stand_windo w package body and the change the name of the window in Close_Window procedure.

n the rest is same as what anil has mentioned
Rega rds
Kishore
Quote
0 #6 Anil Passi 2006-11-22 00:00
You are Wonderful Kishore.

Man y thanks,
Anil Passi
Quote
0 #7 AragoRn 2006-11-22 00:00
Hi Anil
i would like to add a few more points when developing a custom form

1. After u open the Template.fmb n change the module and window names ... go to pre-form to specify the new window and also the new module name in When-New-Form-I nstance triggers.

2. Open the program unit app_stand_windo w package body and the change the name of the window in Close_Window procedure.

n the rest is same as what anil has mentioned
Rega rds
Kishore
Quote
0 #8 Anil Passi 2006-11-22 00:00
You are Wonderful Kishore.

Man y thanks,
Anil Passi
Quote
0 #9 venkat 2006-12-07 00:00
hi Anil
I am new to forms. After completing the desigining of the form we can only compile it.
can we also run it on the client machine or else is it mandatory to copy .fmx file to the unix box and run from apps. I have no idea how to run it. I was thinking it will be same as in reports where we run it and see the output on teh client machine only. Pls can u explain it

Thanks
Quote
0 #10 venkat 2006-12-07 00:00
hi Anil
I am new to forms. After completing the desigining of the form we can only compile it.
can we also run it on the client machine or else is it mandatory to copy .fmx file to the unix box and run from apps. I have no idea how to run it. I was thinking it will be same as in reports where we run it and see the output on teh client machine only. Pls can u explain it

Thanks
Quote
0 #11 Anil Passi 2007-02-26 00:00
Hi Vaishali,

Al l you need is Oracle Forms, that I believe can be downloaded from OTN [technet.oracle .com]

Howeve r, please learn java too, as forms has no place in Oracle Fusion Apps techstack.

T hanks,
anil
Quote
0 #12 Vaishali 2007-02-26 00:00
Hi Anil,
I am trying to learn FORMS. Can you please tell me which tool we have to install on PC/Laptop to start building FORMS.

Thank s in Advance,


V aishali
Quote
0 #13 Vaishali 2007-02-27 00:00
Hi Anil,
Thanks a lot for the prompt reply. I really appreciate your advice. First i want to learn Forms as that is the current requirement from my job. I need to download the jDeveloper / Forms 6i or other tool, please be specific.

If possible, could you please send me the download link and set up instruction for the same.

Thanks ,

Vaishali
Quote
0 #14 Anil Passi 2007-03-01 00:00
hi santosh,

sor ry, I never meant to discourage you to learn forms. Forms will still be around for at least four to five years or may be in theory forever, hence time invested into oracle forms will not be wasted.

Orac le Forms is a part of R12 technologies, and Oracle have commited to support R12 indefinitely. Hence for this reason Forms will stay around for long enough.

by oracle fusionapps techstack i meant technologies like ADF for UserInterface, ESB& BPEL for workflows, XMLP for reporting etc.

thanks,
anil
Quote
0 #15 Anil Passi 2007-03-01 00:00
hi vaishali

sor ry for delay in response. please use link below

its a zip file that you will download and then unziip on your PC

and then run setup.exe

http://www.oracle.com/technology/software/products/forms/index.html

http://www.oracle.com/technology/software/htdocs/devlic.html?url=http://otn.oracle.com/software/products/forms/htdocs/winsoft.html

thanks
anil passi
Quote
0 #16 Mihir 2007-03-15 00:00
Hi Anil,
I am not clear about 1st point you have mentioned under Now some Imp Notes. Or my question is Why has Oracle kept most of the blocks based on view and not on base table? What extra care needs to be taken if block is based on View?

Thanks
Mihir
Quote
0 #17 Anil Passi 2007-03-16 00:00
Hi Mihir

You can try this scenario at your end.
Create a form block with two columns,of which the first column is based on database column, and the second column is based on control-field.

When query is executed, lets say you populate the second field using post-query.

In this case, if you want to perform ENTER-QUERY, you will not be able to search on second column(control field)

somet imes users like to execute queries on on description based fields too.


Thank s
Quote
0 #18 Subhamay 2007-04-27 00:00
Hi Mihir,
In Oracle Apps the blocks are based on views as a part of Oracle Apps standards.Apart from all the columns the view also includes ROWID of the underlying tables and this view represents a de-normalised form of the data from the underlying tables(Anil,ple ase correct me if I am wrong).Also,pub lic synonyms are created in the apps schema for these views.

If your block is based on a view then all the DML statements (insert/update/ delete) to the underlying base tables are done through tables handles which are nothing but PL/SQL packaged procedures which can reside either on the client side of server side.Please go through the Application Developers Guide for more details.

Tha nks,
Subhamay
Quote
0 #19 Sreedhar Basangi 2007-06-18 00:00
Hi Anil,

Thank you very much for the articles.They are useful to me. I got one problem with the forms.We have 2 different forms called as a Standard Receipts form (RCVRECRC.fmb) and a custom form developed based on the standard form which is used to receive the internal orders of the organization.Du e to functionality problem they applied 5245360, 5336329, 4202057 and 4888266 patches on standard form.Its working fine.How can we apply the code to achieve the same functionality in the custom form?
Quote
0 #20 biranchi 2007-06-18 00:00
hi
anil how are you?i saw ur site it is very good ,i am in oracle pratice,though i am new in this field so can u tell me how to add to new columns in oracle standrad report

thank s
biranchi
Quote
0 #21 Anil Passi 2007-06-19 00:00
Hi Biranchi

1. Take a copy of the report from say $PO_TOP/reports /US/POPRINT.rdf
2. Rename the report and name it XXPOPRINT.rdf
3. Add the new column to XXPOPRINT.rdf
4. After making changes, move XXPOPRINT.rdf to $XXPO_TOP/repor ts/US or the equivalent
5. Register Concurrent program executable of type Report, that points to XXPOPRINT.rdf
6. Create concurret program for this executable
7. Add this new concurrent program to Request Group.

Thank s
Anil
Quote
0 #22 Anil Passi 2007-06-19 00:00
Hi Sreedhar

Loo ks like your client decided to customize a standard form. This is not a good practice. You will have to start allover again from scratch now to create custom form.

If I was you, I will advice your client to extend the screen via FP and CUSTOM.pll, instead of customizations.

Thanks
Ani l
Quote
0 #23 BIRANCHI 2007-06-21 00:00
hi
anil
i got ur mail.my question was how to add a coloum in standrad report layout model

regard s
biranchi
Quote
0 #24 venky 2007-08-28 08:38
i am new to forms .can u tell me about triggers in forms. i need with examples ....

WHEN WILL FIRE when_new_form_i nstance with one example ...
like this when_new_record _instance ...etc .

Regards
Venk at
Quote
0 #25 Michele 2007-09-10 13:05
Hi there

Can anyone clarify the use of the calendar in template.fmb. I have followed the instructions in the Apps User Guide exactly(used the ENABLE_LIST_LAM P LOV and added calendar.show to KEY_LISTVAL trigger) yet no LOV button (or calendar) appears when I tab or use the mouse to enter the date field. I have cross checked with a seeded Oracle form - APXINWKB.fmb and I see my setup is exactly the same. Am I missing a step somewhere?

Tha nks
Michele
Quote
0 #26 Anil Passi 2007-09-10 21:22
Hi Michele

At the item level, you need to create a trigger named KEY-LISTVAL, from which you will call CALENDAR.SHOW



Also, ensure that item property “Validate from List” is set to No



Thanks,
Anil Passi
Quote
0 #27 srinivasulu.dagada 2007-09-27 10:58
how can i visualize attibutes using USING CUSTOM.PLL GIVE WITH AN EXAMPLE
Quote
0 #28 a guest 2007-10-01 03:43
Anil,

I have a requirement to disable toolbar buttons. How do I figure out toolbar item names so that I can use APP_SPECIAL routine to disable?

Would highly appreciate your reply.

Thanks,
Srini
Quote
0 #29 Chami 2007-10-24 00:59
Hi Anil, I just created a customer form with one tabe, I have a problem I dont get any database message, the form add records to db and update fine.

EX:
Like 1 record adderd,
when i press F11 - enter query

http://forums.oracle.com/forums/thread.jspa?threadID=577095&tstart=0


Thanks,

Chami
Quote
0 #30 Chami 2007-10-24 01:54
Hi Anil, I just created a customer form with one tabe, I have a problem I dont get any database message, the form add records to db and update fine.

EX:
Like 1 record adderd,
when i press F11 - enter query

http://forums.oracle.com/forums/thread.jspa?threadID=577095&tstart=0


Thanks,

Chami
Quote
0 #31 Anil Passi 2007-10-24 05:43
Hi Chami

Please ensure that system.message_ level is not being changed in your code. If it has been changed, then make sure that its value is reset back to original value.

Thanks
Anil
Quote
0 #32 Sridhar Rao 2007-12-17 07:49
Hi Anil

I have created a form using custom.pll (based on a custom table). When ever i am closing the form it is poping up a message 'Do you want to save the form'. How to avoid it?

Regards
Sridh ar
Quote
0 #33 Sridhar Rao 2007-12-17 07:55
Hi anil

what is the majour difference in Oracle Fusion Apps techstack and oracle forms.

Regards
Sridhar
Quote
0 #34 Jass 2008-01-30 08:27
Hi Anil,

I am getting a strange error.
1. Client has sent a form say, A.fmb by mail. It is a custom form developed by someone in some other unix box (not a part of instance that i am working in).
2. I ftp the form as it is to the custom top in unix box, compile it using f60gen, it gets compiled perfectly, i register it into Apps and am able to open and use it .... so everything is going well.
3. Now i open the form in Form Builder, make any small change (i tried changing just the size of one frame), save it, ftp to unix box, compile using same command f60gen .... but the error is Segmentation Error(Core Dump).

Please help.
Jass.
Quote
0 #35 vijayanandg 2008-02-27 10:11
Hi Anil,
I had created a form using template.fmb, for a particular field attached ENABLE_LIST_LAM P LOV and added calendar.show to KEY_LISTVAL trigger(as mentioned in the screen shots). Compiled and register the same in the APPS. But in the runtime the field is not visible.

Kindly advice and clarify.

Regar ds
Vijay
Quote
0 #36 Namish Goyal 2008-02-27 10:50
hi anil,

im new to forms.could you please explain breifly "Now some important notes" mentioned above.
Quote
0 #37 Ladis Kumar 2008-03-05 08:27
Hello, I have designed a new custom form to read some datas of two tables that I previously created under APPS. The new form functions well. I can also compile this form under unix. My question: how can I register this form under a desired responsability. Thanks to all of you in advance.
Quote
0 #38 Narva 2008-03-07 08:23
Hi Anil,
I want to know is there are same steps to follow to develop a Custom Form in R12 also.
Regards/N arva
Quote
0 #39 bharu 2008-03-14 08:54
hi ,

i am doing new form customization for gl.i am usind templlet.fmb and making the form.how do i get all the functionaltys that i have in oracle forms i.e in front end like search function (when u open an form like in sysadmin if u open an form systemprofile values one one the left top u have a search key ie in tourch light symbol so i need to add that function to my form so plzz help me outt
Quote
0 #40 Suresh U 2008-06-29 11:02
Hai Anil,

Do you have a link to study about BOM/WIP tables or BOM/WIP technicality?

Thank you
Suresh
Quote
0 #41 Regalla 2008-07-16 03:07
Hi Gurus,

I developed a custom form using template.fmb based on a table block.
when i enter data and save, it does nt show record is appled and saved message. but in database table data i can see.
another one is calendar also not shown followed below steps
enable list lamp is set
validate from list is set to No
key-list-val trigger --> calendar.show;

but still i am nt able 2 see the calendar.

can any body help me please? is R12 form calendar different from 11.5.10 forms?
Quote
0 #42 sateesh kumar 2008-07-30 03:21
Hi All,

i am facing the issue with custom form.when we are trying to open same purchase order from 2 different logins.custom form locked
.please give me your suggestions.

R egards
Sateesh kumar.M
Quote
0 #43 Tron 2008-11-25 19:54
Thanks for the useful information. I tried your suggestion, however I get an error which says "FRM-40735: ON-ERROR trigger raised unhandled exception ORA-06508"

I cannot even run the form so I am not sure why this error is being thrown. I have tried to recompile APPCORE.pll but forms developer 6i crashes when I try this.
Quote
0 #44 RS 2007 2021-07-09 09:20
I read this paragraph completely about the difference oof
latest and preceding technologies, it's remarkable article.


Stop by my web site; RS 2007: https://probemas.com/blog/how-much-is-osrs-gold-worth-today
Quote
0 #45 Elf Camp OSRS 2021-07-10 02:33
Why viewers still maoe usee of to read news papers when in this technological globe the
whole thing is accessible on web?

Here is my wweb page - Elf Camp
OSRS: https://webmobistar.com/most-profitable-osrs-bosses-for-farming-gold/
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