Search Results aso_bi_line_ids

Overview

ASO_BI_LINE_IDS is a table in the ASO (Order Capture) product module of Oracle E-Business Suite, residing in the ASO schema. It is a supporting BI (business intelligence) staging/identifier table used in the Oracle Quoting and Order Capture flow. Its documented structure at ETRM 12.1.1 contains 6 columns and it is classified as VALID across 12.1.1 and 12.2.2. The mined ETRM documentation for this object is limited: the description field is sparse, and the primary documented relationship is a foreign key from ASO_BI_LINE_IDS.QUOTE_HEADER_ID to ASO_QUOTE_HEADERS_ALL.

From a Data Vault modeling perspective, the heuristic classification returned by the ETRM FK mining is standalone. The table is not strictly a hub, link, or satellite in the classic sense, but it best approximates a link-plus-satellite hybrid — it carries business keys (QUOTE_NUMBER, quote line identifiers) along with descriptive/versioning attributes (MAX_QUOTE_VERSION, QUOTE_CREATION_DATE, BATCH_ID) and a FK back to the quote header hub. It should be treated as a modeling suggestion rather than a hard rule, since the extraction is heuristic.

Key Information Stored

The documented physical schema exposes six columns. The most significant are:

• QUOTE_HEADER_ID — the foreign key to ASO_QUOTE_HEADERS_ALL; the primary linkage between this identifier table and the quote header entity. This is the strongest business-key candidate for joining.
• QUOTE_NUMBER — the user-facing quote number, a business-key candidate commonly exposed in reporting and lookups.
• QUOTE_LINE_ID — the quote line identifier; the natural join to ASO_QUOTE_LINES_ALL and the working surrogate for line-level BI.
• MAX_QUOTE_VERSION — captures the maximum version number for the quote, used to identify the current/most recent version of the quote in a versioned model.
• QUOTE_CREATION_DATE — the creation date of the quote header; useful for time-based partitioning, aging, and currency-of-data checks.
• BATCH_ID — a batch identifier that groups rows processed together; typically populated by concurrent BI extraction or refresh programs and used for purge/rerun logic.

The table has no documented surrogate primary key column in the ETRM extract; the row identity is effectively composite across QUOTE_HEADER_ID/QUOTE_LINE_ID/BATCH_ID combinations.

Common Use Cases and Queries

This table is most often used as a lightweight bridge between quote headers and their lines for BI extracts, refreshes, and delta processing keyed by BATCH_ID. Typical reporting scenarios include retrieving the latest version of a quote line, identifying lines not yet extracted into a downstream data warehouse, and reconciling quote header counts against line counts.

Representative SQL patterns:

• Header-to-line join: SELECT b.QUOTE_NUMBER, b.QUOTE_LINE_ID, h.QUOTE_NAME FROM ASO_BI_LINE_IDS b, ASO_QUOTE_HEADERS_ALL h WHERE b.QUOTE_HEADER_ID = h.QUOTE_HEADER_ID;
• Latest-version filter: SELECT QUOTE_LINE_ID, MAX_QUOTE_VERSION FROM ASO_BI_LINE_IDS WHERE MAX_QUOTE_VERSION = (SELECT MAX(MAX_QUOTE_VERSION) FROM ASO_BI_LINE_IDS);
• Batch-based delta: SELECT BATCH_ID, COUNT(*) FROM ASO_BI_LINE_IDS GROUP BY BATCH_ID;

Related Objects

• ASO_QUOTE_HEADERS_ALL — parent of ASO_BI_LINE_IDS via QUOTE_HEADER_ID; the principal FK target and join source.
• ASO_QUOTE_LINES_ALL — the line-level detail table joined through QUOTE_LINE_ID.
• ASO_QUOTE_HEADERS — header view commonly used for reporting joins.
• ASO_QUOTE_LINES — line view counterpart for BI queries.
• ASO_QUOTE_HEADERS_ALL_B — the base-table variant used in multi-org org_id contexts.
• ASO_QUOTE_LINES_ALL_B — corresponding line base table.

Because the ETRM documentation for this object is limited and the description is sparse, developers should validate actual column semantics against a live 12.1.1 or 12.2.2 instance before relying on this table for production reporting.