-----------ORACLE FORM STUFF--------------

• Cntrl+ MAJ+K --- shows shortcut available for in form

•  forms not running

Go to folder where Jinitiator reside normally c:/Program Files/Oracle....... and search for the file "jvm.dll"
3. Rename the "jvm.dll" to any name you want.
4. If you are using Forms 10g, go to its folder i.e c:/devsuite_*/jre and search for the same file "jvm.dll" in that folder.
5. Then copy that "jvm.dll" to the folder of Jiniatiator mentioned in step 2. replacing the jvm.dll that you renamed.

• fmx /fmb not find

some time you check path of fmb / fmx from front end and check out in server according to that path but its not found on that path because its stored in custom path rather than oracle apss seeded path

• Adding Coloumns to already buit forms

Don’t do this -- right click block and add coloums by the data block wizard as it will re create the all items of that datablock and mess everything


Do this --- add fields directly by drag and drop on canvas and make them database item and map their column with database column. Set their class property and respective properties

• Item movement on Canvas can be set interms of pixel, cm , inches

View -> customise ruler guide










Adding Calender to text field


http://docs.oracle.com/cd/E18727_01/doc.121/e12897/T302934T457082.htm#I_calendar


Also pay attention that textbox on which you are popping out the calender should have its property class as TEXT_ITEM_DATE  and not  as TEXT_ITEM




LOV List of values in form


1. Create a record group
2. Add query in property of record group record group query
3. Create lov by wizard , attach record group to lov in its property


ORACLE FORMS




ORACLE FORM BUILDER
Oracle has provided a form named, TEMPLATE.fmb, to act as a starting point of any new Oracle Apps form development. This form resides in $AU_TOP/resource directory on the Oracle Apps server, i.e. the node on which Oracle Forms server is located.
Oracle keeps the entire set of Forms libraries in the same directory, i.e. $AU_TOP/resource. For any Oracle Apps form customization/development, we need to download the library files on the local pc where the forms customization/development will be downloaded.




Form Alert’s


Definition : Alert’s are the notification used to notify after generation of specific event


Components of Form
1. Form builder
2. Form compiler
3. Form runtime


Components of Form Builder
1. Object navigator
2. Property palette
3. Layout editor
4. pl/sql editor
Forms contains of
1. Blocks
2. Items
3. Canvas
4. Frames
5. Windows
6. PL/SQL Code Block






Three types of ALERT STYLE(popup style ALERT STYLE:PROPERTY PALLETTE)
1. Stop Alert
2. Caution Alert
3. Note Alert


We use TRIGGER’s to launch Alert. And At Max 3 buttons can be used with Alerts.
BUTTON 1 LABEL
BUTTON 2 LABEL
BUTTON 3 LABEL


4 types of canvas
4. Content canvas
5. Stacked canvas
6. Tab canvas
7. Toolbar canvas


We use built-ins to set/get the run time properties of item/blocks.
(:BLOCK_NAME.ITEM_NAME) used to perform comparison.
8. To declare GLOBAL VARIABLE
YOU HAVE TO DECLARE IT ABLOVE DECLARE BLAOCK WITH SYNTAX AS


: GLOBAL . variable_name := 0;


9. Before hiding any object we have move cursor first then that object can be hidden on the screen.
If we want to show the empty canvas then we have to create any item on that canvas with size, width & length . or simply hide that item And Move the cursor to that item.
10. Used triggers in Alert Example
SET_NEW_FORM_INSTANCE
WHEN_BUTTON_PRESSED


11. We can add our own PLSQL CODE and register it in trigger
12. Go to PLSQL EDITOR IN object navigator
Shortcut keys


F3-boejct navigator
F4- property palette
F11- Trigger








13. LIST OF FORM BUILT-INS
--SHOW_ALERT(‘alt_name’); THIS IS THE FUNCTION WITH RETURN TYPE NUMBER
--EXIT_FORM;
--SET_ALERT_PROPERTY('AL_NAME',ALT_TYPE(i.e.--text or title), ‘ALT_MESSAGE’);   
--GO_ITEM('BLOCK_NAME.ITEM_NAME'); to move cursor (it can also used to jump from one canvas to another
--SET_ITEM_PROPERTY('item_name',Property_name,PROPERTY_VALUE);
--Commit_form : is used to save form ( USEFUL WHEN WE MAKE DATABASE CHANGES)
--WHEN_NEW_FORM_OPEN


BUTTON
14. When we do button disable or invisible then it’s necessary to make it visible and enable both .


Radio button
15. Each radio group we have to set the initial value first , in each radio button of radio group we have to set the radio button value as ‘A’ or ‘B’ ,’C’,’D’ else 1,2,3,4 like this
16. We can set the label of radio button at run time for that we can use method SET_RADIO_BUTTON_PROPERTY('block6.Radio_group1','RADIO_FIRST',label,option1); here block6.radio_group1 is the name of radiogroup , radio_first is the first radio button in radio group , label is the property which we want to set at run time , option 1 is a variable which will pass value of label at run time .




LOV (LIST OF VALUES )
(for more information check out help in form builder )
List of value is to pop out list when we click /press a item . LOV can be generated simply by right clicking the item in object navigator and then selecting the lov wizard where we need to enter the query.
Now we need to write show_lov(‘lov_name’) in trigger so that lov will be get displayed, return type of lov is Boolean


Pasted from <file:///U:\swapnil%20dandgvhal\reading%20stuff\sticky%20notes%20backup\oralce%20apps.docx>






GLOBAL Variable


Global variable are declare above the declare
It don’t have datatype its syntax is :GLOBAL.s:='1';  and we can access it as :global.s




Random Number in ORACLE


SELECT substr(dbms_random.value(10, 99),-2)
FROM DUAL;   this will create random number value from 10 to 99






Forms conversion ( form to xml conversion ) (xml to form conversion )


Different oracle forms file
Form module =-.fmb files,
Object libraries=.olb files
Menu modules =.mmb files


We can convrt this files to .NET or Java  for that purpose we have to conver this file into xml files
Oracle developer 9i and oracle developer suite 10 g provide froms2xml  convert tool and xml2form convert tool