Search Results po_lines_all




Overview
Explore in AI Chat

Overview

JAI_PO_QUOT_LINES_T is a table owned by the JA (Asia/Pacific Localizations) schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It stores intermediate and processed data used by a concurrent request that defaults tax information on purchasing documents linked to a quotation. In practice, the table functions as a staging and audit surface for the tax-defaulting process: rows are populated with the purchase order, line, and shipment identifiers that the concurrent program must evaluate, then enriched with pricing, unit of measure, assessable value, and processing outcome data. The presence of ERROR_FLAG, ERROR_MESSAGE, and PROCESSING_TIME columns confirms its role as a process-control and diagnostics table rather than a purely transactional entity.

Because the table is composed almost entirely of foreign key references to the core purchasing tables, the heuristic Data Vault classification is link. This suggests modeling JAI_PO_QUOT_LINES_T as a relationship (link) entity that connects purchasing header, line, and shipment hubs, with the remaining descriptive attributes (price override, UOM, assessable value, error state) potentially distributed to a satellite if a full Data Vault transformation were undertaken.

Key Information Stored

The table contains 17 documented columns. The most significant are the identifier and processing columns:

No surrogate primary key is explicitly documented in the provided metadata, though the combination of PO_HEADER_ID, PO_LINE_ID, and LINE_LOCATION_ID acts as a natural business key for identifying a unique line-level processing record.

Common Use Cases and Queries

The primary use case is monitoring and troubleshooting the tax-defaulting concurrent request. A common query joins the table to PO_LINES_ALL to identify lines that failed processing:

  • SELECT q.PO_LINE_ID, q.ERROR_FLAG, q.ERROR_MESSAGE FROM JA.JAI_PO_QUOT_LINES_T q WHERE q.ERROR_FLAG = 'Y';
  • SELECT q.PO_HEADER_ID, l.LINE_NUM, q.ASSESSABLE_VALUE FROM JA.JAI_PO_QUOT_LINES_T q, PO.PO_LINES_ALL l WHERE q.PO_LINE_ID = l.PO_LINE_ID;

Reporting scenarios include reconciling assessable values back to PO_LINES_ALL, auditing price overrides applied during tax defaulting, and measuring concurrent request throughput via PROCESSING_TIME.

Related Objects

The following objects are directly referenced through documented foreign keys:

  • PO_LINES_ALL — referenced twice, via PO_LINE_ID and FROM_LINE_ID; the central purchasing line table.
  • PO_HEADERS_ALL — referenced via PO_HEADER_ID and FROM_HEADER_ID; the purchasing document header.
  • PO_LINE_LOCATIONS_ALL — referenced via LINE_LOCATION_ID; the shipment-level purchasing record.

The concurrent request that populates this table, and any quotation-linked tax defaulting logic in the JA localizations, also depend on it. JOBS and standard purchasing APIs (such as PO_DOCUMENT_UPDATE_PVT) are typically invoked downstream once tax values are defaulted, though these are not directly documented in the metadata provided.