Search Results cct_cab_pk

Overview

CCT_ADDRESS_BOOKS is a Telephony Manager (CCT) application table in Oracle EBS 12.1.1 and 12.2.2 that stores address book entries used by the Agent Soft Phone. Each row represents an address book record owned by a specific agent, enabling contact and directory information to be presented within the soft phone interface during inbound or outbound call handling. The table resides in the CCT schema and is classified as VALID in the ETRM repository.

The documented foreign key to FND_SECURITY_GROUPS suggests that address book rows participate in Oracle EBS security group (operating unit) partitioning, consistent with multi-org and multi-tenant security models. The Data Vault classification mined from the foreign key structure is standalone, meaning the table is effectively modeled as an independent entity rather than a pure hub, link, or satellite. In a Data Vault recommendation sense, it could be treated as a hub-like structure with the address book identifier as the business key and agent context as descriptive attributes.

Key Information Stored

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

• ADDRESS_BOOK_ID — surrogate primary key defined by constraint CCT_CAB_PK; uniquely identifies each address book record.
• AGENT_ID — the agent to whom the address book belongs; forms the business-key unique index CCT_CAB_UK1 (in combination with other attributes), supporting per-agent address book separation.
• CONTACT_POINT_ID — reference to the contact point (telephone number, email, or similar) associated with the address book entry.
• SECURITY_GROUP_ID — foreign key to FND_SECURITY_GROUPS, enforcing security group partitioning for multi-org visibility.
• CONTEXT — descriptive flexfield context, allowing extension of the base address book record.
• ATTRIBUTE1 through ATTRIBUTE15 — descriptive flexfield segments (with ATTRIBUTE6 and ATTRIBUTE7 present in the schema) used for customer-specific extensions without schema change.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — standard EBS audit columns capturing who last changed the record and under which login session.
• CREATED_BY, CREATION_DATE — standard EBS creation audit columns recording record provenance.

The primary key is the surrogate ADDRESS_BOOK_ID, while AGENT_ID serves as a business-key candidate through the unique index CCT_CAB_UK1. This design allows multiple contact entries per agent while maintaining uniqueness at the business level.

Common Use Cases and Queries

Typical uses include reporting on agents' soft phone directories, auditing address book growth per agent, troubleshooting missing contacts in the Agent Soft Phone, and extracting entries for migration or integration.

Sample queries:

• List all address book entries for an agent:
  SELECT ADDRESS_BOOK_ID, AGENT_ID, CONTACT_POINT_ID FROM CCT.CCT_ADDRESS_BOOKS WHERE AGENT_ID = :agent_id;
• Count entries per agent:
  SELECT AGENT_ID, COUNT(*) FROM CCT.CCT_ADDRESS_BOOKS GROUP BY AGENT_ID ORDER BY 2 DESC;
• Join to security groups for operating unit context:
  SELECT c.ADDRESS_BOOK_ID, c.AGENT_ID, s.SECURITY_GROUP_ID FROM CCT.CCT_ADDRESS_BOOKS c JOIN FND_SECURITY_GROUPS s ON s.SECURITY_GROUP_ID = c.SECURITY_GROUP_ID;
• Audit recent changes:
  SELECT ADDRESS_BOOK_ID, LAST_UPDATED_BY, LAST_UPDATE_DATE FROM CCT.CCT_ADDRESS_BOOKS WHERE LAST_UPDATE_DATE > SYSDATE - 30;

Related Objects

• FND_SECURITY_GROUPS — referenced via SECURITY_GROUP_ID; defines the security group (operating unit) context for each address book record.
• CCT_AGENTS / CCT_AGENT_* tables — reference AGENT_ID to associate address book entries with soft phone agents.
• CCT_CONTACT_POINTS — referenced via CONTACT_POINT_ID to resolve the actual phone, email, or directory contact details.
• FND_DESCR_FLEX_COLUMN_USAGES / FND_DESCR_FLEX_CONTEXTS — metadata for the CONTEXT and ATTRIBUTE1–15 descriptive flexfield columns.
• FND_USER — indirectly related through CREATED_BY and LAST_UPDATED_BY for audit attribution.
• Telephony Manager Agent Soft Phone UI — the primary consumer that reads and maintains address book records at runtime.