WMS Health Check scripts for Oracle Apps 11i and R12

By
Aug 24, 2011
4 Comments

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 […]

Script to count LPNs by context in Oracle Apps 11i

By
Aug 4, 2011
No Comments

Need to count how many LPNs are in each context for a given organization in Oracle E-Business Suite 11i? Here’s a quick script: select count(*), lpn_context, decode(lpn_context, ‘1’, ‘Resides in Inventory’, ‘2’, ‘Resides in WIP’, ‘3’, ‘Resides in Receiving’, ‘4’, ‘Issued out of Stores’, ‘5’, ‘Defined but not used’, ‘6’, ‘Resides in Intransit’, ‘7’, ‘Resides […]

Disconnecting users from Oracle MWA

By
Jan 26, 2011
No Comments

These instructions are for E-Business Suite 11.5.10 CU2; they may or may not work in other versions. For an MWA telnet server, or Listener, at a given port number, there is a command channel listening at the next highest port number.  For example, if the Listener is on port 21001, the command channel is on […]