Compile pll files get the errors "wrong number or types of arguments in call to xxxx" and "cannot load library unit APPS.xxxx (referenced by APPSxxxxx)" (Doc ID 2230827.1)

Last updated on SEPTEMBER 20, 2023

Applies to:

Symptoms

You get the the error  "PL/SQL ERROR 306"  or "PL/SQL ERROR 907" when pll files

The following is an example on how to fix these errors by manually compiling the packages

Error EXAMAPLES

1) error compiling POXPOEPO.pll

Compilation errors on PO_HDR_SPECIAL_C:
PL/SQL ERROR 306 at line 1814, column 8
wrong number or types of arguments in call to 'ONLINE_REBUILD_ACCOUNTS'
PL/SQL ERROR 0 at line 1814, column 8
Statement ignored

Failed to generate library.

FRM-30312: Failed to compile the library.

2) 

Compilation errors on PO_LINES_SPECIAL:
PL/SQL ERROR 907 at line 0, column 0
cannot load library unit APPS.PO_PDOI_TYPES (referenced by APPS.PO_SOURCING2_SV)
PL/SQL ERROR 0 at line 160, column 8
Statement ignored

Failed to generate library.

FRM-30312: Failed to compile the library.

_______________________________________________________________________

From another client -

Relevant Information Collection
---------------------------------------
ERROR generating library "resource/POXPODIS.plx" from input file
apps/appl/au/12.0.0/resource/POXPODIS.pll

Results of library generation:
(from fileps/appl/au/12.0.0/resource/POXPODIS.err
AD Worker has deleted the original .err file)
-------------------------------------------------------------------------
Compilation errors on PO_DISTRIBUTIONS_C3:
PL/SQL ERROR 306 at line 125, column 3
wrong number or types of arguments in call to 'INSERT_ROW'
PL/SQL ERROR 0 at line 125, column 3
Statement ignored

Compilation errors on PO_DISTRIBUTIONS_C21:
PL/SQL ERROR 306 at line 37, column 1
wrong number or types of arguments in call to 'INSERT_ROW'
PL/SQL ERROR 0 at line 37, column 1
Statement ignored
PL/SQL ERROR 306 at line 199, column 1
wrong number or types of arguments in call to 'UPDATE_ROW'
PL/SQL ERROR 0 at line 199, column 1
Statement ignored

Compilation errors on PO_DISTRIBUTIONS_C16:
PL/SQL ERROR 306 at line 113, column 3
wrong number or types of arguments in call to 'UPDATE_ROW'
PL/SQL ERROR 0 at line 113, column 3
Statement ignored

Compilation errors on PO_DISTRIBUTIONS_C13:
PL/SQL ERROR 306 at line 130, column 3
wrong number or types of arguments in call to 'INSERT_ROW'
PL/SQL ERROR 0 at line 130, column 3
Statement ignored

Failed to generate library.

FRM-30312: Failed to compile the library.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.