Search Results get help with file explorer in windows




The WSH_Tables.html file in Oracle E-Business Suite (EBS) 12.1.1 or 12.2.2 pertains to the **Warehouse Shipping Execution (WSH)** module, which is a critical component of the Oracle Supply Chain Management (SCM) suite. This file typically contains documentation or metadata describing the key database tables used in the WSH module. Below is a detailed summary of its significance, structure, and key tables referenced. ### **Overview of Warehouse Shipping Execution (WSH)** The WSH module manages shipping and logistics operations, including pick release, packing, shipping confirmation, and freight cost calculations. It integrates with other Oracle modules like **Inventory (INV)**, **Order Management (OM)**, and **Transportation Management (WSM)**. The tables documented in WSH_Tables.html store transactional and configuration data essential for shipping workflows. ### **Key Tables in WSH_Tables.html** The file likely outlines the following major tables: 1. **WSH_DELIVERIES** - Stores shipment header information, including delivery IDs, statuses, and shipping dates. - Links to **OE_ORDER_HEADERS** and **WSH_TRIPS** for order and transportation data. 2. **WSH_DELIVERY_DETAILS** - Contains line-level shipping details such as items, quantities, and source documents (e.g., sales orders). - References **OE_ORDER_LINES** and **MTL_SYSTEM_ITEMS**. 3. **WSH_TRIPS** - Manages freight movements, including carrier assignments and trip schedules. - Integrates with **WSH_FREIGHT_COSTS** for freight calculations. 4. **WSH_NEW_DELIVERIES** - Temporary table used during pick release to stage delivery data before confirmation. 5. **WSH_PICKING_BATCHES** - Tracks batch-level picking activities, linking to **WSH_DELIVERY_ASSIGNMENTS**. 6. **WSH_SHIPPING_PARAMETERS** - Stores system-wide shipping rules, such as default carriers and packing rules. 7. **WSH_FREIGHT_COSTS** - Captures freight charges, including rate calculations and carrier-specific fees. ### **Technical and Functional Significance** - **Data Flow**: The tables facilitate order-to-shipment workflows, ensuring seamless integration between Order Management and Shipping Execution. - **Customization**: Developers and DBAs use this metadata to extend WSH functionality, such as adding custom fields or reports. - **Performance**: Proper indexing on columns like DELIVERY_ID or TRIP_ID is critical for large-scale shipping operations. ### **Integration with Other Modules** - **Order Management (OM)**: WSH_DELIVERY_DETAILS references OE_ORDER_LINES to fulfill sales orders. - **Inventory (INV)**: Pick-confirmed shipments update MTL_MATERIAL_TRANSACTIONS. - **Transportation (WSM)**: WSH_TRIPS integrates with freight cost engines. ### **Conclusion** The WSH_Tables.html file serves as a technical reference for Oracle EBS implementers, detailing the schema underpinning shipping processes. Understanding these tables is essential for troubleshooting, customization, and performance tuning in WSH deployments for versions 12.1.1 and 12.2.2.