Results for “ar_trx_dist_tmp_gt”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

AR_TRX_DIST_TMP_GT is a temporary global temporary table (GTT) in the Oracle Receivables (AR) schema. It serves as a transient staging area for Receivables transaction distribution data — the accounting distributions generated from invoices, credit memos, debit memos, chargebacks, and their associated lines. During transaction entry, adjustment processing, or accounting creation, Oracle EBS populates this table with distribution rows that are subsequently validated, transferred to the permanent distributions table, and used to create accounting entries.

In the context of Oracle EBS 12.1.1 and 12.2.2, the object is a global temporary table, meaning its data is session-private and typically purged at transaction commit or session termination, depending on the ON COMMIT clause configured. It is essential for the Receivables accounting workflow, particularly the Create Accounting and distribution validation processes. The ETRM metadata classifies this object heuristically as standalone within the Data Vault model. A reasonable modeling suggestion is that it does not fit cleanly into a hub, link, or satellite pattern, since it functions as an operational staging structure rather than a persistent integration point.

Key Information Stored

The table contains 56 documented columns. The most significant are:

• TRX_DIST_ID — the surrogate primary key uniquely identifying each distribution row.
• TRX_HEADER_ID — foreign key to PN_VAR_TRX_HEADERS_ALL, linking the distribution to its parent transaction header.
• TRX_LINE_ID — foreign key to CN_TRX_LINES_ALL, identifying the specific transaction line.
• ACCOUNT_CLASS — the accounting class (for example, REC, REV, TAX, FREIGHT) that determines the general ledger account type.
• AMOUNT — the entered distribution amount in transaction currency.
• ACCTD_AMOUNT — the accounted amount in functional currency.
• PERCENT — the allocation percentage applied to the distribution.
• CODE_COMBINATION_ID — the general ledger account combination used for accounting entry generation.
• ATTRIBUTE1–ATTRIBUTE15 — descriptive flexfield segments for capturing additional transaction-specific information.
• GLOBAL_ATTRIBUTE1–GLOBAL_ATTRIBUTE30 — global descriptive flexfield segments, typically used for localization and country-specific requirements.
• COMMENTS — free-form text associated with the distribution.

TRX_DIST_ID functions as the surrogate primary key. TRX_HEADER_ID and TRX_LINE_ID serve as foreign key business-key candidates that anchor each row to its source transaction and line.

Common Use Cases and Queries

Because the table is temporary, it is chiefly accessed during concurrent programs such as Create Accounting, Revenue Recognition, and distribution validation. Common reporting use cases include reconciling transaction distributions against source lines, investigating unposted or suspense amounts, and diagnosing imbalances between entered and accounted amounts.

A typical diagnostic query joins the temporary table to the transaction headers and lines:

• SELECT d.trx_dist_id, d.trx_header_id, d.trx_line_id, d.account_class, d.amount, d.acctd_amount, d.code_combination_id FROM ar_trx_dist_tmp_gt d WHERE d.trx_header_id = :header_id;
• SELECT d.account_class, SUM(d.amount) FROM ar_trx_dist_tmp_gt d GROUP BY d.account_class;

These patterns support troubleshooting when distributions fail to transfer to the permanent table, when account class balances do not reconcile, or when flexfield values are missing.

Related Objects

• PN_VAR_TRX_HEADERS_ALL — joined via TRX_HEADER_ID; the parent transaction header.
• CN_TRX_LINES_ALL — joined via TRX_LINE_ID; the source transaction line.
• AR_TRX_DISTRIBUTIONS_ALL — the permanent distribution table to which validated rows are ultimately transferred.
• RA_CUST_TRX_LINE_GL_DIST_ALL — stores finalized line-level GL distributions for receivables transactions.
• AR_XLA_TRX_DISTRIBUTIONS — subledger accounting source distributions derived from Receivables transactions.
• GL_CODE_COMBINATIONS — resolved via CODE_COMBINATION_ID for account validation.