Results for “charge_amount”

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

Overview

ASO_FREIGHT_CHARGES is a transaction table in the ASO (Order Capture) product family of Oracle E-Business Suite, valid in both 12.1.1 and 12.2.2. It stores the charge amount or amounts assessed against each quote shipment, categorized by freight charge type. In the quoting and order capture flow, a single quote may be split across multiple shipments, and each shipment can attract several distinct freight charges — for example fuel surcharges, handling fees, or carrier-specific freight lines. This table captures those amounts at the shipment level, making it the authoritative source for freight cost detail associated with a quote.

The object is owned by the ASO schema and is documented in ETRM with 31 columns. Based on the foreign key structure mined from the metadata, the heuristic Data Vault classification is satellite-leaning: the table primarily records descriptive and measurable attributes (charge amounts, audit columns, descriptive flexfields) that depend on parent keys rather than acting as an independent hub or a pure many-to-many link. This classification is a modeling suggestion only and should be validated against the actual business rules in the implementation.

Key Information Stored

The documented primary key is ASO_FREIGHT_CHARGES_PK, defined on FREIGHT_CHARGE_ID. A unique index, ASO_FREIGHT_CHARGES_U1, also exists on FREIGHT_CHARGE_ID, confirming it as the surrogate primary key and the unique business identifier for each charge row. The most significant columns are:

• FREIGHT_CHARGE_ID — surrogate primary key uniquely identifying each freight charge record.
• QUOTE_SHIPMENT_ID — foreign key to ASO_SHIPMENTS, tying the charge to a specific shipment within the quote.
• FREIGHT_CHARGE_TYPE_ID — foreign key to SO_FREIGHT_CHARGE_TYPES, classifying the nature of the charge.
• CHARGE_AMOUNT — the monetary value of the freight charge assessed for the shipment.
• SECURITY_GROUP_ID — foreign key to FND_SECURITY_GROUPS, supporting multi-org or data security partitioning.
• OBJECT_VERSION_NUMBER — optimistic locking column used by the application to detect concurrent updates.
• REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE — concurrent program and audit context identifying the process that created or last updated the row.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — standard WHO audit columns.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15 — descriptive flexfield columns available for customer-specific extensions.

Common Use Cases and Queries

Typical scenarios include reconciling quoted freight against carrier invoices, reporting freight cost per shipment, and auditing charge-type distribution across quotes. A common query joins shipments to charges by shipment identifier:

• SELECT afc.freight_charge_id, afc.quote_shipment_id, afc.freight_charge_type_id, afc.charge_amount FROM aso.aso_freight_charges afc WHERE afc.quote_shipment_id = :p_shipment_id;
• Aggregate freight per charge type: SELECT freight_charge_type_id, SUM(charge_amount) FROM aso.aso_freight_charges GROUP BY freight_charge_type_id;
• Join to ASO_SHIPMENTS and SO_FREIGHT_CHARGE_TYPES to produce a readable report of shipment, charge description, and amount.

The user search term "freight_charge_id" maps directly to the primary key, so lookups and joins should use this column as the fastest access path via the PK and unique index.

Related Objects

• ASO_SHIPMENTS — parent table referenced by QUOTE_SHIPMENT_ID; defines the quote shipment to which charges apply.
• SO_FREIGHT_CHARGE_TYPES — reference table for FREIGHT_CHARGE_TYPE_ID; supplies charge type names and behavior.
• FND_SECURITY_GROUPS — referenced by SECURITY_GROUP_ID for data security partitioning.
• ASO_QUOTE_HEADERS / ASO_QUOTE_LINES — the broader quote structure from which shipments and their charges derive.
• Order Capture APIs — the quoting APIs that create and maintain shipment records and their associated freight charge rows.