Monday 14 October 2013

How to execute WMSCheckLPN.sql?

please run the LPN diagnostic script - 
WMSCheckLPN.sql, for the problem/corrupted License Plate Number( LPN ) and upload the output.
Refer to Note 298052.1 for instructions and Licence Plate Number is H031923018.

SQL> select user,name from v$database;

USER NAME
------------------------------ ---------
APPS EBSTEST1

SQL> @WMSCheckLPN.sql
Please enter Licence Plate Number : H031923018

Date run: 09-OCT-13 17:19
Database: EBSTEST1
Applications: 11.5.10.2

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
PL/SQL Release 11.2.0.3.0 - Production
CORE 11.2.0.3.0 Production
TNS for Solaris: Version 11.2.0.3.0 - Production
NLSRTL Version 11.2.0.3.0 - Production


WMS Related Product Installation Status
WMS I=Installed
11i.WMS.G

PO I=Installed
11i.PO.I

ONT I=Installed
11i.ONT.J

INV I=Installed
11i.INV.J

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Analysing LPN related tables and columns Phase - 1 ....
Depending on the amount of underlying data to be analysed,
the script can run from a couple of seconds to several minutes.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~


Analysing WSH_DELIVERY_DETAILS_2SEP12
FROM WSH_DELIVERY_DETAILS_2SEP12
*
ERROR at line 200:
ORA-00942: table or view does not exist



Analysing WSH_DEL_DETAILS_INTERFACE

no rows selected

End of $Header: WMSCheckLPN.sql 1.1 21-Mar-2003 support
not spooling currently

=======================================================================
Please find output in file WMSCheckLPN.txt
=======================================================================

SQL>

Upload this output "WMSCheckLPN.txt" to ticketing tool.

No comments:

Post a Comment