Search Results op_cust_shp




Overview
Explore in AI Chat

Overview

The OP_CUST_SHP table is a core data object within the Oracle E-Business Suite (EBS) Process Manufacturing Logistics (GML) module. It serves as a master repository for defining and storing customer-specific shipping preferences. Its primary role is to establish the preferred relationship between a customer, a warehouse, and the associated shipping carrier (shipper) and method. This configuration is critical for automating and enforcing logistics rules during the order fulfillment and shipping processes in a manufacturing environment, ensuring shipments align with customer agreements and operational capabilities.

Key Information Stored

The table's structure centers on the unique combination of a customer, warehouse, shipping class, method, and carrier. Its primary key is the system-generated CUSTSHIP_ID. The defining business key columns, which form a unique constraint (OP_CUST_SHP_U1), are CUST_ID (customer), WHSE_CODE (warehouse/ship-from location), ICSHIP_CLASS (shipping class), SHIP_MTHD (shipping method), and SHIPPER_CODE (carrier). This structure allows for granular control, enabling different shipping preferences for the same customer across different warehouses or product classes. The table also includes a TEXT_CODE column, linked to OP_TEXT_HDR, for storing associated notes or instructions.

Common Use Cases and Queries

The primary use case is during sales order shipping transaction processing, where the system references OP_CUST_SHP to default and validate the shipper and method. Common reporting and query scenarios include auditing customer shipping agreements and troubleshooting fulfillment issues. A typical query to retrieve all preferred shipping rules for a specific customer would be:

  • SELECT c.cust_name, w.whse_name, s.shipper_name, m.ship_mthd_desc, cs.* FROM gml.op_cust_shp cs, op_cust_mst c, ic_whse_mst w, op_ship_mst s, op_ship_mth m WHERE cs.cust_id = c.cust_id AND cs.whse_code = w.whse_code AND cs.shipper_code = s.shipper_code AND cs.ship_mthd = m.ship_mthd AND c.cust_id = :p_cust_id;

Another common pattern is to identify the default shipper for a customer-warehouse combination, which is essential for setting up automatic shipment documentation.

Related Objects

OP_CUST_SHP is a central table with numerous foreign key relationships to other master data entities, as documented in the ETRM. Key dependencies include:

  • OP_CUST_MST: The master customer table; validates the CUST_ID.
  • IC_WHSE_MST: The warehouse master; validates the WHSE_CODE.
  • OP_SHIP_MST & OP_SHIP_MTH: Master tables for valid carriers and shipping methods.
  • IC_SHIP_CLS: The shipping class master.
  • OP_TEXT_HDR: Stores optional descriptive text associated with the shipping rule.

This network of relationships ensures data integrity and that shipping preferences are built upon valid, active master data records within the logistics and order management footprint.