Search Results merge_request_id




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.

  • Table: HZ_CUST_ACCT_RELATE_ALL_M 12.2.2

    owner:AR,  object_type:TABLE,  fnd_design_data:AR.HZ_CUST_ACCT_RELATE_ALL_M,  object_name:HZ_CUST_ACCT_RELATE_ALL_M,  status:VALID,  product: AR - Receivables ,  description: This table is used to store the deleted records for HZ_CUST_ACCT_RELATE_ALL during account merge ,  implementation_dba_data: AR.HZ_CUST_ACCT_RELATE_ALL_M , 

  • Table: HZ_CUST_PROFILE_AMTS_M 12.1.1

    owner:AR,  object_type:TABLE,  fnd_design_data:AR.HZ_CUST_PROFILE_AMTS_M,  object_name:HZ_CUST_PROFILE_AMTS_M,  status:VALID,  product: AR - Receivables ,  description: The HZ_CUST_PROFILE_AMTS_M table stores the information of customer profile amounts from HZ_CUST_PROFILE_AMTS table before the account merge happens.The primary key for this table is CUST_ACCT_PROFILE_AMT_ID, CUSTOMER_MERGE_HEADER_ID. ,  implementation_dba_data: AR.HZ_CUST_PROFILE_AMTS_M , 

  • Table: HZ_CUST_SITE_USES_ALL_M 12.2.2

    owner:AR,  object_type:TABLE,  fnd_design_data:AR.HZ_CUST_SITE_USES_ALL_M,  object_name:HZ_CUST_SITE_USES_ALL_M,  status:VALID,  product: AR - Receivables ,  description: The HZ_CUST_SITE_USES_ALL_M table stores the information of customer site uses from HZ_CUST_SITE_USES_ALL table before the account merge happens. The primary key for this table is CUST_SITE_USE_ID , CUSTOMER_MERGE_HEADER_ID. ,  implementation_dba_data: AR.HZ_CUST_SITE_USES_ALL_M , 

  • Table: HZ_CUST_ACCOUNT_ROLES_M 12.2.2

    owner:AR,  object_type:TABLE,  fnd_design_data:AR.HZ_CUST_ACCOUNT_ROLES_M,  object_name:HZ_CUST_ACCOUNT_ROLES_M,  status:VALID,  product: AR - Receivables ,  description: This table stores the information of a customer account role from HZ_CUST_ACCOUNT_ROLES table before the account merge happens. The primary key for this table is CUST_ACCOUNT_ROLE_ID, CUSTOMER_MERGE_HEADER_ID. ,  implementation_dba_data: AR.HZ_CUST_ACCOUNT_ROLES_M , 

  • Table: HZ_CUST_ACCOUNTS_M 12.2.2

    owner:AR,  object_type:TABLE,  fnd_design_data:AR.HZ_CUST_ACCOUNTS_M,  object_name:HZ_CUST_ACCOUNTS_M,  status:VALID,  product: AR - Receivables ,  description: This table is used to store the deleted records for HZ_CUST_ACCOUNTS during account merge ,  implementation_dba_data: AR.HZ_CUST_ACCOUNTS_M , 

  • Table: HZ_CUSTOMER_PROFILES_M 12.1.1

    owner:AR,  object_type:TABLE,  fnd_design_data:AR.HZ_CUSTOMER_PROFILES_M,  object_name:HZ_CUSTOMER_PROFILES_M,  status:VALID,  product: AR - Receivables ,  description: This table is used to store the deleted records for hz_customer_profiles during account merge ,  implementation_dba_data: AR.HZ_CUSTOMER_PROFILES_M , 

  • Table: HZ_CUST_ACCT_RELATE_ALL_M 12.1.1

    owner:AR,  object_type:TABLE,  fnd_design_data:AR.HZ_CUST_ACCT_RELATE_ALL_M,  object_name:HZ_CUST_ACCT_RELATE_ALL_M,  status:VALID,  product: AR - Receivables ,  description: This table is used to store the deleted records for HZ_CUST_ACCT_RELATE_ALL during account merge ,  implementation_dba_data: AR.HZ_CUST_ACCT_RELATE_ALL_M , 

  • Table: HZ_CUST_ACCOUNT_ROLES_M 12.1.1

    owner:AR,  object_type:TABLE,  fnd_design_data:AR.HZ_CUST_ACCOUNT_ROLES_M,  object_name:HZ_CUST_ACCOUNT_ROLES_M,  status:VALID,  product: AR - Receivables ,  description: This table stores the information of a customer account role from HZ_CUST_ACCOUNT_ROLES table before the account merge happens. The primary key for this table is CUST_ACCOUNT_ROLE_ID, CUSTOMER_MERGE_HEADER_ID. ,  implementation_dba_data: AR.HZ_CUST_ACCOUNT_ROLES_M , 

  • Table: HZ_CUST_ACCT_SITES_ALL_M 12.2.2

    owner:AR,  object_type:TABLE,  fnd_design_data:AR.HZ_CUST_ACCT_SITES_ALL_M,  object_name:HZ_CUST_ACCT_SITES_ALL_M,  status:VALID,  product: AR - Receivables ,  description: The HZ_CUST_ACCT_SITES_ALL_M table stores the information of customer profile amounts from HZ_CUST_ACCT_SITES_ALL table before the account merge happens. The primary key for this table is CUST_ACCT_SITE_ID , CUSTOMER_MERGE_HEADER_ID. ,  implementation_dba_data: AR.HZ_CUST_ACCT_SITES_ALL_M , 

  • Table: HZ_CUST_SITE_USES_ALL_M 12.1.1

    owner:AR,  object_type:TABLE,  fnd_design_data:AR.HZ_CUST_SITE_USES_ALL_M,  object_name:HZ_CUST_SITE_USES_ALL_M,  status:VALID,  product: AR - Receivables ,  description: The HZ_CUST_SITE_USES_ALL_M table stores the information of customer site uses from HZ_CUST_SITE_USES_ALL table before the account merge happens. The primary key for this table is CUST_SITE_USE_ID , CUSTOMER_MERGE_HEADER_ID. ,  implementation_dba_data: AR.HZ_CUST_SITE_USES_ALL_M , 

  • Table: HZ_CUST_PROFILE_AMTS_M 12.2.2

    owner:AR,  object_type:TABLE,  fnd_design_data:AR.HZ_CUST_PROFILE_AMTS_M,  object_name:HZ_CUST_PROFILE_AMTS_M,  status:VALID,  product: AR - Receivables ,  description: The HZ_CUST_PROFILE_AMTS_M table stores the information of customer profile amounts from HZ_CUST_PROFILE_AMTS table before the account merge happens.The primary key for this table is CUST_ACCT_PROFILE_AMT_ID, CUSTOMER_MERGE_HEADER_ID. ,  implementation_dba_data: AR.HZ_CUST_PROFILE_AMTS_M , 

  • Table: HZ_CUST_ACCOUNTS_M 12.1.1

    owner:AR,  object_type:TABLE,  fnd_design_data:AR.HZ_CUST_ACCOUNTS_M,  object_name:HZ_CUST_ACCOUNTS_M,  status:VALID,  product: AR - Receivables ,  description: This table is used to store the deleted records for HZ_CUST_ACCOUNTS during account merge ,  implementation_dba_data: AR.HZ_CUST_ACCOUNTS_M , 

  • Table: HZ_CUSTOMER_PROFILES_M 12.2.2

    owner:AR,  object_type:TABLE,  fnd_design_data:AR.HZ_CUSTOMER_PROFILES_M,  object_name:HZ_CUSTOMER_PROFILES_M,  status:VALID,  product: AR - Receivables ,  description: This table is used to store the deleted records for hz_customer_profiles during account merge ,  implementation_dba_data: AR.HZ_CUSTOMER_PROFILES_M , 

  • Table: HZ_CUST_ACCT_SITES_ALL_M 12.1.1

    owner:AR,  object_type:TABLE,  fnd_design_data:AR.HZ_CUST_ACCT_SITES_ALL_M,  object_name:HZ_CUST_ACCT_SITES_ALL_M,  status:VALID,  product: AR - Receivables ,  description: The HZ_CUST_ACCT_SITES_ALL_M table stores the information of customer profile amounts from HZ_CUST_ACCT_SITES_ALL table before the account merge happens. The primary key for this table is CUST_ACCT_SITE_ID , CUSTOMER_MERGE_HEADER_ID. ,  implementation_dba_data: AR.HZ_CUST_ACCT_SITES_ALL_M ,