My Oracle Support Banner

NOT ABLE TO CREATE PO USING BWC ERROR APPS.INL_INTEGRATION_GRP is invalid ORA-06550: line 1, column 7: PL/SQL: Statement ignored (Doc ID 1933843.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Landed Cost Management - Version 12.2.3 and later
Information in this document applies to any platform.

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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution
References


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.