ORA-04063: Package Body "APPS.IEU_WR_PUB" Has Errors (Doc ID 2231208.1)

Last updated on MARCH 11, 2025

Applies to:

Symptoms

During 11i to 12.2 upgrade receive the following error on Oracle Universal Work Queue script:

sqlplus -s APPS/***** @/<DIR>/ad/12.0.0/patch/115/sql/adsqlwrapper.sql '<DIR>/ieu/12.0.0/patch/115/sql/IEUPRFWS.sql

ERROR at line 1:
ORA-04063: package body "APPS.IEU_WR_PUB" has errors
ORA-06508: PL/SQL: could not find program unit being called: "APPS.IEU_WR_PUB"
ORA-06512: at line 56
ERROR at line 1:
ORA-04063: package body "APPS.IEU_WR_PUB" has errors
ORA-06508: PL/SQL: could not find program unit being called: "APPS.IEU_WR_PUB"
ORA-06512: at line 56

Manually recompiling package body "APPS.IEU_WR_PUB" has the following errors:

Compilation Errors:

Errors for PACKAGE BODY IEU_WR_PUB:

LINE/COL ERROR
-------- -----------------------------------------------------------------
2349/15  PL/SQL: Statement ignored
2349/60  PLS-00306: wrong number or types of arguments in call to
        'WR_TASKS_DATA_OBJ'

2349/60  PLS-00306: wrong number or types of arguments in call to
        'WR_TASKS_DATA_OBJ'

2349/60  PLS-00306: wrong number or types of arguments in call to
        'WR_TASKS_DATA_OBJ'

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

LINE/COL ERROR
-------- -----------------------------------------------------------------
        'WR_TASKS_DATA_OBJ'

2379/15  PL/SQL: Statement ignored
2379/56  PLS-00306: wrong number or types of arguments in call to
        'DEF_WR_DATA_OBJ'

7223/15  PL/SQL: Statement ignored
7223/60  PLS-00306: wrong number or types of arguments in call to
        'WR_TASKS_DATA_OBJ'

7223/60  PLS-00306: wrong number or types of arguments in call to
LINE/COL ERROR
-------- -----------------------------------------------------------------
        'WR_TASKS_DATA_OBJ'

7223/60  PLS-00306: wrong number or types of arguments in call to
        'WR_TASKS_DATA_OBJ'

7223/60  PLS-00306: wrong number or types of arguments in call to
        'WR_TASKS_DATA_OBJ'

7253/15  PL/SQL: Statement ignored
7253/56  PLS-00306: wrong number or types of arguments in call to
        'DEF_WR_DATA_OBJ'

File versions:

/* $Header: IEUPUWRS.pls 120.9 2006/08/18 05:09:13 msathyan noship $ */
/* $Header: IEUPUWRB.pls 120.31 2006/08/18 05:10:53 msathyan noship $ */

Changes

Cause

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