While poking around on the My Oracle Support site (formerly Metalink), I ran across a script called WMS_health_check.sql (document 1086783.1) that contains 30 queries to find certain kinds of data corruption in Oracle Apps. Most of the checks are for WMS, but there are also several relating to Order Management, Shipping Execution, and Inventory/Purchasing/Receiving.
Some of the checks were things that I’ve looked for (LPNs that have been Shipped Out of Stores, but still have an onhand quantity), but most were ones that I hadn’t built queries for. In my defense, I am a Unix guy who plays Oracle DBA from time to time… ;^)
If you’re running Oracle E-Business Suite and have WMS-enabled organization(s), it’s definitely useful to check out this script. I opened several SRs after running the script for the first time. Hopefully this means fewer problems for our warehouse and shipping staff, and therefore fewer tickets for IT.