Results for “aso_shipments_u1”

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

Overview

ASO.ASO_SHIPMENTS is a transactional table in the Oracle E-Business Suite Order-to-Cash and Advanced Supply Chain foundation, owned by the ASO (Oracle Quoting / Order Capture) schema. It stores shipping information associated with a quote managed by Oracle Quoting. Shipping details may be recorded at the quote header level, in which case QUOTE_LINE_ID is null and the information applies uniformly to every line, or at the quote line level, where each line carries its own shipping attributes. The table additionally supports line-quantity-level granularity: when the shipped QUANTITY stored in ASO_SHIPMENTS differs from the quantity recorded in ASO_QUOTE_LINES_ALL, the shipment record provides the authoritative breakdown.

The table resides in the APPS_TS_TX_DATA tablespace with indexes in APPS_TS_TX_IDX, and the documented physical schema for ETRM 12.2.2 lists 61 columns. ASO_SHIPMENTS participates in the standard EBS multi-org and audit conventions, carrying WHO columns and SECURITY_GROUP_ID for multi-tenancy in hosted deployments. Based on the foreign key profile mined from its relationship structure, the object is heuristic-classified as hub-leaning in a Data Vault model. This classification is a modeling suggestion: SHIPMENT_ID functions as the stable surrogate business key, while the surrounding descriptive columns (dates, methods, carrier codes, instructions) are candidate satellite attributes. The primary key and unique index ASO_SHIPMENTS_U1 are both defined on SHIPMENT_ID.

Key Information Stored

The single-column unique index ASO_SHIPMENTS_U1 on SHIPMENT_ID is the documented unique constraint; SHIPMENT_ID is the surrogate primary key exposed to the application layer and is referenced by numerous dependent tables as a foreign key. The most operationally significant columns are:

• SHIPMENT_ID — Surrogate identifier for the shipment record; primary key and target of ASO_SHIPMENTS_U1.
• QUOTE_HEADER_ID — Foreign key to ASO_QUOTE_HEADERS_ALL; identifies the parent quote and is the leading column of the ASO_SHIPMENTS_N1 index.
• QUOTE_LINE_ID — Foreign key to ASO_QUOTE_LINES_ALL; null for header-level shipping, populated for line-level shipping.
• SHIP_TO_PARTY_ID / SHIP_TO_PARTY_SITE_ID / SHIP_TO_CUST_PARTY_ID / SHIP_TO_CUST_ACCOUNT_ID — Ship-to location, site, party, and customer account references, backed by the N5 and MIS_ASO_SHIPMENTS_N4 indexes.
• QUANTITY / RESERVED_QUANTITY / RESERVATION_ID — Shipped and reserved quantities, with RESERVATION_ID linking to MTL_RESERVATIONS for inventory reservation traceability.
• PROMISE_DATE / REQUEST_DATE / SCHEDULE_SHIP_DATE — Scheduling and commitment dates used for promise and availability calculations.
• SHIP_METHOD_CODE / FREIGHT_TERMS_CODE / FREIGHT_CARRIER_CODE / FOB_CODE — Shipping and freight descriptors.
• SHIPMENT_PRIORITY_CODE / DEMAND_CLASS_CODE — Order scheduling and classification controls.
• SHIP_SET_ID — Groups shipment lines into a ship set; indexed via ASO_SHIPMENTS_N4.
• ORDER_LINE_ID — Links the shipment to the resulting order line; indexed via ASO_SHIPMENTS_N3.

Common Use Cases and Queries

The principal use cases are quoting shipment enquiry, freight and tax determination for a shipment, and order conversion traceability. A typical header/line join retrieves shipments for a given quote:

SELECT s.shipment_id, s.quote_line_id, s.quantity, s.promise_date, s.ship_method_code FROM aso.aso_shipments s WHERE s.quote_header_id = :header_id

Line-level enquiries filter on QUOTE_LINE_ID (supported by ASO_SHIPMENTS_N1 and _N2) to isolate per-line shipping, while ship-set grouping uses SHIP_SET_ID. For order conversion auditing, joining ORDER_LINE_ID to order management tables reconciles quoted shipments against booked order lines. The QUANTITY-versus-quote-line comparison is the standard pattern for detecting split or partial shipments. Extended reporting on freight, tax, and pricing is handled through dependent tables such as ASO_FREIGHT_CHARGES, ASO_TAX_DETAILS, and ASO_PAYMENTS, which carry QUOTE_SHIPMENT_ID.

Related Objects

• ASO_QUOTE_HEADERS_ALL — Parent quote header, joined via QUOTE_HEADER_ID.
• ASO_QUOTE_LINES_ALL — Parent quote line, joined via QUOTE_LINE_ID.
• ASO_FREIGHT_CHARGES, ASO_TAX_DETAILS, ASO_PAYMENTS, ASO_PRICE_ADJUSTMENTS — Referencing tables keyed by QUOTE_SHIPMENT_ID.
• HZ_PARTIES, HZ_PARTY_SITES — Customer and site references for ship-to resolution.
• MTL_RESERVATIONS — Inventory reservation linkage via RESERVATION_ID.
• RA_CUSTOMER_TRX_ALL — Receivables transactions carrying SHIPMENT_ID for revenue linkage.
• ASO_QUOTE_PARTIES, ASO_QUOTE_LINE_ATTRIBS_EXT, CS_LINE_INST_DETAILS — Downstream references for parties, attributes, and service details.