Results for “quote_header_id”

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

Overview

IBE_ACTIVE_QUOTES_ALL is a transactional reference table in the IBE (iStore) product module of Oracle E-Business Suite, and is present and VALID in both the 12.1.1 and 12.2.2 releases. Its documented purpose is to track the active carts (quotes) belonging to a given party and customer account. In an iStore implementation, shoppers frequently build quotations and place them in a saved or in-progress state; this table provides the lightweight pointer record that links a non-persistent shopping session to the underlying quote and, optionally, order header structures. It therefore acts as an index of "currently open" quoting activity rather than a repository of quote line content or pricing detail, which resides in the ASO and QP schemas.

From a Data Vault modeling perspective, the heuristic classification mined from the foreign-key structure is a link. This is a reasonable modeling suggestion: the table sits between business hubs representing the party (HZ_PARTIES), the customer account (HZ_CUST_ACCOUNTS), and the quote header (ASO_QUOTE_HEADERS_ALL), capturing the association between them at a point in time. The descriptive attributes carried on the link (currency, record type, object version) behave much like link-level context rather than a full satellite.

Key Information Stored

The table is defined in the IBE schema with 15 columns. The surrogate primary key is ACTIVE_QUOTE_ID, enforced by the IBE_ACTIVE_QUOTES_ALL_PK constraint. Two unique indexes identify business-key candidates:

• ACTIVE_QUOTE_ID — surrogate primary key that uniquely identifies each active cart record; also enforced by unique index IBE_ACTIVE_QUOTES_ALL_U1.
• CUST_ACCOUNT_ID and PARTY_ID — the customer account and party that own the active quote. Together with ORG_ID, RECORD_TYPE, and CURRENCY_CODE they form the composite business key enforced by unique index IBE_ACTIVE_QUOTES_ALL_U2.
• QUOTE_HEADER_ID — foreign key to ASO_QUOTE_HEADERS_ALL, linking the active-cart pointer to the actual quotation header.
• ORDER_HEADER_ID — references the order header once a quote is converted or reserved against an order.
• ORG_ID — operating unit context, essential for multi-org security and reporting.
• CURRENCY_CODE — currency of the active quote, part of the business key and used to disambiguate carts sharing the same party/account.
• RECORD_TYPE — discriminator distinguishing record categories for the active cart; also part of the business key.
• OBJECT_VERSION_NUMBER — optimistic locking column used by the iStore middle tier.
• SECURITY_GROUP_ID — foreign key to FND_SECURITY_GROUPS, supporting data-level security partitioning.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard Oracle WHO columns for audit and concurrency.

Common Use Cases and Queries

The most common operational need is to determine whether a given customer currently has an active cart, which iStore uses to resume saved sessions rather than creating duplicates. A typical diagnostic query joins the table to the quote header and party:

SELECT aq.active_quote_id, aq.party_id, aq.cust_account_id,
       aq.quote_header_id, aq.currency_code, aq.record_type
  FROM ibe.ibe_active_quotes_all aq
 WHERE aq.cust_account_id = :cust_account_id
   AND aq.org_id = :org_id;

Reporting use cases include counts of concurrently open carts per operating unit, aged analysis of active carts that have not advanced to an order, and reconciliation of QUOTE_HEADER_ID values against ASO_QUOTE_HEADERS_ALL to detect orphaned pointers left behind when a quote is cancelled or converted. Support teams also use the table to identify carts whose OBJECT_VERSION_NUMBER no longer synchronizes with the middle tier after a failed checkout.

Related Objects

• HZ_PARTIES — joined on IBE_ACTIVE_QUOTES_ALL.PARTY_ID to resolve party identity and name.
• HZ_CUST_ACCOUNTS — joined on CUST_ACCOUNT_ID to resolve the customer account and account number.
• ASO_QUOTE_HEADERS_ALL — joined on QUOTE_HEADER_ID; the header table holding quote-level attributes such as status, dates, and totals.
• FND_SECURITY_GROUPS — joined on SECURITY_GROUP_ID for data-security context.
• OE_ORDER_HEADERS_ALL — related through ORDER_HEADER_ID when an active quote is converted into an order.
• IBE_ACTIVE_QUOTES_ALL_PK / _U1 / _U2 — the primary and unique constraints that enforce record uniqueness and support indexed access paths.

Collectively these objects allow iStore to maintain a secure, multi-org-aware registry of in-progress carts while keeping heavy quote content in the ASO tables.