Search Results ar_rdr_parameters_gt




Overview
Explore in AI Chat

Overview

AR_RDR_PARAMETERS_GT is a global temporary table (indicated by the "_GT" suffix) in the Oracle Receivables (AR) module of Oracle E-Business Suite, owned by the AR schema. It functions as an interim staging structure that holds parameter values used by AutoInvoice and related Receivables processing to resolve the correct customer, transaction type, item, memo line, and accounting configuration during invoice import. In release 12.1.1 and 12.2.2, the object is documented as VALID with 23 columns in the ETRM 12.2.2 physical schema.

The ETRM metadata classifies this object with a heuristic Data Vault classification of standalone. As a modeling suggestion, this indicates the table does not behave as a true hub or link in the canonical Data Vault sense; it is a transient processing structure whose rows are scoped to a session or concurrent request rather than a durable business entity. Any Data Vault implementation should treat it as a transient staging artifact rather than a persistent satellite.

Key Information Stored

The table's columns represent lookup keys that AutoInvoice uses to derive transaction attributes. The most significant columns are:

The documented metadata does not identify a distinct surrogate primary key column or unique business-key index; the row identity is implicitly driven by the combination of lookup keys above, consistent with a temporary staging table rather than a persisted entity.

Common Use Cases and Queries

Typical usage arises during AutoInvoice debugging and reconciliation. A developer might join the table to batch sources to verify which parameters were applied to a given line:

  • Diagnostic queries joining SOURCE_LINE_ID back to the interface table to confirm customer or transaction-type derivation.
  • Reporting queries aggregating rows by BATCH_SOURCE_ID or ORG_ID to audit parameter coverage across operating units.
  • Validation checks that confirm CUST_ACCOUNT_ID and CUST_TRX_TYPE_ID are populated before the import program consumes the data.

Because the object is a global temporary table, contents are visible only within the session or transaction that populated it, and no query against it will return persisted historical data.

Related Objects

Foreign-key metadata links AR_RDR_PARAMETERS_GT to the following principal objects:

These relationships identify the table as a parameter-resolution artifact supporting AutoInvoice processing across the Receivables customer and transaction model.