2 Replies Latest reply on Jan 31, 2019 6:02 PM by 3565914

    unable to compile CUSTOM.pll after rebuilding database

    3565914

      Hi all

       

      I have 2 node R12.1.3 instance   , application is on 1 node (OEL 6) and database is on second node ( 12.1.0.2  on OEL 6)

       

      we had an issue with SYSTEM tablespace taking around 1TB , to fix the issue we had rebuild the database using Doc ID 1520084.1

       

      the application now online but we have issue with forms ( multi org )

       

      we get errors like TOO_MANY_ROWS ( while trying to query in forms)

       

      i tried recompiling invalids using utlirp and utlrp and then compiling all forms

       

      but the only error i get is when compiling CUSTOM.pll

       

      frmcmp_batch module=CUSTOM.pll userid=apps/**** output_file=CUSTOM.plx module_type=LIBRARY batch=no compile_all=special

       

      Forms 10.1 (Form Compiler) Version 10.1.2.3.0 (Production)

       

      Forms 10.1 (Form Compiler): Release  - Production

       

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

       

      Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

           With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,

           Advanced Analytics and Real Application Testing options

      PL/SQL Version 10.1.0.5.0 (Production)

      Oracle Procedure Builder V10.1.2.3.0 - Production

      Oracle Virtual Graphics System Version 10.1.2.0.0 (Production)

      Oracle Multimedia Version 10.1.2.0.2 (Production)

      Oracle Tools Integration Version 10.1.2.0.2 (Production)

      Oracle Tools Common Area Version 10.1.2.0.2

      Oracle CORE     10.1.0.5.0      Production

      Compiling library CUSTOM...

        Invalidating Package Spec FND_PROFILE......

        Invalidating Package Spec CUSTOM......

        Invalidating Package Body CUSTOM......

        Invalidating Procedure Body FDRCSID......

        Compiling Package Spec FND_PROFILE......

        Compiling Package Spec CUSTOM......

        Compiling Package Body CUSTOM......

      ERROR 306 at line 213, column 11

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

      ERROR 0 at line 213, column 8

        Statement ignored

      ERROR 306 at line 289, column 9

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

      ERROR 0 at line 289, column 6

        Statement ignored

      Closing library CUSTOM...

      Compilation errors on CUSTOM:

      PL/SQL ERROR 306 at line 213, column 11

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

      PL/SQL ERROR 0 at line 213, column 8

      Statement ignored

      PL/SQL ERROR 306 at line 289, column 9

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

      PL/SQL ERROR 0 at line 289, column 6

      Statement ignored

       

      Failed to generate library.

       

      FRM-30312: Failed to compile the library.

       

       

      Any suggestions will be appreciated