Last updated on MARCH 08, 2017

Applies to:

Symptoms

On : 12.2.3 version, Installation Issues

Problem Description:
---------------------------

Can not able to create PO using BWC because of invalid INL_INTEGRATION_GRP package body

---------------------------------------------------
While creating PO using BWC we are getting the following exception.

Exception Details.
oracle.apps.fnd.framework.OAException: java.sql.SQLException: ORA-06550: line 1, column 13:
PLS-00905: object APPS.INL_INTEGRATION_GRP is invalid
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

While we tried to compile the package we got the following.

SQL> alter package apps.INL_INTEGRATION_GRP compile;

Warning: Package altered with compilation errors.

SQL> alter package apps.INL_INTEGRATION_GRP compile body;

Warning: Package Body altered with compilation errors.

SQL> sho error
Errors for PACKAGE BODY APPS.INL_INTEGRATION_GRP:

LINE/COL ERROR
-------- -----------------------------------------------------------------
0/0 PL/SQL: Compilation unit analysis terminated
1/14 PLS-00304: cannot compile body of 'INL_INTEGRATION_GRP' without
  its specification

1/14 PLS-00905: object APPS.INL_INTEGRATION_GRP is invalid

SQL> select text from dba_errors where name='INL_INTEGRATION_GRP';

TEXT
--------------------------------------------------------------------------------
PLS-00302: component 'RTI_OPM_CUR_TABLE' must be declared
PL/SQL: Declaration ignored
PLS-00905: object APPS.INL_INTEGRATION_GRP is invalid
PLS-00304: cannot compile body of 'INL_INTEGRATION_GRP' without its specificatio
n

PL/SQL: Compilation unit analysis terminated


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Purchasing >
2. Buyer Work Center > Orders >
3. Create Standard Purchase Orders > Go > following Exception occurs.

Exception Details.
oracle.apps.fnd.framework.OAException: java.sql.SQLException: ORA-06550: line 1, column 13:
PLS-00905: object APPS.INL_INTEGRATION_GRP is invalid
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

-----------------------------------------------------------------------------------------------------------------------


SQL>
SQL> select text from dba_source where name='INL_INTEGRATION_GRP' and text like '%$Header%';

TEXT
--------------------------------------------------------------------------------
/* $Header: INLGITGS.pls 120.31.12020000.6 2014/01/02 14:19:49 anandpra ship $ *
/
/* $Header: INLGITGB.pls 120.70.12020000.5 2014/01/02 14:23:08 anandpra ship $ *

Cause