1 Reply Latest reply: Sep 20, 2013 11:27 AM by Vigneswar Battu RSS

    User Hook issue

    user10451741

      Hi ,

       

      I am trying to execute Pre-processor related to User Hook but was not able to run.

      Any ideas please let me know.

       

      Thanks,

      Subbu.

       

      so tried below options

      Case 1:

       

      $PER_TOP/admin/sql

      execute hrahkone.sql

       

      Case 2:

       

      SQL> @hrahkall.sql

      SP2-0310: unable to open file "hrahkall.sql"

       

       

       

       

       

      this file is not under given location

       

       

       

       

      clntest01@caxla14 $ pwd

      /oracle/clnttes01/apps/apps_st/appl/per/12.0.0/admin/sql

      clndev01@caxla14 $ ls -ltr hrahkall.sql

      ls: 0653-341 The file hrahkall.sql does not exist

        • 1. Re: User Hook issue
          Vigneswar Battu

          Check $PER_TOP/patch/115/sql

           

          applBIKE >pwd

          /u08/oracle/BIKE/apps/apps_st/appl/per/12.0.0/patch/115/sql

          applBIKE >ls -tl hrahk*

          -rwxr-xr-x  1 applbike dba  2162 Sep  8  2012 hrahkone.sql

          -rwxr-x---  1 applbike dba 27392 Dec 13  2008 hrahkrhi.pkh

          -rwxr-x---  1 applbike dba  2372 Dec 13  2008 hrahkall.sql

          -rwxr-x---  1 applbike dba 72081 Dec 13  2008 hrahkrhi.pkb