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 AUGUST 23, 2017

Applies to:

Oracle Purchasing - Version 12.2.4 and later
Oracle Application Object Library - Version 12.2.4 and later
Oracle Applications DBA - Version 12.2.4 and later
Information in this document applies to any platform.

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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms