R12.1.3 : While applying WMS patch 16272776 on EBS , following object became invalid WMS_WAVE_PLANN
Hi,
While applying WMS patch 16272776 on EBS , following object became invalid
WMS_WAVE_PLANNING_PVT
Please help us to fix the same.
Errors and versions :
===============
version :
========
SQL> select text from user_source where name='WMS_WAVE_PLANNING_PVT' and line=2;
TEXT
--------------------------------------------------------------------------------
/* $Header: WMSWVPVS.pls 120.7.12010000.12 2011/05/13 23:52:09 adyeh noship $ */
/* $Header: WMSWVPVB.pls 120.12.12010000.52 2012/12/04 06:12:16 ssrikaku noshi
Errors :
=======
SQL> show error;
Errors for PACKAGE BODY WMS_WAVE_PLANNING_PVT:
LINE/COL ERROR
-------- -----------------------------------------------------------------
3127/29 PLS-00382: expression is of wrong type
3127/29 PLS-00436: implementation restriction: cannot reference fields of
BULK In-BIND table of records
===========================================================================================================
Code creating the errors :
======================
SQL>
select a.line,a.text from user_source a,user_errors b where
a.name='WMS_WAVE_PLANNING_PVT' and a.name=b.name and
a.line=b.line;