Search Results ar_inv_api_dist_gt




Overview
Explore in AI Chat

Overview

AR_INV_API_DIST_GT is a global temporary table (GT) in the Oracle Receivables (AR) schema that serves as an interface staging area for accounting distribution lines generated during invoice creation through the Receivables Invoice API. The table captures the distribution records that ultimately populate the accounting entries for a transaction, functioning as a transient work area during API execution. Rows are scoped to the session and are typically cleared per transaction after processing. In Oracle EBS 12.1.1 and 12.2.2, this object remains a VALID, documented table with a physical schema of 9 columns owned by the AR schema. Because the table is session-scoped, its contents are only meaningful during an active API call; it is not intended as a persistent reporting source.

From a Data Vault modeling perspective (heuristic classification mined from the foreign-key structure), AR_INV_API_DIST_GT is best treated as a standalone object. While it carries transaction-header and transaction-line references, the heuristic did not resolve it as a formal hub, link, or satellite.

Key Information Stored

The table stores the accounting distribution detail passed to or generated by the invoice API. The most significant columns are:

  • TRX_DIST_ID — surrogate primary key for the distribution record, uniquely identifying each row within the temporary table.
  • TRX_HEADER_ID — foreign key to the transaction header (PN_VAR_TRX_HEADERS_ALL), associating the distribution with a specific invoice or credit memo.
  • TRX_LINE_ID — foreign key to the transaction line (CN_TRX_LINES_ALL), tying the distribution to an individual line.
  • ACCOUNT_CLASS — the accounting class (for example, RECEIVABLE, REVENUE, TAX, FREIGHT) that determines the nature of the distribution.
  • AMOUNT — the entered-currency distribution amount.
  • ACCTD_AMOUNT — the accounted (ledger-currency) amount after conversion.
  • PERCENT — the percentage allocation applied to the distribution.
  • CODE_COMBINATION_ID — the accounting flexfield combination referencing the target Chart of Accounts account.
  • COMMENTS — free-text description or note attached to the distribution.

TRX_DIST_ID is the surrogate key; the combination of TRX_HEADER_ID, TRX_LINE_ID, and ACCOUNT_CLASS generally constitutes the business-key candidate that distinguishes distributions for a given line.

Common Use Cases and Queries

This object is primarily used during programmatic invoice creation, where the AR Invoice API reads staged distributions and writes them into the permanent Receivables distributions tables. Practical uses include debugging API failures, verifying accounting class coverage, and reconciling conveyed amounts against accounted amounts. A representative query pattern:

  • SELECT TRX_HEADER_ID, TRX_LINE_ID, ACCOUNT_CLASS, AMOUNT, ACCTD_AMOUNT, CODE_COMBINATION_ID FROM AR_INV_API_DIST_GT WHERE TRX_HEADER_ID = :p_header_id;
  • Aggregate distributions by accounting class to validate that revenue, tax, and receivable lines balance for a transaction.
  • Compare AMOUNT to ACCTD_AMOUNT to confirm currency conversion and spot exchange-rate behavior during interface processing.

Because the table is a global temporary table, query results are only available within the originating session and are valid only during the API invocation lifecycle.

Related Objects

The table integrates with the core Receivables transaction and accounting model through its documented foreign keys and associated distribution structures:

  • PN_VAR_TRX_HEADERS_ALL — joined via TRX_HEADER_ID to the transaction header.
  • CN_TRX_LINES_ALL — joined via TRX_LINE_ID to the transaction line.
  • AR_DISTRIBUTIONS_ALL — the permanent distribution table that ultimately receives processed rows.
  • RA_CUSTOMER_TRX_ALL — the customer transaction header master.
  • RA_CUSTOMER_TRX_LINES_ALL — the customer transaction line detail.
  • AR_INVOICE_API_PUB — the public API package that drives invoice creation and consumes this interface data.

Together these objects form the pathway by which staged distribution rows in AR_INV_API_DIST_GT become posted accounting entries in the Receivables subledger.