1 2 Previous Next 17 Replies Latest reply on Mar 7, 2019 2:10 PM by Beauty_and_dBest Go to original post
      • 15. Re: EBS 12.1.3  Create SO error
        Beauty_and_dBest

        Thanks Yoonas, Vishnu, Michael, and ALL

         

        I thought  the error usually shows at the end of file.

         

        [appmoli@tstsvr log]$ grep -i 'ERROR generating' adwork*

        adwork001.log:ERROR generating library "resource/INVOBGEN.plx" from input file

        adwork001.log:ERROR generating library "resource/INVTTMTX.plx" from input file

        adwork001.log:ERROR generating library "resource/RCVTXVTX.plx" from input file

        adwork001.log:ERROR generating form "forms/US/INVCCEOI.fmx" from input file

        adwork001.log:ERROR generating form "forms/US/INVKBPSQ.fmx" from input file

        adwork001.log:ERROR generating form "forms/US/INVMSDEF.fmx" from input file

        adwork001.log:ERROR generating form "forms/US/INVPCKLT.fmx" from input file

        adwork001.log:ERROR generating form "forms/US/INVRSVF1.fmx" from input file

        adwork001.log:ERROR generating form "forms/US/INVSDOIO.fmx" from input file

        adwork001.log:ERROR generating form "forms/US/INVTVPTX.fmx" from input file

        adwork001.log:ERROR generating form "forms/US/RCVRCERC.fmx" from input file

        adwork002.log:ERROR generating library "resource/INVLTENT.plx" from input file

        adwork002.log:ERROR generating library "resource/INVRSVFM.plx" from input file

        adwork002.log:ERROR generating library "resource/INVTTELT.plx" from input file

        adwork002.log:ERROR generating library "resource/INVTTMVE.plx" from input file

        adwork002.log:ERROR generating library "resource/RCVTXERE.plx" from input file

        adwork002.log:ERROR generating form "forms/US/INVIDSNT.fmx" from input file

        adwork002.log:ERROR generating form "forms/US/INVMWBIV.fmx" from input file

        adwork002.log:ERROR generating form "forms/US/RCVSHESH.fmx" from input file

        adwork002.log:ERROR generating form "forms/US/RCVTXECO.fmx" from input file

        adwork002.log:ERROR generating form "forms/US/RCVTXERT.fmx" from input file

        adwork002.log:ERROR generating form "forms/US/WIPTXCFM.fmx" from input file

        adwork003.log:ERROR generating library "resource/INVADPTE.plx" from input file

        adwork003.log:ERROR generating library "resource/INVCORE.plx" from input file

        adwork003.log:ERROR generating library "resource/INVMTXFH.plx" from input file

        adwork003.log:ERROR generating library "resource/INVSLENT.plx" from input file

        adwork003.log:ERROR generating library "resource/RCVCOTRX.plx" from input file

        adwork003.log:ERROR generating library "resource/RCVRCERL.plx" from input file

        adwork003.log:ERROR generating library "resource/RCVSHESH.plx" from input file

        adwork003.log:ERROR generating form "forms/US/INVITSNU.fmx" from input file

        adwork003.log:ERROR generating form "forms/US/INVSAFDH.fmx" from input file

        adwork003.log:ERROR generating form "forms/US/INVTDILT.fmx" from input file

        adwork003.log:ERROR generating form "forms/US/INVTTESR.fmx" from input file

        adwork003.log:ERROR generating form "forms/US/INVTTMTX.fmx" from input file

        adwork003.log:ERROR generating form "forms/US/INVTVTXN.fmx" from input file

        adwork003.log:ERROR generating form "forms/US/RCVTXERE.fmx" from input file

        adwork003.log:ERROR generating form "forms/US/RCVTXVTX.fmx" from input file

        adwork004.log:ERROR generating library "resource/INVMTXIT.plx" from input file

        adwork004.log:ERROR generating library "resource/INVSAFDH.plx" from input file

        adwork004.log:ERROR generating library "resource/INVSDOSI.plx" from input file

        adwork004.log:ERROR generating library "resource/INVTOTRL.plx" from input file

        adwork004.log:ERROR generating library "resource/RCVTXECO.plx" from input file

        adwork004.log:ERROR generating form "forms/US/INVIDITM.fmx" from input file

        adwork004.log:ERROR generating form "forms/US/INVSDSUB.fmx" from input file

        adwork004.log:ERROR generating form "forms/US/INVTOTRX.fmx" from input file

        [appmoli@tstsvr log]$

         

         

         

          Temporarily resetting FORMS_PATH to:

          "/u02/appmoli/PROD/apps/apps_st/appl/au/12.0.0/resource:/u02/appmoli/PROD/apps/apps_st/appl/au/12.0.0/forms/US:/u02/appmoli/PROD/apps/apps_st/appl/au/12.0.0/resource/US"

         

        Generating library "resource/INVOBGEN.plx" with command:

         

        /u02/appmoli/PROD/apps/tech_st/10.1.2/bin/frmcmp_batch module=/u02/appmoli/PROD/apps/apps_st/appl/au/12.0.0/resource/INVOBGEN.pll userid=APPS/***** output_file=/u02/appmoli/PROD/apps/apps_st/appl/au/12.0.0/resource/INVOBGEN.plx module_type=library batch=yes compile_all=special

         

         

        ERROR generating library "resource/INVOBGEN.plx" from input file

        /u02/appmoli/PROD/apps/apps_st/appl/au/12.0.0/resource/INVOBGEN.pll

         

        Results of library generation:

        (from file /u02/appmoli/PROD/apps/apps_st/appl/au/12.0.0/resource/INVOBGEN.err

        AD Worker has deleted the original .err file)

        -------------------------------------------------------------------------

        Compilation errors on CHILD_TREE:

        PL/SQL ERROR 302 at line 170, column 51

        component 'GETGENEALOGYLEVEL' must be declared

        PL/SQL ERROR 0 at line 170, column 19

        Statement ignored

        PL/SQL ERROR 306 at line 319, column 25

        wrong number or types of arguments in call to 'INV_POPULATE_CHILD_TREE'

        PL/SQL ERROR 0 at line 319, column 25

        Statement ignored

        PL/SQL ERROR 306 at line 413, column 8

        wrong number or types of arguments in call to 'INV_POPULATE_CHILD_TREE'

        PL/SQL ERROR 0 at line 413, column 8

        Statement ignored

         

        Failed to generate library.

         

        FRM-30312: Failed to compile the library.

         

        -------------------------------------------------------------------------

         

         

         

        Please help how to resolve above issue.... 

         

         

         

        Kind regards,

        • 16. Re: EBS 12.1.3  Create SO error
          Beauty_and_dBest

          Hi ALL,

           

          I have run aderrchk below:

          Did I pass parameter correctly?

           

          sqlplus apps/apps @aderrchk.sql apps apps % aderrchk.log NOFAIL

           

          SQL*Plus: Release 10.1.0.5.0 - Production on Thu Mar 7 20:04:38 2019

           

          Copyright (c) 1982, 2005, Oracle.  All rights reserved.

           

           

          Connected to:

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

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

           

          Connected.

           

          PL/SQL procedure successfully completed.

           

           

          schema name           'apps'

          schema password       *****

          objects starting with '%'

          spool file            'aderrchk.log'

          failure behavior      'NOFAIL'

           

           

          +-----------------------------------------------------------------+

          Looking for invalid objects in schema 'apps'...

          +-----------------------------------------------------------------+

           

          Note: We ignore invalid triggers if they are disabled.

           

           

           

          +-----------------------------------------------------------------+

          Displaying invalid objects not listed in USER_ERRORS

           

          These objects may have become invalid since the last attempt

          to compile invalid objects.

           

          They may also indicate serious errors that occurred when

          attempting to compile invalid objects.

          +-----------------------------------------------------------------+

           

           

          OBJECT_TYPE

          ------------------

          OBJECT_NAME

          -------------------------------------------------------------------------------

          PACKAGE BODY

          ISC_EDW_BOOK_SUM1_F_C

           

          PACKAGE BODY

          OPI_EDW_OPMCOGS_F_C

           

          PACKAGE BODY

          OPI_EDW_COGS_F_C

           

           

           

          +-----------------------------------------------------------------+

          Displaying invalid objects listed in USER_ERRORS

           

          These are objects that did not compile successfully during the

          last attempt to compile invalid objects.

          +-----------------------------------------------------------------+

           

           

          OBJECT                             LINE

          --------------------------------- -----

          ERROR

          -----------------------------------------------------------------

          JAVA CLASS                            0

          oracle/apps/fnd/common/ias/JservA

          dminHelper

          ORA-29552: verification warning:

          java.lang.UnsupportedClassVersionError:

          oracle/apps/fnd/common/ias/JservAdminHelper (Unsupported

          major.minor version 49.0)

           

          JAVA CLASS                            0

          oracle/apps/fnd/common/ias/JservD

          escriptor

          ORA-29552: verification warning:

          java.lang.UnsupportedClassVersionError:

          oracle/apps/fnd/common/ias/JservDescriptor (Unsupported

          major.minor version 49.0)

           

          JAVA CLASS                            0

          oracle/apps/fnd/common/ias/JservI

          nfo

          ORA-29552: verification warning:

          java.lang.UnsupportedClassVersionError:

          oracle/apps/fnd/common/ias/JservInfo (Unsupported major.minor

          version 49.0)

           

          JAVA SOURCE XXSE_CLOB_URL_REPLACE     0

          Note: XXSE_CLOB_URL_REPLACE uses or overrides a deprecated API.

           

                                                0

          Note: Recompile with -Xlint:deprecation for details.

           

          PACKAGE BODY AHL_UTIL_UC_PKG         34

          PLS-00452: Subprogram 'GETCSI_LOCATIONDESC' violates its

          associated pragma

           

          PACKAGE BODY                         14

          EDW_SUPPLIER_ITEM_PKG

          PLS-00452: Subprogram 'SUPPLIER_ITEM_FK' violates its associated

          pragma

           

          PACKAGE BODY                        325

          F1_INVENTORY_BALANCE_PKG

          PL/SQL: Statement ignored

           

                                              326

          PLS-00306: wrong number or types of arguments in call to

          'XXMSI_GET_CODE_COMBINATION'

           

          PACKAGE BODY                       1742

          FV_FACTS_TBAL_TRANSACTIONS

          PL/SQL: SQL Statement ignored

           

                                             1743

          PL/SQL: ORA-00918: column ambiguously defined

           

          PACKAGE BODY FV_FACTS_TBAL_TRX     2116

           

          OBJECT                             LINE

          --------------------------------- -----

          ERROR

          -----------------------------------------------------------------

          PL/SQL: SQL Statement ignored

           

          PACKAGE BODY FV_FACTS_TBAL_TRX     2117

          PL/SQL: ORA-00918: column ambiguously defined

           

          PACKAGE BODY                       3822

          FV_FACTS_TRANSACTIONS

          PL/SQL: SQL Statement ignored

           

                                             3823

          PL/SQL: ORA-00918: column ambiguously defined

           

          PACKAGE BODY                       4728

          FV_FACTS_TRX_REGISTER

          PL/SQL: SQL Statement ignored

           

                                             4729

          PL/SQL: ORA-00918: column ambiguously defined

           

          PACKAGE BODY FV_SF133_NOYEAR        914

          PL/SQL: ORA-00918: column ambiguously defined

           

                                              914

          PL/SQL: SQL Statement ignored

           

          PACKAGE BODY FV_SF133_ONEYEAR      1197

          PL/SQL: ORA-00918: column ambiguously defined

           

                                             1197

          PL/SQL: SQL Statement ignored

           

          PACKAGE BODY                        414

          FV_SLA_AR_PROCESSING_PKG

          PLS-00306: wrong number or types of arguments in call to

          'GET_FUND_DETAILS'

           

                                              414

          PL/SQL: Statement ignored

           

                                              474

          PLS-00306: wrong number or types of arguments in call to

          'GET_FUND_DETAILS'

           

                                              474

          PL/SQL: Statement ignored

           

                                              546

          PL/SQL: Statement ignored

           

                                              546

          PLS-00306: wrong number or types of arguments in call to

          'GET_FUND_DETAILS'

           

          PACKAGE BODY                        212

          FV_SLA_CST_PROCESSING_PKG

           

          OBJECT                             LINE

          --------------------------------- -----

          ERROR

          -----------------------------------------------------------------

          PL/SQL: Statement ignored

           

          PACKAGE BODY                        212

          FV_SLA_CST_PROCESSING_PKG

          PLS-00306: wrong number or types of arguments in call to

          'GET_FUND_DETAILS'

           

          PACKAGE BODY                        337

          FV_SLA_PO_PROCESSING_PKG

          PLS-00306: wrong number or types of arguments in call to

          'GET_FUND_DETAILS'

           

                                              337

          PL/SQL: Statement ignored

           

                                              526

          PLS-00306: wrong number or types of arguments in call to

          'GET_FUND_DETAILS'

           

                                              526

          PL/SQL: Statement ignored

           

                                              736

          PL/SQL: Statement ignored

           

                                              736

          PLS-00306: wrong number or types of arguments in call to

          'GET_FUND_DETAILS'

           

          PACKAGE BODY                        386

          ITG_SYNCSUPPLIERINBOUND_PVT

          PLS-00306: wrong number or types of arguments in call to

          'INITIALIZE'

           

                                              386

          PL/SQL: Statement ignored

           

          PACKAGE BODY                        190

          XXMSI_INVENTORY_ITEMS_PKG

          PLS-00306: wrong number or types of arguments in call to

          'XXMSI_GET_CODE_COMBINATION'

           

                                              190

          PL/SQL: Statement ignored

           

                                              207

          PL/SQL: Statement ignored

           

                                              207

          PLS-00306: wrong number or types of arguments in call to

          'XXMSI_GET_CODE_COMBINATION'

           

                                              224

          PL/SQL: Statement ignored

           

           

          OBJECT                             LINE

          --------------------------------- -----

          ERROR

          -----------------------------------------------------------------

          PACKAGE BODY                        224

          XXMSI_INVENTORY_ITEMS_PKG

          PLS-00306: wrong number or types of arguments in call to

          'XXMSI_GET_CODE_COMBINATION'

           

          VIEW FV_BUDGET_DISTRIBUTION_HDR_V     0

          ORA-00904: "FBDH"."AUTO_CREATE_FLAG": invalid identifier

           

           

          44 rows selected.

           

           

          PL/SQL procedure successfully completed.

           

          Disconnected from Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production

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

          [appmoli@tstsvr sql]$

           

           

          Kind regards,

          • 17. Re: EBS 12.1.3  Create SO error
            Beauty_and_dBest

            Hi ALL,

             

            There is a developer doing test on this TEST instance. Could she possibly corrupted or altered some seeded packages and libraries? Like the CUSTOM.pll?

             

             

            Kind regards,

            1 2 Previous Next