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 SEPTEMBER 19, 2019
Applies to:
Oracle Landed Cost Management - Version 12.2.3 and laterInformation in this document applies to any platform.
*** Checked on Relevance on 11/JUL/2019 ***
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 $ *
Changes
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 |
Changes |
Cause |
Solution |
References |