Search Results hz_contacts

Overview

The CCT.CCT_ADDRESS_BOOKS table is a component of the Oracle E-Business Suite Agent Soft Phone functionality, residing in the CCT schema (typically associated with the Telephony / Interaction Center module). It stores the address book records maintained by agents within the soft phone interface, allowing agents to persist frequently contacted parties for rapid retrieval during inbound and outbound call handling. The table operates in the APPS_TS_TX_DATA tablespace and carries FND design data registration under the same qualified name, confirming it as a recognized application object in EBS 12.1.1 and 12.2.2.

In terms of Data Vault modeling heuristics, the table is classified as standalone, reflecting its lack of non-security-group foreign key dependencies to other business entities. Modelers may treat CCT_ADDRESS_BOOKS as a satellite-like structure keyed on its own surrogate identifier, with the CONTACT_POINT_ID serving as a soft business reference rather than a formally enforced parent relationship.

Key Information Stored

The table contains 25 documented columns. The most significant are:

• ADDRESS_BOOK_ID (NUMBER) — Surrogate primary key, uniquely constrained by CCT_CAB_PK. All address book entries are identified through this value.
• AGENT_ID (NUMBER) — Identifies the agent or resource who owns the address book entry; effectively the business-key candidate linking the record to a specific resource.
• CONTACT_POINT_ID (NUMBER) — Documented as a foreign key to the HZ_CONTACTS object, providing the reference to the underlying contact point record. This is the critical integration column for users searching on "hz_contacts".
• CONTEXT (VARCHAR2(30)) — Descriptive Flexfield structure-defining column; drives which DFF segments are meaningful for a given row.
• ATTRIBUTE1 through ATTRIBUTE15 (VARCHAR2(150)) — Descriptive Flexfield segment columns holding agent- or implementation-specific supplementary data.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, CREATION_DATE — Standard WHO columns supporting audit and change tracking.
• SECURITY_GROUP_ID (NUMBER) — Used in hosted environments and referencing FND_SECURITY_GROUPS to enforce multi-tenant data isolation.

Common Use Cases and Queries

The primary use case is reporting on agent-maintained address books and reconciling soft phone contact entries back to the master customer data held in HZ. A common query joins CCT_ADDRESS_BOOKS to the HZ contacts infrastructure via CONTACT_POINT_ID to surface which agents have bookmarked which contacts:

• Identifying all address book entries for a given agent by filtering on AGENT_ID.
• Resolving contact point details for a soft phone entry by joining CONTACT_POINT_ID to the appropriate HZ contact/contact-point table.
• Auditing creation and last-update activity through the WHO columns for compliance reviews.
• Extracting Descriptive Flexfield content by first reading the CONTEXT value and then selecting only the relevant ATTRIBUTEn columns for that context.
• Isolating hosted-environment data by restricting results through SECURITY_GROUP_ID.

A representative pattern: SELECT ab.ADDRESS_BOOK_ID, ab.AGENT_ID, ab.CONTACT_POINT_ID, ab.CONTEXT, ab.CREATION_DATE FROM CCT.CCT_ADDRESS_BOOKS ab WHERE ab.AGENT_ID = :agent_id ORDER BY ab.CREATION_DATE DESC;

Related Objects

• CCT.CCT_ADDRESS_BOOKS.SECURITY_GROUP_ID → FND_SECURITY_GROUPS — The only documented enforced foreign key, establishing the security group context for hosted deployments.
• HZ_CONTACTS (via CONTACT_POINT_ID) — The master contact source; the logical parent of the CONTACT_POINT_ID value, and the object most commonly associated with this table in search and reporting scenarios.
• HZ_CONTACT_POINTS — The HZ table that physically holds contact point records referenced by CONTACT_POINT_ID.
• CCT_CAB_PK — The primary key constraint on ADDRESS_BOOK_ID that guarantees row uniqueness.
• FND_DESCR_FLEX_COL_USAGE / FND_DESCR_FLEX_CONTEXTS — Flexfield metadata tables that define the CONTEXT and ATTRIBUTEn segment behavior.
• FND_USER / PER_RESOURCES — Logical parents of AGENT_ID, resolving the resource identity behind each address book owner.