Thursday, July 23, 2015

PDE-PLI018 Could not find library NAME



In the name of Allah, Most Gracious, Most Merciful

Praise be to Allah, blessing and peace be upon our prophet Mohammed, his family and his companions. After that,


     
     The skills gained from experienced such development errors; Googling  for a solution, ask a professional friend, leads you to successfully climb the ladder of experience. Employers are often looking  for a value you can add to hire you. 

     Normally, experience does not come easily, as long as you work on Oracle forms application development you would face a lot of compilation or run-time form's errors either begins with 'FRM' or  with 'ORA' database errors. These errors are common errors to large numbers of expert Oracle developers. 

      Accidentally, You may face such uncommon error begins with e.g. PDE-  pop up for you on opening such Pl/SQL Library from Oracle Form Builder. Today, i will demonstrate to you such uncommon error you should be familiar with ...

Key problem: 

  Error: PDE-PLI018 could not find library NAME
 When you try to open the library in the oracle forms builder it throws the above error even though the library is included in the path...

Key Reason:
  

   It's a  form 10g 's bug. 

When attempting to open a .pll from the Forms Builder using the login of the User who is not having the administrator privilege, the following error occurs: PDE-PLI018 could not find the library



Key Solution: 

      When attempting to open a .pll from the Forms Builder using the login of the User who is not having the administrator privilege, the following error occurs: PDE-PLI018 could not find the library.
  •  The simplest solution for this bug is you should have OS's administration rights so that you can login and Run The Form Builder As administrator .
  •  This Bug is also included as part of the Patch Set 10.1.2.3 whereas for the Versions 10.1.2.0.2 and 10.1.2.2, One-Off Patch 2673271  has to be applied.

