ORA-01402 : no data found

After Cloning OR upgradation of OS mainentance level , user is getting " ORA-01402 : no data found "

OR

'FRM-40815:Variable GLOBAL.LLL(xx) does not exist' After AIX Patches IY68989 and IY73497"

1. Please check for the OS patches IY68989 and IY73497

At OS prompt issue the follwing Command

$instfix –ik IY68989

$instfix –ik IY73497

2. If the patches are applied. Apply the appropriate patch depending on your forms version from the list

==========================================
Note : To find the form version . Use "f60gen"

[ILMIS:ilmis] /home/users/ilmis> f60gen
Forms 6.0 (Form Compiler) Version 6.0.8.24.1 (Production)

In our case form version "6.0.8.24.1"
=============================================

Patch: 4689213 (6.0.8.24.x i.e Patch-set 15)

Patch: 4670400 (6.0.8.25.x i.e Patch-set 16)

Patch: 4689364 (6.0.8.26.x i.e Patch-set 17)

W.r.t internal , fix for this is included in Patch 18 (i.e 6.0.8.27.x ) and later

Applying the PATCH 4689213

 1. Shutdown the forms server if it is running

 ./adfrmctl stop 

2. Copy the zip and unzip the file

$ Unzip p4689213_600_AIX.zip

It will create bug bug4689213 folder

(NOTE : ORACLE_HOME refers to 8.0.6-based Forms 6i home )

3. Back up the libraries

   $ cd $ORACLE_HOME/lib

   $ cp -p libiwf.a libiwf.a.PRE_BUG4689213

   $ cp -p libiwfw.a libiwfw.a.PRE_BUG4689213

4. Archive object files into libraries

  $ cd $ORACLE_HOME/bug4689213

  $ ar rv $ORACLE_HOME/lib/libiwf.a opt/iweil.o 

  $ ar rv $ORACLE_HOME/lib/libiwfw.a optweb/iweil.o 

 5. Generate Forms shared libraries

    $ cd $ORACLE_HOME/bug4689213

    $ chmod +x genshlib

    $ cp genshlib $ORACLE_HOME/bin

    $ cd $ORACLE_HOME/lib

    $ $ORACLE_HOME/bin/genshlib iwf 0

    $ $ORACLE_HOME/bin/genshlib iwfw 0

6. Relink Forms binaries

   $ cd $ORACLE_HOME/forms60/lib

   $ make -f cus_forms60w.mk install

   $ adrelink.sh force=y "fnd f60webmx"

7. Restart Forms server

   $./adfrmctl start



==> Kindly refer to the metalink note : 338469.1 , for detailed information ..