Search Results iex_ag_dn_xref




Overview
Explore in AI Chat

Overview

IEX_AG_DN_XREF is a transaction and setup table owned by the IEX (Collections) schema in Oracle E-Business Suite Release 12.1.1 and 12.2.2. As its name implies, the table stores cross-reference definitions that link aging buckets and dunning levels to fulfillment and dunning processing behavior. It functions as a configuration registry that determines how delinquent transactions are scored, categorized into aging buckets, and subsequently driven through dunning plans, dunning levels, and letter templates. Records in this table are consumed by the Collections dunning engine at the time dunning letters and dunning transactions are generated, so it acts as a bridging configuration object between the aging analysis of receivables and the dunning execution layer.

The ETRM metadata classifies IEX_AG_DN_XREF heuristically as standalone under the Data Vault model. In practice, however, its primary key is referenced by two downstream tables (IEX_DUNNINGS and IEX_DUNNING_TRANSACTIONS), which suggests that a link-style modeling approach — treating the table as a junction connecting dunning plans, aging buckets, and dunning levels — is a reasonable architectural interpretation. This classification should be treated as a suggestion rather than a hard rule.

Key Information Stored

The table contains 43 documented columns. The surrogate primary key is AG_DN_XREF_ID, which is also protected by the unique index IEX_AG_DN_XREF_U1, making it the effective business-key candidate exposed to other tables. The most operationally significant columns include:

Common Use Cases and Queries

The primary use case is analysis of dunning strategy configuration — for example, determining which dunning level applies to a given aging bucket and score range, or verifying the minimum dunning interval. A typical query joining the cross-reference to its parent aging bucket would resemble:

  • SELECT a.AG_DN_XREF_ID, a.DUNNING_LEVEL, a.MIN_DAYS_BETWEEN_DUNNING FROM IEX_AG_DN_XREF a WHERE a.AGING_BUCKET_ID = :bucket_id;
  • Identifying orphaned or inactive cross-references by comparing AG_DN_XREF_ID against IEX_DUNNINGS.AG_DN_XREF_ID.
  • Reporting score-band coverage by querying SCORE_RANGE_LOW and SCORE_RANGE_HIGH to detect overlaps or gaps.
  • Auditing template assignment through TEMPLATE_ID and XDO_TEMPLATE_ID against the concurrent program output.

Because the table drives runtime dunning generation, querying it alongside IEX_DUNNINGS provides a full picture of which plan produced which dunning letter. Care should be exercised when querying in a multi-org context, filtering by SECURITY_GROUP_ID where relevant.

Related Objects

  • IEX_DUNNINGS — references IEX_AG_DN_XREF via AG_DN_XREF_ID; stores generated dunning letters.
  • IEX_DUNNING_TRANSACTIONS — references IEX_AG_DN_XREF via AG_DN_XREF_ID; stores the transactions included in each dunning run.
  • FND_SECURITY_GROUPS — referenced by IEX_AG_DN_XREF.SECURITY_GROUP_ID for access control.
  • IEX_AGING_BUCKETS and IEX_AGING_BUCKET_LINES — provide the aging bucket and bucket line referenced by AGING_BUCKET_ID and AGING_BUCKET_LINE_ID.
  • IEX_DUNNING_PLANS — referenced through DUNNING_PLAN_ID.
  • IEX_DUNNING_LETTERS / XDO templates — referenced through TEMPLATE_ID and XDO_TEMPLATE_ID.
  • IEX_DUNNING_LEVELS — contextual reference for the DUNNING_LEVEL column.