Search Results contact_assignment_id

Overview

The CE_CONTACT_ASSIGNMENTS table is a core data object within the Oracle E-Business Suite Cash Management (CE) module. It serves as the central repository for managing the association between contact persons and the specific banking entities they are responsible for. Its primary role is to define the assignment level—bank, branch, or bank account—for a given contact, enabling precise communication and operational workflows related to treasury and cash management activities. This table is essential for maintaining the integrity of bank contact information and ensuring that notifications, inquiries, and authorizations are directed to the correct individuals based on their defined scope of responsibility within the organization's banking hierarchy.

Key Information Stored

The table's structure is designed to capture the relationship between a contact and the banking entity. The primary key, CONTACT_ASSIGNMENT_ID, uniquely identifies each assignment record. The table's critical foreign key columns define the specific assignment level: BANK_PARTY_ID references the HZ_PARTIES table to identify the bank institution, BRANCH_PARTY_ID references HZ_PARTIES to identify a specific branch, and BANK_ACCOUNT_ID references the CE_BANK_ACCOUNTS table to identify a particular account. The presence or absence of data in these columns determines the contact's assignment level. For instance, a record with only BANK_PARTY_ID populated indicates a bank-level contact, while a record with all three columns populated indicates a contact assigned specifically to that account.

Common Use Cases and Queries

A primary use case is generating reports or lists of contacts for a specific bank account, which is crucial for payment processing or reconciliation inquiries. A typical query would join CE_CONTACT_ASSIGNMENTS with HZ_PARTIES (for contact details) and CE_BANK_ACCOUNTS.

• Find all contacts for a specific bank account:
  SELECT hzp.party_name, hzp.email_address FROM ce_contact_assignments cca, hz_parties hzp WHERE cca.bank_account_id = :p_bank_account_id AND cca.contact_party_id = hzp.party_id;
• Identify the assignment level for all contacts:
  SELECT contact_party_id, CASE WHEN bank_account_id IS NOT NULL THEN 'Account' WHEN branch_party_id IS NOT NULL THEN 'Branch' ELSE 'Bank' END AS assignment_level FROM ce_contact_assignments;

These queries support operational tasks like distributing bank statements, managing signatory authorities, and maintaining an up-to-date bank relationship directory.

Related Objects

CE_CONTACT_ASSIGNMENTS is intrinsically linked to several key EBS objects, primarily through its foreign key constraints. Its main dependencies are:

• HZ_PARTIES: This Trading Community Architecture (TCA) table supplies the party information for both the contact person (CONTACT_PARTY_ID) and the bank/branch entities (BANK_PARTY_ID, BRANCH_PARTY_ID).
• CE_BANK_ACCOUNTS: This core Cash Management table stores bank account definitions. The BANK_ACCOUNT_ID foreign key links a contact directly to a specific account.
• AP_BANK_ACCOUNT_USES_ALL / CE_BANK_ACCT_USES_ALL: While not directly referenced in the provided metadata, these tables defining account usage are often joined with CE_BANK_ACCOUNTS and subsequently CE_CONTACT_ASSIGNMENTS in operational reports to filter contacts by account purpose (e.g., Payables, Payroll).