Results for “alt_name”

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

Overview

AR_CUSTOMER_ALT_NAMES is an Oracle Receivables (AR) table that stores alternate customer names used by the AutoLockbox program for name-based matching of incoming customer payments. During automatic lockbox processing, banks transmit remittance data that frequently contains customer name variants, abbreviations, or trading names that do not correspond exactly to the customer name held in Oracle Receivables. This table provides a controlled list of recognized aliases so that AutoLockbox can resolve an incoming name to the correct customer account and, where applicable, the correct customer site, before applying the receipt.

The table resides in the AR schema, carries a VALID status, and contains 10 documented columns in the ETRM 12.2.2 physical schema. Based on the foreign key structure—references outward to HZ_CUST_ACCOUNTS and HZ_CUST_SITE_USES_ALL—the object exhibits the characteristics of a link table in a Data Vault modeling sense, associating an alternate name to a customer account and optionally to a specific site use. This classification is a heuristic modeling suggestion derived from the FK topology rather than a documented Data Vault designation.

Key Information Stored

• ALT_NAME_ID — Surrogate primary key, enforced by the AR_CUSTOMER_ALT_NAMES_PK constraint. Uniquely identifies each alternate name record.
• ALT_NAME — The alternate or alias customer name presented on the bank remittance file. This is the business-critical matching value used by AutoLockbox.
• CUSTOMER_ID — Foreign key to HZ_CUST_ACCOUNTS. Identifies the customer account to which the alternate name belongs.
• SITE_USE_ID — Foreign key to HZ_CUST_SITE_USES_ALL. Optionally narrows the alternate name to a specific customer site use, enabling site-level matching where remittance data is site-specific.
• TERM_ID — Payment term reference associated with the alternate name record, supporting term-based processing during lockbox application.
• Audit columns — CREATED_BY, CREATION_DATE, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, and LAST_UPDATED_BY record standard Oracle Applications who-did-what auditing information.

The documented primary key is ALT_NAME_ID. No separate unique index on the business key is documented in the ETRM metadata; in practice, the natural business key would combine the alternate name with the customer and site context.

Common Use Cases and Queries

Reporting and troubleshooting commonly center on validating AutoLockbox match behavior and maintaining alias records. A typical query joins the alternate name to the customer account to confirm the target of a matching rule:

• Listing all alternate names for a given customer: SELECT alt_name FROM ar_customer_alt_names WHERE customer_id = :customer_id;
• Verifying site-specific aliases: SELECT alt_name, site_use_id FROM ar_customer_alt_names WHERE customer_id = :customer_id AND site_use_id IS NOT NULL;
• Diagnosing lockbox matching failures by searching for the exact name string presented by the bank: SELECT customer_id, site_use_id FROM ar_customer_alt_names WHERE alt_name = :bank_name;
• Auditing alias maintenance activity by creation and update dates to review recently added entries.

These queries support AutoLockbox name-matching configuration reviews, post-submission reconciliation, and data-quality audits of alias completeness across customer accounts.

Related Objects

• HZ_CUST_ACCOUNTS — Joined via AR_CUSTOMER_ALT_NAMES.CUSTOMER_ID = HZ_CUST_ACCOUNTS.CUST_ACCOUNT_ID. Provides the authoritative customer account context.
• HZ_CUST_SITE_USES_ALL — Joined via AR_CUSTOMER_ALT_NAMES.SITE_USE_ID = HZ_CUST_SITE_USES_ALL.SITE_USE_ID. Supplies site-use detail for site-level alias matching.
• HZ_CUSTOMER_PROFILES — Holds AutoLockbox matching configuration, including matching rules that determine how alternate names are consumed.
• AR_PAYMENT_SCHEDULES_ALL — Receipt application targets referenced once AutoLockbox resolves the customer through matching.
• AR_CASH_RECEIPTS_ALL — Stores the receipts created by AutoLockbox after successful customer identification.
• AR_CUSTOMER_ALT_NAMES_PK — Primary key constraint enforcing uniqueness of ALT_NAME_ID.