WMS Health Check scripts for Oracle Apps 11i and R12
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
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 […]
Recent Comments