Search Results dist_line_status

Overview

AR.AR_CRH_GT is a global temporary table (GTT) in the Oracle E-Business Suite Receivables (AR) schema. It serves as a transient staging and working structure used during cash receipt posting, distribution generation, and accounting event processing. The table is registered in FND Design Data as AR.AR_CRH_GT with a status of VALID in both EBS 12.1.1 and 12.2.2. As a global temporary table, its data is session-private: a session can only see rows it has inserted, and no other concurrent session can observe them. The data duration is defined as SYS$TRANSACTION, meaning rows persist until the transaction commits or rolls back, after which they are automatically purged by the database.

Storage characteristics include PCT Free 10 and PCT Used 40, reflecting the expected transient, high-turnover nature of the data. From a Data Vault modeling perspective, the heuristic classification is standalone, indicating that the table is not structurally aligned to a hub, link, or satellite pattern and instead functions as a procedural work area populated and consumed within a single logical transaction. The table contains 23 documented columns and holds receipt history and distribution context during posting operations.

Key Information Stored

Although the table exposes 23 columns, the following are the most significant for interpreting its contents:

• CASH_RECEIPT_ID — Identifier of the cash receipt being processed; the primary business reference for all rows in a posting run.
• CASH_RECEIPT_HISTORY_ID — Reference to the corresponding receipt history record, linking the staging row to the receipt lifecycle.
• CASH_RECEIPT_HISTORY_LINE_ID (CRH_LINE_ID) — Line-level identifier within the receipt history, distinguishing individual distribution lines.
• SOURCE_TYPE — Indicates the origin of the row (for example, manual, automatic, or imported receipt processing).
• POSTING_CONTROL_ID — Foreign key to AR_POSTING_CONTROL, tying the row to the posting control transaction that owns the run.
• AMOUNT and ACCTD_AMOUNT — Entered and accounted amounts for the distribution line, in the receipt currency and ledger currency respectively.
• CODE_COMBINATION_ID — Accounting flexfield combination to which the distribution is posted.
• EXCHANGE_DATE, EXCHANGE_RATE, EXCHANGE_RATE_TYPE — Currency conversion context for accounted amount derivation.
• THIRD_PARTY_ID, THIRD_PARTY_SUB_ID, THIRD_PARTY_FLAG — Third-party (customer/supplier) context where the receipt is applied on behalf of another party.
• EVENT_ID and ENTITY_ID — Subledger accounting event and entity references used to create accounting entries.
• LEDGER_ID, BASE_CURRENCY_CODE, ORG_ID — Ledger, base currency, and operating unit context for the transaction.
• STATUS — Row-level processing status used by the posting program to track progress.
• RECP_AMOUNT and RECP_ACCTD_AMOUNT — Receipt-level amounts, useful for reconciliation against line-level distributions.
• DIST_LINE_STATUS — Distribution line status flag; this is the column targeted by the search term dist_line_status and is used to drive distribution processing logic, indicating whether a distribution line is pending, processed, or rejected.

No surrogate primary key is documented on this table; it is a transient work table. CASH_RECEIPT_ID combined with CASH_RECEIPT_HISTORY_ID and CRH_LINE_ID typically serves as the effective business key within a posting run.

Common Use Cases and Queries

The primary use case is diagnostic: inspecting rows left in the GTT during or immediately after a failed posting run to identify distribution lines that did not post. Because the table is transaction-scoped, queries must be executed from the same session that populated it, or within the same transaction. Typical patterns include:

• Filtering by DIST_LINE_STATUS to isolate lines that remain unprocessed: SELECT CASH_RECEIPT_ID, CRH_LINE_ID, DIST_LINE_STATUS FROM AR.AR_CRH_GT WHERE DIST_LINE_STATUS <> 'Y';
• Reconciling entered versus accounted amounts across distributions: SELECT CRH_LINE_ID, AMOUNT, ACCTD_AMOUNT, CODE_COMBINATION_ID FROM AR.AR_CRH_GT;
• Joining to AR_POSTING_CONTROL on POSTING_CONTROL_ID to correlate staging rows with the parent posting control record.
• Investigating currency conversion issues using EXCHANGE_RATE_TYPE and EXCHANGE_DATE.

Because data is removed at transaction end, the table is not suitable for historical reporting. It is intended for debugging and process monitoring within a session.

Related Objects

• AR_POSTING_CONTROL — Referenced via POSTING_CONTROL_ID; the parent control record for the posting run.
• AR_CASH_RECEIPTS — Source of CASH_RECEIPT_ID for the receipts being processed.
• AR_CASH_RECEIPT_HISTORY — Source of CASH_RECEIPT_HISTORY_ID and line-level history context.
• AR_DISTRIBUTIONS — Final destination for distribution lines generated from this staging data.
• AR_XLA_LINES and XLA_EVENTS — Subledger accounting objects linked via EVENT_ID and ENTITY_ID.
• GL_CODE_COMBINATIONS — Provides the accounting flexfield referenced by CODE_COMBINATION_ID.
• AR_CRH_GT (APPS synonym) — Public synonym present in the APPS schema for application-level access.

These relationships confirm that AR_CRH_GT functions as an intermediate staging artifact within the Receivables posting pipeline, bridging receipt history, distributions, and subledger accounting event generation.