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