Search Results ar_inv_api_lines_gt

Overview

AR_INV_API_LINES_GT is a global temporary table (GT) in the Receivables (AR) schema of Oracle E-Business Suite. It serves as a transient staging area used by the AutoInvoice interface to hold invoice line records before they are validated, imported, and written permanently to the transactional base tables. In release 12.1.1 and 12.2.2 this table is populated exclusively during the execution of the AutoInvoice Master Program and AutoInvoice Import Program, and its contents are visible only within the session that inserted them. Once the import completes, the rows are consumed and no longer required; the table is effectively a working buffer rather than a persistent data store.

From an ETRM heuristic Data Vault modeling perspective, the object is classified as standalone. No hub, link, or satellite role is asserted, which is appropriate for a temporary interface table that does not itself persist an enduring business key. It is best understood as a staging structure whose individual columns map onto the attributes of the downstream line-level transaction entity.

Key Information Stored

The table exposes 17 documented columns in the 12.2.2 schema. The most significant of these are summarized below.

• TRX_HEADER_ID — Identifier tying the staged line to its parent invoice header. It is documented as referencing PN_VAR_TRX_HEADERS_ALL and is a candidate join key during import processing.
• TRX_LINE_ID — Identifier of the target line record, documented as referencing CN_TRX_LINES_ALL. Together with TRX_HEADER_ID it establishes the parent-child relationship of the interface data.
• LINK_TO_TRX_LINE_ID — Reference used to link related line records, supporting adjustments and line-level associations.
• LINE_NUMBER — Ordinal position of the line within the transaction, used for sequencing and display.
• LINE_TYPE — Classifies the nature of the line, distinguishing the various AutoInvoice line categories.
• INVENTORY_ITEM_ID — Inventory item being invoiced, when the line originates from an order or shipment.
• DESCRIPTION — Free-text description carried into the invoice line.
• QUANTITY_ORDERED / QUANTITY_INVOICED — Quantity measures associated with the line, used for quantity-based pricing and reconciliation.
• UNIT_STANDARD_PRICE / UNIT_SELLING_PRICE — Standard and selling unit prices, the basis of extended line amount calculation.
• AMOUNT — Extended amount for the line, the principal financial measure written downstream.
• SALES_ORDER / SALES_ORDER_LINE / SALES_ORDER_DATE — Order reference and date attributes carried from the source order system.
• REASON_CODE — Adjustment or credit reason code where applicable.
• ACCOUNTING_RULE_ID — Revenue recognition rule identifier applied to the line.

The ETRM metadata does not document a surrogate primary key or unique index on this table, consistent with its role as an unkeyed temporary staging object; business-key candidates such as TRX_HEADER_ID combined with LINE_NUMBER are logical rather than enforced.

Common Use Cases and Queries

The principal use case is diagnostic. Because the table holds rows only for the duration of the AutoInvoice session, it is queried during debugging of import failures, rejected lines, and pricing discrepancies. A typical query retrieves staged lines for a specific header:

SELECT trx_header_id, line_number, line_type, inventory_item_id,
  quantity_ordered, unit_selling_price, amount
FROM ar.ar_inv_api_lines_gt
WHERE trx_header_id = :p_header_id
ORDER BY line_number;

Because the structure has no permanent key, results are most useful when correlated with the parent header identifiers used to load the data. Reporting against persistent Receivables tables — not this GT — is the correct approach for ongoing analysis; the GT is used only while the AutoInvoice request is running or within the same session that populated it.

Related Objects

• PN_VAR_TRX_HEADERS_ALL — referenced by TRX_HEADER_ID; supplies the header context for each staged line.
• CN_TRX_LINES_ALL — referenced by TRX_LINE_ID; the persistent line entity into which staged rows are ultimately written.
• RA_INTERFACE_LINES_ALL — the inbound interface table that feeds AutoInvoice and from which GT content is commonly derived.
• RA_CUSTOMER_TRX_ALL / RA_CUSTOMER_TRX_LINES_ALL — the final transaction tables populated after successful import.
• AR_INVOICE_API_PUB — the publicly documented API package that drives AutoInvoice processing against these structures.