Results for “so_freight_charges”

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

Overview

The OE.SO_FREIGHT_CHARGES table, documented in the ETRM reference for Oracle EBS 12.1.1 and 12.2.2, stores freight charge records associated with the outbound logistics and order fulfillment flow. Freight charges represent the monetary amounts assessed against picking headers, deliveries, packed containers, or picking line details during the warehouse execution process. The table resides in the OE (Order Entry) schema and holds 50 documented columns in the 12.2.2 physical schema, making it a moderately wide transactional entity.

The heuristic Data Vault classification mined from the foreign key structure is link. This reflects the table's role as an associative construct that connects a freight charge type to one or more logistics entities — picking headers, deliveries, containers, or picking line details — while carrying descriptive and financial attributes such as amount and currency. Modelers should treat SO_FREIGHT_CHARGES as a link bridging the freight charge type dimension and the fulfillment execution entities, with a satellite carrying the amount, currency, and conversion attributes.

Key Information Stored

The surrogate primary key is FREIGHT_CHARGE_ID, enforced by the SO_FREIGHT_CHARGES_PK constraint and also backed by the unique index SO_FREIGHT_CHARGES_U1 on the same column. No separate business-key column is documented; FREIGHT_CHARGE_ID serves as both the technical and the unique identifier in the metadata.

The most significant columns include:

• FREIGHT_CHARGE_ID — Primary key and unique identifier for each freight charge record.
• FREIGHT_CHARGE_TYPE_ID — Foreign key to SO_FREIGHT_CHARGE_TYPES, classifying the nature of the charge.
• AMOUNT — The monetary value of the freight charge.
• CURRENCY_CODE — The currency in which the amount is expressed.
• CONVERSION_RATE, CONVERSION_DATE, CONVERSION_TYPE_CODE — Currency conversion attributes for reporting in a functional currency.
• PICKING_HEADER_ID — Foreign key to SO_PICKING_HEADERS_ALL, tying the charge to a picking header.
• DELIVERY_ID — Foreign key to WSH_DELIVERIES, linking the charge to a delivery.
• CONTAINER_ID — Foreign key to WSH_PACKED_CONTAINERS, associating the charge with a packed container.
• PICKING_LINE_DETAIL_ID — Foreign key to SO_PICKING_LINE_DETAILS, associating the charge with a picking line.
• INVOICE_STATUS and INTERCO_INVOICE_STATUS — Indicators tracking whether the charge has been invoiced, including the intercompany invoicing path.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — Standard audit columns.
• CONTEXT and ATTRIBUTE1–15 — Descriptive flexfield columns.
• AC_ATTRIBUTE_CATEGORY and AC_ATTRIBUTE1–15 — Additional attribute flexfield columns.

Common Use Cases and Queries

SO_FREIGHT_CHARGES is typically queried when reconciling freight costs against deliveries, auditing invoice status, or reporting freight expense by type and currency. A common pattern joins to SO_FREIGHT_CHARGE_TYPES for charge descriptions and to WSH_DELIVERIES for shipment context:

• Freight charges by delivery: SELECT fc.freight_charge_id, fc.amount, fc.currency_code, d.delivery_id FROM oe.so_freight_charges fc, wsh_deliveries d WHERE fc.delivery_id = d.delivery_id;
• Uninvoiced freight charges: filter on WHERE invoice_status IS NULL OR invoice_status != 'INVOICED' to surface charges pending billing.
• Freight cost by charge type: aggregate SUM(amount) grouped by freight_charge_type_id, converting via conversion_rate.
• Container-level freight audit: join container_id to WSH_PACKED_CONTAINERS to verify charges against packed shipments.

Because the table supports multiple foreign keys to distinct fulfillment entities, reports should clarify which association level (header, delivery, container, or line detail) applies to avoid double counting.

Related Objects

• SO_FREIGHT_CHARGE_TYPES — referenced via FREIGHT_CHARGE_TYPE_ID; defines the classification of each charge.
• SO_PICKING_HEADERS_ALL — referenced via PICKING_HEADER_ID; the picking header owning the charge.
• WSH_DELIVERIES — referenced via DELIVERY_ID; the delivery associated with the charge.
• WSH_PACKED_CONTAINERS — referenced via CONTAINER_ID; the container associated with the charge.
• SO_PICKING_LINE_DETAILS — referenced via PICKING_LINE_DETAIL_ID; the picking line detail associated with the charge.

These five foreign key relationships define the table's integration points across Order Entry and Warehouse Shipping execution, and they drive the link-classified structure of the entity.