Tarek Fathy

-------------------------------------------------- If you are using DHCP or Your computer is not connected to a local network, You have to Follow these steps before beginning installation for Oracle Database 1-ADD Microsoft loopback adapter To install the Microsoft Loopback Adapter, follow these steps: 1-Go to Start | Control Panel | Add Hardware. 2-In the introductory dialog box, click Next. 3-Select Yes, I Have Already Connected The Hardware, and click Next. 4-Scroll to the bottom of the Installed Hardware list box, select Add A New Hardware Device, and click Next. 5-Select the Install The Hardware That I Manually Select From A List (Advanced) option, and click Next. 6-Under Hardware Types, select Network Adapters, and click Next. 7-Under Manufacturer, select Microsoft. 8-Under Network Adapter, select Microsoft Loopback Adapter. 9-Click Next twice, and click Finish. Assign a non-routable IP like"192.168.1.1" to Loopback Adapter don't assign xxx.xxx.xx.xx to network adap...

-------------------------------------------------- OracleOraHome10g service on Local Computer started and then stopped. Some services stop automatically if they have no work to do, for example, the Performance Logs and Alert service." solution Check windows/system32/drivers/etc/hosts for the hostname and IP of the server you are using for the OMS, you may need to add an entry here to resolve a DNS problem.

-------------------------------------------------- - go to control panel - add new hardware then add new networkadapter - after adding the network adapter, go to network setting and add a static IP address - then start installation

-------------------------------------------------- dxdiag to find specifications for your computer

-------------------------------------------------- To Collapse tree nodes PROCEDURE collapse_tree IS vnode ftree.node; vhtree ITEM; vstate varchar2(30); BEGIN -- Search the tree identifiant -- vhtree := Find_Item('TREE_BLOCK.HTREE'); -- Search the root -- vnode := Ftree.Find_Tree_Node(vhtree, ''); -- Collapse all nodes -- WHILE NOT ftree.ID_NULL(vnode) LOOP vstate := Ftree.Get_Tree_Node_Property(vhtree, vnode, Ftree.NODE_STATE); IF vstate = Ftree.EXPANDED_NODE THEN Ftree.Set_Tree_Node_Property(vhtree, vnode, Ftree.NODE_STATE, Ftree.COLLAPSED_NODE); END IF; vnode := Ftree.Find_Tree_Node(vhtree, '', Ftree.FIND_NEXT,Ftree.NODE_LABEL, '', vnode); END LOOP; END; To Expand tree nodes : PROCEDURE explose_tree IS node ftree.node; htree ITEM; state varchar2(30); BEGIN -- Search the tree identifiant -- htree := Find_Item('BL_TREE.MENU'); -- Search the root -- ...

-------------------------------------------------- 1- Open forms\server\ formsweb.cfg 2- Search for [JPI] section. This section exists by default. 3- You now will add three new parameters (jpi_download_page, jpi_classid, jpi_codebase) ------------------------------------------------- [jpi] baseHTMLJInitiator=basejpi.htm [MyApplication] baseHTMLJInitiator=basejpi.htm #archive=frmall.jar,frmall_jinit.jar,hst65.jar,icons.jar,frmwebutil.jar,jacob.jar archive=frmall.jar,frmall_jinit.jar,hst65.jar,icons.jar,frmwebutil.jar,jacob.jar jpi_download_page=http://java.sun.com/products/archive/j2se/1.4.2_09/index.html # or you may use application server URL #jpi_download_page= http://iai2.iai.org.kw:7778/forms/jinitiator/us/jinit_download.htm jpi_classid=clsid:8AD9C840-044E-11D1-B3E9-00805F499D93 jpi_codebase=http://java.sun.com/products/plugin/autodl/jinstall-1_4-windows-i586.cab#Version=1,4,0,0 ----------------------------------------- now copy this file " jre.exe " to the f...

-------------------------------------------------- create Journalling tables: 1. go to http://iai2.iai.org.kw:7778/forms/frmservlet?config=hsd65_utilities 2. Productivity Boosters --> Data Layer --> Logical Database Design (DB.010) 3. click on Maintain journal tables 4. select the names of Tables to be journaled, then click on run 5. generate th journal tables from DB Admin and grant roles to ADMIN and APPROVE 6. you don't need to generate CAPI for the journal table from the utilities, just generate the table from DB admin and then generate Table API from the Server model. 7. in the properites of the table to be journalled , put Journal in the notes filed create journalling triggers: 1.go to http://iai2.iai.org.kw:7778/forms/frmservlet?config=hsd65_utilities 2. Productivity Boosters --> Business Logic Layer --> Rule Layer - CDM RuleFrame --> Standar rule patterns 3. click on Maintain Journalling Business Rules 4. Select the tables to be journaled, then click on run ...