Search Results wsh_freight_costs

The WSH_FREIGHT_COSTS table in Oracle E-Business Suite (EBS) 12.1.1 or 12.2.2 is a critical data structure within the Shipping Execution (WSH) module, responsible for storing freight cost-related information associated with shipments and deliveries. This table plays a pivotal role in freight cost calculation, allocation, and reporting, ensuring accurate financial tracking and logistics management. Below is a detailed analysis of its structure, functionality, and integration within Oracle EBS. ### **Table Overview** The WSH_FREIGHT_COSTS table stores transactional data related to freight charges incurred during shipping operations. It captures cost details such as freight rates, carrier charges, accessorial fees, and allocated amounts across shipments or delivery lines. This table is primarily utilized by the Shipping Execution module but integrates with other EBS components like Order Management (OM), Inventory (INV), and Accounts Payable (AP). ### **Key Columns and Data Structure** The table consists of several important columns that define freight cost attributes: - FREIGHT_COST_ID: Primary key, uniquely identifying each freight cost record. - SHIPMENT_ID: References the shipment in WSH_NEW_DELIVERIES to which the cost applies. - DELIVERY_ID: Links to a specific delivery if costs are allocated at that level. - CHARGE_TYPE: Specifies the type of freight charge (e.g., base freight, fuel surcharge, handling fee). - CARRIER_ID: Identifies the carrier responsible for the shipment, linked to WSH_CARRIERS. - CURRENCY_CODE: The currency in which the cost is recorded. - AMOUNT: The monetary value of the freight cost. - STATUS: Indicates whether the cost is pending, approved, or invoiced. - CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY: Audit columns for tracking record changes. ### **Functional Role in Oracle EBS** 1. **Freight Cost Calculation**: The table stores computed freight costs based on carrier rate schedules, shipment weight/volume, and accessorial charges. 2. **Cost Allocation**: Enables distribution of freight costs across multiple deliveries or order lines, supporting proration logic. 3. **Integration with Financials**: Costs flow to Accounts Payable for carrier invoice matching and to General Ledger (GL) for accounting entries. 4. **Reporting and Analytics**: Provides data for freight expense analysis, carrier performance, and cost accruals. ### **Integration with Other Modules** - **Order Management (OM)**: Freight costs may be estimated during order entry and later updated in WSH_FREIGHT_COSTS upon shipment confirmation. - **Inventory (INV)**: Used for landed cost tracking if freight is part of item cost. - **Accounts Payable (AP)**: Freight costs are matched against carrier invoices via the AP_INVOICES interface. ### **Technical Considerations** - **Indexes**: Key indexes on SHIPMENT_ID, DELIVERY_ID, and FREIGHT_COST_ID optimize query performance. - **API Usage**: Oracle provides public APIs (e.g., WSH_FREIGHT_COSTS_PUB) to create, update, or query freight costs programmatically. - **Data Retention**: Historical freight cost data is retained for compliance and audit purposes, though archival policies may apply. ### **Customization and Extensions** Organizations often extend the table with custom columns (e.g., ATTRIBUTE1-15) to capture additional cost attributes or integrate with third-party logistics systems. ### **Conclusion** The WSH_FREIGHT_COSTS table is a cornerstone of Oracle EBS Shipping Execution, ensuring accurate freight cost management from shipment creation to financial settlement. Its design supports complex logistics workflows while maintaining integration with broader EBS functionalities, making it indispensable for organizations with sophisticated shipping and financial requirements.