You can you check this form 10g's bug at My Oracle Support (MOS) document 602158.1





    Hope this helps…

    Learn more about: 



      

    My success only comes from Allah, pls. note your comments and suggestions are great help for me in progress thanks in advance.



    Wednesday, July 22, 2015

    Centralize Oracle Window Forms 


    In the name of Allah, Most Gracious, Most Merciful      
    Praise be to Allah, blessing and peace be upon our prophet Mohammed, his family and his companions. After that,



       Centralize Oracle Window Forms On Web Browser Definition:Task 
      
    Task Solution: 

    You can use the following code in 
    WHEN-WINDOW-ACTIVATED or PRE-FORM Trigger Form Level


    SET_WINDOW_PROPERTY(FORMS_MDI_WINDOW, WINDOW_STATE, MAXIMIZE);  
    SET_WINDOW_PROPERTY('MAIN_WINDOW', X_POS, (GET_WINDOW_PROPERTY(FORMS_MDI_WINDOW, WIDTH ) - GET_WINDOW_PROPERTY('MAIN_WINDOW', WIDTH )) / 2);  
    SET_WINDOW_PROPERTY('MAIN_WINDOW', Y_POS, (GET_WINDOW_PROPERTY(FORMS_MDI_WINDOW, HEIGHT) - GET_WINDOW_PROPERTY('MAIN_WINDOW', HEIGHT)) / 2);  


    The following code  is another option you can use in
     WHEN-WINDOW-ACTIVATED or PRE-FORM Trigger Form Level



    DECLARE

        v_window               WINDOW;
        v_window_height        NUMBER(10);
        v_window_width         NUMBER(10);
        v_height               NUMBER(10);
        v_width                NUMBER(10);
        v_ calc_width          NUMBER(10);
      

    BEGIN

       v_window := FIND_WINDOW(YOUR_WINDOW_NAME);

       v_height := TO_NUMBER(GET_APPLICATION_PROPERTY (DISPLAY_HEIGHT));

       v_width := TO_NUMBER(GET_APPLICATION_PROPERTY  (DISPLAY_WIDTH));

       v_window_height:= GET_ WINDOW_PROPERTY(FORMS_MDI_WINDOW, HEIGHT);

       v_window_width := GET_WINDOW_PROPERTY (FORMS_MDI_WINDOW, WIDTH);

                 v_ calc_width: = (v_width - v_window_width)/ 2;


                 v_ calc_height : = (v_ height - v_window_height)/ 2;

    SET_ WINDOW_PROPERTY(v_window,POSITION,v_calc_width,v_calc_height);

    END;




    Note: 


    DISPLAY_HEIGHT: Returns the height of the display in the coordinate system of the form module.
    DISPLAY_WIDTH: Returns the width of the display in the coordinate system of the form module.


    Learn more about: 

    ·        Dependent Drop Down list

    Hope this helps…

    My success only comes from Allah, pls. note your comments and suggestions are great help for me in progress thanks in advance.


    Maximize Oracle Window Forms


       In the name of Allah, Most Gracious, Most MercifulPraise be to Allah, blessing and peace be upon our prophet Mohammed, his family and his companions. After that, 

         I believe that the rule #1 in structuring a user interface is a consistency that allows developers to reuse code for similar tasks. Consistency helps you to minimize the effort spent in fixing errors, reducing the training costs consumed in explaining the logical workflow that matches their real workflow and increasing the user's adaptability to work on the application. Thus, your application will make sense to the user if every widget or control works consistently as expected.

        On the other hand, Upgrading Oracle from client-server to the web base was the biggest challenge that a lot of companies had. Oracle Web forms are a different kind of architecture: 3-tier (client-application-data). At the client, Forms runs in a Java-applet started from a web browser. 

        Hence, the 'Maximum' Window button is an example of inconsistency; it was working fine in client-server architecture, but it won't work the same way in 3-tier architecture.

         Now, let's highlight the issue of "Maximize Oracle Window Forms" this would really help maintaining consistency all over your application specially in upgrading from client-server to the web base application.

     Key problem:  Oracle Window web-base Form NOT Maximizing.


    Maximizing Oracle Client-Server Window forms is different from maximizing MDI window on Oracle web-base forms using the same code in WHEN-NEW-FORM-INSTANCE  Trigger :


    SET_WINDOW_PROPERTY (FORMS_MDI_WINDOW, WINDOW_STATE, MAXIMIZE) ;
         SET_WINDOW_PROPERTY ( 'UR_WINDOW_NAME', WINDOW_STATE, MAXIMIZE) ;


    Even though the MDI window on Oracle web-base forms appears as Maximized but it is NOT actually maximized and it doesn't show the complete status bar. 

    Key Reason:

       Unfortunately, there is no built-in way to actually "MAXIMIZE" in the parent or MDI window. This issue has been explained in BUG#4944285 Known and  Note 181100.1

    Key Solution: 


    Search for  formsweb.cfg file, open it with note pad to view the content, look for a parameter called ' separateFrame' this parameter takes a Boolean data type either True or False value. edit and save the changes you prefer to make after reading the difference between the two value's affection.


     separateFrame=TRUE

    Oracle Web base Forms cannot actually maximize the separate frame for the JRE limitation issues, but alternatively you can maximize the MDI Window to be the same size as the applet container. You have two options either:

    1.   You can add the following code to WHEN-NEW-FORM-INSTANCE  or PRE-FORM trigger:



    SET_WINDOW_PROPERTY (FORMS_MDI_WINDOW, WINDOW_STATE, MAXIMIZE);

    SYNCHRONIZE;


    2.  Or you can use the following java bean example in the following link:  

            A JavaBean to handle the Forms applet's frames


    3.     Alternatively you can use  Michael Ferrante's suggestion (Principal Product Manager).  
      
      
     separateFrame=FALSE

    In this 'separateFrame' value option 'FALSE', the form's parent window container is the browser itself. Oracle Forms cannot maximize the browser.

    The Oracle Forms window MDI only fills out the applet container space NOT the web browser. Thus in order to maximize the web browser you have to set the following in formsweb.cfg file.


    HEIGHT=100%

    WIDTH=100%


    Note: Pls. refer to My Oracle Support  Note:358468.1
     This note explains the bug issue with a specific solution on
     " How to Maximize the MDI Window correctly on Web showing the Status bar?" 

      
    Hope this helps…

    Learn more about: 
         ·        Dependent Drop Down list
         ·        In-Direct Global Variable Access


    My success only comes from Allah, pls. note your comments and suggestions are great help for me in progress thanks in advance.


    Sunday, July 12, 2015

      Fingerprint Time Attendance Clock Tips

    In the name of Allah, Most Gracious, Most Merciful      
    Praise be to Allah, blessing and peace be upon our prophet Mohammed, his family and his companions. After that,

          Today you will learn some new ideas and techniques; many developers have no experience with "Fingerprint Employee Time Attendance Clock" so I thought to share my experience regarding this point.

         Regardless of your experience or the knowledge of your implementation skills, there are some aspects you should be aware of on demand to develop with any programming language. 

         This is the experience talks, which are not written in books or even learned from courses. But this is the technical knowledge that you have to gain or at least have a knowledge background on it.


    Fingerprint Attendance Tips…

    The following are some tips on "Fingerprint Employee Time Attendance Clock" you should read and consider:


    1.     Manuals: Reading the manual of the fingerprint device, If not available you can take the device's Name or serial-no and Google the internet.

    2.     Hardware: Check up the plugs and hardware connections and make sure your Machine Power is switched on.

    3.     API: If either you or the technician successfully installs your finger print device, you may found no application program interface (API) to retrieve the data. Considering such devices generate text file on some schedule basis; this schedule is related to the adjustment of the clock device (Check-In or Check-In) Clock Machine.

    4.      ODBC: Connecting the software of the fingerprint machine to the Oracle database requires connecting to the ODBC. Hence, access to the databases is managed by the 'Microsoft ODBC Driver Manager'. The driver manager provides the linkage between an ODBC application and an ODBC driver for a specific database management system.


    Note: ODBC applications do not need to be re-linked or re-compiled in order to change which database management system they are accessing. For more information pls. refer to ODBC. You can also Download Oracle 11g release 2 client ODBC drivers


    5.     If successfully connected to Oracle database then you will have a table called e.g. ATTENDANCE; this Table has such database columns defined as follow:

    ·        "Serial": Specifying the transaction serial no.
    ·        "Emp_id": Specifying the employee's id.
    ·        "Trans_Date ": Specifying the date and time of the employee's transaction.
    ·        "Location_name": Specifying the company's gate name or entrance number where the fingerprint attendance machine is located.
    ·        "Status": The status column is predetermined defined to register only two values either (IN) or (OUT).
         In fact, this table is a raw table registers each fingerprint the employee made. Each transaction is registered into a database row. Unfortunately, it is free of control BUT waits for your technical skills to operate on it.

    Sample transaction: 


    Serial Emp_id Trans_Date Location_name Status
    15400
    00001
    23/mar/2015 8:15:33

    G001 IN
    16589
    00001
    23/mar/2015 15:15:33

    G001 OUT

        
          You should take into account that each fingerprint results in an individual transaction. This is not a good practice as expected since the output data is not normalized this is the least to say…

    Note: No doubt, calling a customer support employee or a sales engineer is defiantly a good idea. They are the dedicated technicians to the job; they specialize in defining, installing, connecting the fingerprint machine to the database and can professionally demonstrate its usage.


          You should also be alerted to the operation and troubleshooting steps followed by him to solve problems. In order to guarantee further safe and successful workflow at the client's company or inside your workplace.




    Hope this initially helps you …

        Learn more about:

    ·          Dependent Drop Down list


    My success only comes from Allah, pls. note your comments and suggestions are great help for me in progress thanks in advance.

    .