Compiling and Testing Customized Banner Forms via Oracle Forms Developer
Fri, 2007-05-04 11:44 — rickl
I'd like to know if anyone is using Oracle Forms Developer {Forms [32 Bit] Version 9.0.4.1.0 (Production)} to customize seeded Banner Forms. If so, are you able to compile and test the Forms within the Oracle Forms Developer tool using OC4J? If anyone is doing this please share the setup issues you've run across.
I'm able to compile customized forms in Oracle Forms Developer but when I try to run the Forms from the tool I get run-time errors. It's as if the Form doesn't have access to the compiled .plx libraries.
Any help is appreciated.
Compiling and Testing Customized Banner Forms via Oracle Forms D
I am working right now with Oracle Forms Developer version 9.0.4.0.19. This is what I did to be able to compile and test the form within the Oracle Forms Developer:
1) I move goqclib,goqolib,goqrlib and gumappl to the folder where I have the form I am customizing.
2) Compile these objects using Oracle Forms Developer.
3) Open the form, change the name, go to forms property and change the name
3) Go to G$_VERIFY_ACCESS trigger under form trigger. Comment FORM_FILE_NAME variable. Create a new FORM_FILE_NAME variable as FORM_FILE_NAME ='newbannerform.fmb'
4) Compile the form
5) Start the OC4JHTTP
6) Ask for Banner GSASECR security
7) Run the form
8) You will get warning error related with Global variables so just click Ok.
Hope this help you,
Patricia F.
GSASECR?
Hello, thanks for your help,
Step 1 to 5 is ok for me, but i'm stuck at step 6 !
Do you have more explanations for this step?
Thank you very much !
GSASECR and GUAOBJS
For step 6, you need to have the object defined in the system. You'd want to go to GUAOBJS, and add your form to the list of objects available in Banner. If you don't have the privileges to add the object in GUAOBJS, you'll need to ask your DBA to add your form object to that list.
Along with having the object defined, you'll also need privileges to run your form. This is where the GSASECR part comes in. You'll need to have someone with GSASECR privileges (ask your DBA for guidance on who to ask for that) add your form to the list of banner security objects (tying an object to a default oracle role for that object), and also grant you rights in order to open that form.
Once those three conditions are met (the form object exists in GUAOBJS, the form exists in GSASECR's security list, and you have been granted access to the new form object), then you can run your form.
Modified formsweb.cfg, get neede jar's, setup libaray start oc4j
1. You needed to modified formsweb.cfg in oracle_home/forms90/server directory. Best place to get this is from production server and then modified a little bit especilly directory
2. add needed Jar files in oracle_home/forms90/java directory. like banicons.jar, bannerui.jar and banspecial.jar best if to copy from your current production server.
2a. Make sure banner libraries are located in FORSM90_PATH directory.
2b take base line vesrion of guainit compile in windows and put it in forms library path.
3. start OC4J
4. Run baseline form to test.
5 if baseline form work and you are having trouble with security in new form then just rename newform to existing form to which you access to run it test it and rename back to what you want to call it.
Vipul Patel
Senior Enterprise Resource Plng Developer
The George Washington University
ISS/AdminApps/BannerApps
vpatel@gwu.edu