Search Results hz_cust_acct_relate_all_m




Overview
Explore in AI Chat

Overview

The HZ_CUST_ACCT_RELATE_ALL_M table is a specialized audit table within Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, owned by the Receivables (AR) module. Its primary role is to serve as a historical archive for records deleted from the HZ_CUST_ACCT_RELATE_ALL table during customer account merge operations. This table is critical for maintaining data integrity and auditability, ensuring that the relationship history between customer accounts is preserved even after those accounts are consolidated. It functions as a non-transactional, system-managed object that supports the TCA (Trading Community Architecture) merge process.

Key Information Stored

The table stores a complete copy of the relationship record that was deleted from the primary table, along with metadata identifying the specific merge operation that caused the deletion. The primary key is a composite of four columns, which together uniquely identify each archived relationship entry. The key columns are CUST_ACCOUNT_ID and RELATED_CUST_ACCOUNT_ID, which define the original relationship, and CUSTOMER_MERGE_HEADER_ID and MERGE_REQUEST_ID, which provide the context of the merge transaction. This structure allows for precise tracing of which relationship was removed by which merge request.

Common Use Cases and Queries

The primary use case is audit reporting and troubleshooting related to customer account merges. Administrators can query this table to understand the historical state of customer relationships or to verify the impact of a specific merge operation. A typical query would join this table to the merge request headers to generate a report of all relationships removed during a specific period or merge batch.

  • Identifying all relationships archived by a specific merge request: SELECT * FROM HZ_CUST_ACCT_RELATE_ALL_M WHERE MERGE_REQUEST_ID = &request_id;
  • Auditing the merge history for a specific customer account: SELECT m.* FROM HZ_CUST_ACCT_RELATE_ALL_M m WHERE m.CUST_ACCOUNT_ID = &cust_acct_id OR m.RELATED_CUST_ACCOUNT_ID = &cust_acct_id ORDER BY MERGE_REQUEST_ID;

Related Objects

This table has a direct and singular relationship with the HZ_CUST_ACCT_RELATE_ALL table, from which it receives its archived records. The primary key indicates a foreign key relationship to a customer merge header table (likely HZ_CUSTOMER_MERGE_HEADERS or similar) via the CUSTOMER_MERGE_HEADER_ID and MERGE_REQUEST_ID columns. It is intrinsically linked to the TCA merge process and is populated by the standard account merge programs, such as the Party Merge concurrent request. For operational reporting, it is typically queried in conjunction with these merge control tables.