Search Results aso_bi_quote_ids

Overview

ASO_BI_QUOTE_IDS is a table in the ASO (Order Capture) module of Oracle E-Business Suite, residing in the ASO schema. Its naming convention — the "BI" prefix combined with the suffix "_IDS" — indicates that it is a Business Intelligence staging or extract table, designed to expose key identifiers and scalar attributes of Oracle Quoting records for use by downstream reporting, data warehousing, or ETL processes. Rather than storing full transactional detail, the table holds a flattened, denormalized projection of quote headers, which makes it well suited for high-volume extraction jobs that feed discovery tools, custom reports, or third-party analytics platforms.

The table has been classified heuristically as a standalone satellite. In Data Vault modeling terms, this suggests treating ASO_BI_QUOTE_IDS as a satellite (or an extract derived from a satellite) attached to a business key representing the quote. Because it is documented as referencing ASO_QUOTE_HEADERS_ALL's QUOTE_HEADER_ID, the natural hub candidate is the quote header itself, and this table functions as a descriptive companion carrying aggregate or point-in-time attributes about that header. Its standalone classification reflects that no downstream tables reference it via a foreign key.

Key Information Stored

The documented physical schema in ETRM 12.1.1 consists of six columns. The most significant are:

• QUOTE_HEADER_ID — The surrogate primary key for a quote, inherited as a foreign key referencing ASO_QUOTE_HEADERS_ALL.QUOTE_HEADER_ID. This is the join spine to the core Quoting tables.
• QUOTE_NUMBER — The user-visible business identifier of the quote, commonly used in reports and searches as the human-readable key rather than the internal numeric ID.
• MAX_QUOTE_VERSION — The highest version number reached by the quote, enabling version-aware reporting without navigating the full version history table.
• QUOTE_CREATION_DATE — The date on which the quote was created, supporting time-series and aging analysis.
• BATCH_ID — An extract or processing batch identifier, indicating that records are populated by a batch job. This column is key to controlling incremental extracts and tracing loads.
• QUOTE_AMOUNT_FIRST — A stored monetary amount associated with the quote (typically the first or initial amount), supporting financial aggregation in BI extracts.

QUOTE_HEADER_ID serves as the surrogate primary key, while QUOTE_NUMBER is the principal business-key candidate. Together with BATCH_ID and MAX_QUOTE_VERSION, these columns form a useful composite for identifying the latest extracted state of a given quote.

Common Use Cases and Queries

Typical uses include quote activity reporting, version and pipeline analysis, and extract-driven dashboards. A frequent pattern joins the table back to the Quoting header and lines to enrich the flattened extract with customer and line-level detail:

• Identify the latest version of every quote: filter on MAX_QUOTE_VERSION in a window or correlated subquery.
• Trend quote creation volume by month using QUOTE_CREATION_DATE.
• Trace extract loads and reprocess failures by grouping on BATCH_ID.
• Aggregate QUOTE_AMOUNT_FIRST for pipeline or weighted-value reporting.

A representative query for quote aging is:

SELECT q.quote_number, q.max_quote_version, q.quote_creation_date, q.quote_amount_first FROM aso.aso_bi_quote_ids q WHERE q.quote_creation_date >= :start_date ORDER BY q.quote_creation_date;

A version-aware variant joins to ASO_QUOTE_HEADERS_ALL on QUOTE_HEADER_ID to retrieve the customer and status derived from the base header, since those fields are not stored in the extract itself.

Related Objects

• ASO_QUOTE_HEADERS_ALL — Joined on QUOTE_HEADER_ID. The primary reference target and the source of the base quote identity; supplies customer, status, and org context absent from the extract.
• ASO_QUOTE_LINES_ALL — Joined on QUOTE_HEADER_ID to bring line-level detail alongside the header extract.
• ASO_QUOTE_HEADERS — Alternate or versioned header view commonly used with the header ID for status lookups.
• ASO_QUOTE_HEADER_VERSIONS — Related version structure that contextualizes MAX_QUOTE_VERSION.
• OE_ORDER_HEADERS_ALL — Referenced downstream when a quote converts to an order, useful for conversion-rate reporting.
• ASO_QUOTE_HEADERS_ALL_V — A reporting view that can supplement extract queries with additional header attributes.

Because the table is classified as standalone, its dependencies flow inward: it references ASO_QUOTE_HEADERS_ALL, but no documented foreign keys point to it. Applications and BI extracts that consume it should be treated as external dependents rather than database-enforced children.