5 Replies Latest reply: May 16, 2013 12:17 PM by 1008897 RSS

    FND_SECURITY_PKG is invalid

    dm_ptldba
      Version : 12.1.3 on linux 5.7
      Db: 10.2.0.5

      The login page fails to come up (500 internal server error) and checking the log shows that FND_SECURITY_PKG is invalid.
      Tried recompiling the invalid objects ( and executed tulrp.sq) but no luck

      Please help
        • 1. Re: FND_SECURITY_PKG is invalid
          1008897
          dm_ptldba wrote:
          Version : 12.1.3 on linux 5.7
          Db: 10.2.0.5

          The login page fails to come up (500 internal server error) and checking the log shows that FND_SECURITY_PKG is invalid.
          Tried recompiling the invalid objects ( and executed tulrp.sq) but no luck

          Please help
          What's the error message you get when you compile the package manually?
          • 2. Re: FND_SECURITY_PKG is invalid
            dm_ptldba
            SQL> alter package FND_SECURITY_PKG compile body;

            Warning: Package Body altered with compilation errors.

            SQL> show error
            Errors for PACKAGE BODY FND_SECURITY_PKG:

            LINE/COL ERROR
            -------- -----------------------------------------------------------------
            268/2 PL/SQL: Statement ignored
            268/17 PLS-00905: object APPS.FND_WEB_SEC is invalid
            273/7 PL/SQL: Statement ignored
            273/21 PLS-00905: object APPS.FND_WEB_SEC is invalid
            SQL> alter package APPS.FND_WEB_SEC compile package;

            Warning: Package altered with compilation errors.

            SQL> show error
            Errors for PACKAGE APPS.FND_WEB_SEC:

            LINE/COL ERROR
            -------- -----------------------------------------------------------------
            6/1 PLS-00103: Encountered the symbol "CREATE" when expecting one of
            the following:
            end function package pragma private procedure subtype type
            use <an identifier> <a double-quoted delimited-identifier>
            form current cursor

            SQL>
            • 3. Re: FND_SECURITY_PKG is invalid
              1008897
              Please take a backup of your existing FND_WEB_SEC package code, and try to recreate it using the following scripts:

              $FND_TOP/patch/115/sql/AFSCJAV8.pls
              $FND_TOP/patch/115/sql/AFSCJAVS.pls
              • 4. Re: FND_SECURITY_PKG is invalid
                dm_ptldba
                Please suggest how should I execute them .
                1. Does the apps tier needs to be up when executing the script ?
                2. Is there any sequence for executing the scripts ?
                • 5. Re: FND_SECURITY_PKG is invalid
                  1008897
                  1. Does the apps tier needs to be up when executing the script ?
                  Does the application work properly with the invalid objects you have? It's better you shutdown the application services (if this is a TEST/DEV instance).
                  2. Is there any sequence for executing the scripts ?
                  It might invalidate many objects in the database, however if this package gets created successfully after running the scripts you will need to validate other invalid objects manually or via adadmin