Results for “op_ship_mth”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

OP_SHIP_MTH is a reference (master) table in the Oracle E-Business Suite Process Manufacturing Logistics module (GML). It stores the definitive list of shipping method codes that describe how goods are dispatched between parties — whether raw materials inbound to a process plant, intermediates moving between facilities, or finished goods shipped to customers. The table sits in the GML schema and is marked VALID in both Oracle EBS 12.1.1 and 12.2.2.

Shipping methods recorded here are attached to transactional and planning documents throughout the order and purchasing lifecycle, including sales orders, purchase orders, receipts, proposals, and release schedules. Because each of these documents carries a SHIP_MTHD column that points back to OP_SHIP_MTH, the table functions as a central code repository rather than a transactional record. In Data Vault terms, the heuristic classification suggests a hub-leaning object: its primary key (SHIP_MTHD) is the business key, and it is referenced by many downstream tables as an attribute source. Modelers should treat OP_SHIP_MTH as the hub for "shipping method" with the descriptive columns as satellite-eligible attributes.

Key Information Stored

The table contains 13 documented columns. The most operationally significant are:

• SHIP_MTHD — The primary key and business identifier for the shipping method code. This is the unique index OP_SHIP_MTH_PK and the value propagated to all referencing tables.
• MTHD_DESC1 and MTHD_DESC2 — Descriptive text for the method (e.g., "Ground Freight," "Air Express"). MTHD_DESC1 is generally the primary description; MTHD_DESC2 provides secondary context.
• SHIPPING_ROUTING — Indicates the routing or delivery path associated with the shipping method.
• PREFERRED_SHIPPER — A foreign key to OP_SHIP_MST identifying the default carrier or shipper for this method.
• TEXT_CODE — A foreign key to OP_TEXT_HDR, allowing long-form notes or instructions to be attached to the method.
• DELETE_MARK — Standard Oracle soft-delete flag (0 = active, 1 = logically deleted).
• TRANS_CNT — Transaction counter, used by Process Manufacturing for concurrency and audit tracking.
• Audit columns — CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, and LAST_UPDATE_LOGIN, which capture who created or modified each method and when.

There is no documented surrogate key separate from SHIP_MTHD; the code itself serves both as primary key and business key.

Common Use Cases and Queries

The most frequent scenario is validating or resolving a shipping method code during order or receipt processing. A typical lookup joins the shipping method to its description and preferred shipper:

• Resolving codes for reporting: SELECT s.SHIP_MTHD, s.MTHD_DESC1, m.SHIPPER_NAME FROM OP_SHIP_MTH s, OP_SHIP_MST m WHERE s.PREFERRED_SHIPPER = m.SHIPPER_CODE AND s.DELETE_MARK = 0;
• Listing all active methods for a picker: filter on DELETE_MARK = 0 and order by MTHD_DESC1.
• Auditing which transactional documents use a given method by joining downstream tables such as OP_ORDR_HDR or PO_ORDR_HDR on SHIP_MTHD.
• Finding methods with attached notes by joining OP_TEXT_HDR via TEXT_CODE.
• Identifying methods whose shipper changed by comparing LAST_UPDATE_DATE windows.

Related Objects

OP_SHIP_MTH participates in an extensive foreign-key network. The most significant related objects are:

• OP_SHIP_MST — Referenced via PREFERRED_SHIPPER; supplies shipper/carrier master details.
• OP_TEXT_HDR — Referenced via TEXT_CODE; stores long descriptive notes.
• OP_ORDR_HDR / OP_ORDR_DTL — Order header and detail records that carry SHIP_MTHD.
• OP_PRSL_HDR / OP_PRSL_DTL — Proposal header and detail records referencing the method.
• OP_RELS_SCH and OP_CUST_SHP — Release schedules and customer shipping records.
• PO_ORDR_HDR / PO_ORDR_DTL and PO_BPOS_HDR / PO_BPOS_DTL — Purchase order and blanket-order documents that reference the method.
• PO_RECV_HDR / PO_RECV_DTL and PO_RELS_SCH — Receiving and purchasing release-schedule records.

These relationships confirm that OP_SHIP_MTH is a foundational reference for shipping operations across both order management and procurement flows within Process Manufacturing Logistics.