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.
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