6 Replies Latest reply on Jan 7, 2016 4:13 PM by Bashar.

    5055050 Patch: An error occurred while generating Oracle Forms files

    Ramaraju

      Hi,

      We are upgrading EBS 11i to R12.2.4. We upgraded db 11.2.0.3 to 11.2.0.4 and applying suggested patch HRMS Patch 5055050.

      For this We merged this patch along with 3500000, 4595475, 4444880.

      But it fails with following error.

      The following Oracle Forms objects did not generate successfull:

      po forms/US POXPOERL.fmx

      ap forms/US APXINWKB.fmx

      An error occurred while generating Oracle Forms files.

       

      INVALIDS:    

      OWNEROBJECT_NAMEOBJECT_TYPESTATUS




      SYSMANMGMT_ECM_POLICYPACKAGEINVALID
      APPS/e6bc455_DocumentGeneratorJAVAINVALID
      APPS/ae799f28_DirectDepositConcurrJAVAINVALID
      APPSOE_CREDIT_CARD_MIGRATE_UTILPACKAGEINVALID
      APPSUTL_RECOMPPACKAGEINVALID
      APPSBIS_COMMON_PARAMETERSPACKAGEINVALID
      APPSAP_WEB_CREDIT_CARD_WFPACKAGEINVALID
      APPSENI_RES_5_MVMATERIALIZEDINVALID
      SQLTXADMINSQLT$APACKAGEINVALID

       

      $ f60gen module=$AU_TOP/forms/US/POXPOERL.fmb userid=apps/****** output_file=$PO_TOP/forms/US/POXPOERL.fmx module_type=form batch=yes compile_all=special

      The above command doesn't show any errors and fmx not created.

       

      $ f60gen module=$AU_TOP/forms/US/POXPOERL.fmb userid=apps/****** output_file=$AP_TOP/forms/US/POXPOERL.fmx module_type=form batch=no compile_all=special

      Forms 6.0 (Form Compiler) Version 6.0.8.28.0 (Production)

      Forms 6.0 (Form Compiler): Release  - Production

      (c) Copyright 1999 Oracle Corporation.  All rights reserved.

      Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

           With the Partitioning, OLAP, Data Mining and Real Application Testing options

      PL/SQL Version 8.0.6.3.0 (Production)

      Oracle Procedure Builder V6.0.8.21.0 Build #0 - Production

      Oracle Virtual Graphics System Version 6.0.5.39.0 (Production)

      Oracle Multimedia Version 6.0.8.25.0 (Production)

      Oracle Tools Integration Version 6.0.8.17.0 (Production)

      Oracle Tools Common Area Version 6.0.5.32.0

      Oracle CORE Version 4.0.6.0.0 - Production

      FRM-18108: Failed to load the following objects.

      Source Module:POXDOCON.fmb

        Source Object: PO_CONTROL_OBJ

      Source Module:POXDOAPP

        Source Object: APPROVALS

      Source Module:POXOPROC

        Source Object: OUTSIDE_PROC

      Source Module:POXPOAH

        Source Object: PO_ACTION_HISTORY

      Source Module:POXDOREP.fmb

        Source Object: ONLINE_REPORT

      Source Module:APPSTAND

        Source Object: STANDARD_PC_AND_VA

      Source Module:APPSTAND

        Source Object: STANDARD_TOOLBAR

      Source Module:APPSTAND

        Source Object: STANDARD_CALENDAR

      Source Module:POXSTAND

        Source Object: SETUP

      Source Module:APSTAND

        Source Object: VNDR_ADDR_DISP

      Compiling package specification APP_CUSTOM...

         No compilation errors.

       

       

      Compiling package specification PO_RELEASES_C...

         No compilation errors.

       

       

      Compiling package specification PO_RELEASES_C1...

         No compilation errors.

      Compiling package specification PO_RELEASES_C2...

         No compilation errors.

      Compiling package specification PO_RELEASES_C3...

         No compilation errors.

      Compiling package specification INIT_FLEX...

         No compilation errors.

      Compiling package specification PO_RELEASES_C4...

         No compilation errors.

      Compiling package specification PO_CONSIGNMENT...

         No compilation errors.

      Compiling package specification APP_CUSTOM...

         No compilation errors.

      Compiling package body APP_CUSTOM...

      Compilation error on package body APP_CUSTOM:

      PL/SQL ERROR 49 at line 79, column 24

      bad bind variable 'po_startup_values.employee_id'

      PL/SQL ERROR 49 at line 79, column 24

      bad bind variable 'po_startup_values.employee_id'

      PL/SQL ERROR 49 at line 84, column 24

      bad bind variable 'po_startup_values.employee_id'

      Compiling package specification PO_RELEASES_C...

         No compilation errors.

      Compiling package body PO_RELEASES_C...

         No compilation errors.

      Compiling package specification PO_RELEASES_C1...

         No compilation errors.

      Compiling package body PO_RELEASES_C1...

      Compilation error on package body PO_RELEASES_C1:

      PL/SQL ERROR 201 at line 426, column 5

      identifier 'PO_OTM_INTEGRATION_GRP.IS_INBOUND_LOGISTICS_ENABLED' must be declared

      PL/SQL ERROR 0 at line 426, column 5

      Statement ignored

      Compiling package specification PO_RELEASES_C2...

         No compilation errors.

      Compiling package body PO_RELEASES_C2...

         No compilation errors.

      Compiling package specification PO_RELEASES_C3...

         No compilation errors.

      Compiling package body PO_RELEASES_C3...

         No compilation errors.

      Compiling package specification INIT_FLEX...

         No compilation errors.

      Compiling package body INIT_FLEX...

         No compilation errors.

      Compiling procedure CHECK_PACKAGE_FAILURE...

         No compilation errors.

      Compiling procedure QUERY_MASTER_DETAILS...

         No compilation errors.

      Compiling procedure CLEAR_ALL_MASTER_DETAILS...

         No compilation errors.

      Compiling package specification PO_RELEASES_C4...

         No compilation errors.

      Compiling package body PO_RELEASES_C4...

         No compilation errors.

      Compiling package specification PO_CONSIGNMENT...

         No compilation errors.

      Compiling package body PO_CONSIGNMENT...

         No compilation errors.

      Compilation errors have occurred.

      Form not created

       

      Please help me

       

      Thanks,

      Ramaraju