My Oracle Support Banner

An Alternative to WMSCheckLPN Diagnostic: WMSCheckLPN_RTO.sql (Doc ID 1392333.1)

Last updated on FEBRUARY 01, 2019

Applies to:

Oracle Warehouse Management - Version 11.5.10 and later
Information in this document applies to any platform.
This document includes all versions of Oracle EBS 11.5 and R12.
For Users on 12.1+ and 12.2+, please use the LPN Diagnostic in .


Symptoms

WMSCheckLPN diagnostic of <Document 228600.1> will produce an incomplete output file or it is slow or it will not complete.

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
 Get the script "WMSCheckLPN_RTO.sql"
 How to use the script "WMSCheckLPN_RTO.sql"
 When to use the script "WMSCheckLPN_RTO.sql"
 Will the script "WMSCheckLPN_RTO.sql" eradicate these problems for all environments
 Design Considerations
 Additional Enhancements
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.