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

Last updated on FEBRUARY 07, 2017

Applies to:

Oracle Universal Work Queue - Version 12.2 and later
Information in this document applies to any platform.

Symptoms

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

sqlplus -s APPS/***** @/data/oracle/fs1/EBSapps/appl/ad/12.0.0/patch/115/sql/adsqlwrapper.sql '/data/oracle/fs1/EBSapps/appl/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

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