Search Results hz_contact_points
HZ_CONTACT_POINTS Table in Oracle EBS 12.1.1/12.2.2
The HZ_CONTACT_POINTS table is a fundamental component of Oracle E-Business Suite's Trading Community Architecture (TCA), serving as the central repository for all contact point information across various entities in the system. This table stores comprehensive communication details for parties, party sites, and other TCA entities, enabling robust customer relationship management functionality.
Core Functionality
As part of Oracle's Customer Data Hub, HZ_CONTACT_POINTS:
- Maintains all communication methods for business entities
- Supports multiple contact types including phone, email, web, and physical addresses
- Enables relationship tracking between contact points and TCA entities
- Provides validation and formatting rules for contact information
Key Technical Attributes
Column Name | Data Type | Description |
---|---|---|
CONTACT_POINT_ID | NUMBER | Primary key identifier |
CONTACT_POINT_TYPE | VARCHAR2(30) | Classification (PHONE, EMAIL, WEB, etc.) |
OWNER_TABLE_NAME | VARCHAR2(30) | Parent entity table (HZ_PARTIES, HZ_PARTY_SITES) |
OWNER_TABLE_ID | NUMBER | Foreign key to parent record |
PRIMARY_FLAG | VARCHAR2(1) | Indicates preferred contact method |
STATUS | VARCHAR2(30) | Active/Inactive status |
Integration Points
The table integrates with multiple Oracle EBS modules:
- Order Management: Customer contact information for order processing
- Receivables: Billing and collection contact details
- Service Contracts: Service delivery contacts
- Marketing: Campaign communication channels
Version-Specific Considerations
Between 12.1.1 and 12.2.2, key enhancements include:
- Expanded validation rules for email formats
- Support for international phone number formats
- Additional security attributes for sensitive contact data
- Performance optimizations for large-scale implementations
Data Management Best Practices
For optimal performance and data quality:
- Implement regular data cleansing routines
- Establish clear ownership rules for contact point maintenance
- Leverage TCA's duplicate prevention features
- Utilize Oracle's Data Quality tools for standardization
The HZ_CONTACT_POINTS table represents a critical infrastructure component for customer data management in Oracle EBS, enabling consistent, enterprise-wide access to communication channels while maintaining data integrity across all business processes.
-
Table: HZ_CONTACT_POINTS
12.2.2
owner:AR, object_type:TABLE, fnd_design_data:AR.HZ_CONTACT_POINTS, object_name:HZ_CONTACT_POINTS, status:VALID, product: AR - Receivables , description: Electronic methods of communicating with parties , implementation_dba_data: AR.HZ_CONTACT_POINTS ,
-
Table: HZ_CONTACT_POINTS
12.1.1
owner:AR, object_type:TABLE, fnd_design_data:AR.HZ_CONTACT_POINTS, object_name:HZ_CONTACT_POINTS, status:VALID, product: AR - Receivables , description: Electronic methods of communicating with parties , implementation_dba_data: AR.HZ_CONTACT_POINTS ,
-
APPS.AST_UWQ_SEL_PKG dependencies on HZ_CONTACT_POINTS
12.1.1
-
APPS.IBE_CART_NOTIFY_UTIL dependencies on HZ_CONTACT_POINTS
12.1.1
-
APPS.CS_ERES_INT_PKG dependencies on HZ_CONTACT_POINTS
12.1.1
-
APPS.IGS_CO_PROCESS dependencies on HZ_CONTACT_POINTS
12.1.1
-
APPS.JTF_UM_REGISTER_USER_PVT dependencies on HZ_CONTACT_POINTS
12.1.1
-
APPS.AS_SALES_LEAD_ASSIGN_PVT dependencies on HZ_CONTACT_POINTS
12.1.1
-
APPS.OKL_STRY_CALL_CO_PUB dependencies on HZ_CONTACT_POINTS
12.1.1
-
APPS.HZ_MATCH_RULE_41 dependencies on HZ_CONTACT_POINTS
12.1.1
-
APPS.OKC_DELIVERABLE_WF_PVT dependencies on HZ_CONTACT_POINTS
12.1.1
-
APPS.OKC_REP_UTIL_PVT dependencies on HZ_CONTACT_POINTS
12.1.1
-
APPS.WSH_SITE_CONTACT_PERSON_PKG dependencies on HZ_CONTACT_POINTS
12.1.1
-
APPS.IEX_UWQ_POP_SUM_TBL_PVT dependencies on HZ_CONTACT_POINTS
12.1.1
-
APPS.HZ_MATCH_RULE_58 dependencies on HZ_CONTACT_POINTS
12.1.1
-
APPS.ARH_DQM_TREE_HELPER dependencies on HZ_CONTACT_POINTS
12.1.1
-
APPS.SR_UWQ_INTEG dependencies on HZ_CONTACT_POINTS
12.1.1
-
APPS.HZ_CONTACT_POINT_V2PUB dependencies on HZ_CONTACT_POINTS
12.1.1
-
APPS.HZ_DQM_SYNC dependencies on HZ_CONTACT_POINTS
12.1.1
-
APPS.IBE_QUOTE_SAVESHARE_V2_PVT dependencies on HZ_CONTACT_POINTS
12.1.1
-
APPS.OKL_CURE_REQUEST_PVT dependencies on HZ_CONTACT_POINTS
12.1.1
-
APPS.JTF_TASK_UWQ_PVT dependencies on HZ_CONTACT_POINTS
12.1.1
-
APPS.IBE_MERGE_PVT dependencies on HZ_CONTACT_POINTS
12.1.1
-
APPS.HZ_MATCH_RULE_37 dependencies on HZ_CONTACT_POINTS
12.1.1
-
APPS.HZ_IMP_LOAD_CPT_PKG dependencies on HZ_CONTACT_POINTS
12.1.1
-
APPS.XNB_CMN_PVT dependencies on HZ_CONTACT_POINTS
12.1.1
-
APPS.HZ_DQM_DUP_ID_PKG dependencies on HZ_CONTACT_POINTS
12.1.1
-
APPS.WSH_OTM_REF_DATA_GEN_PKG dependencies on HZ_CONTACT_POINTS
12.1.1
-
APPS.HZ_IMP_LOAD_BATCH_COUNTS_PKG dependencies on HZ_CONTACT_POINTS
12.1.1
-
APPS.HZ_MERGE_PKG dependencies on HZ_CONTACT_POINTS
12.1.1
-
APPS.JTF_TASK_PHONES_PUB dependencies on HZ_CONTACT_POINTS
12.1.1
-
APPS.ECE_TRADING_PARTNERS_PUB dependencies on HZ_CONTACT_POINTS
12.1.1
-
APPS.IEX_CUST_OVERVIEW_PVT dependencies on HZ_CONTACT_POINTS
12.1.1
-
APPS.CSD_OM_INTERFACE_PVT dependencies on HZ_CONTACT_POINTS
12.1.1
-
APPS.CSD_PARTIES_UTIL dependencies on HZ_CONTACT_POINTS
12.1.1
-
APPS.OKL_CS_TRANSFER_ASSUMPTION_PVT dependencies on HZ_CONTACT_POINTS
12.1.1
-
APPS.HZ_MATCH_RULE_6 dependencies on HZ_CONTACT_POINTS
12.1.1
-
APPS.AR_CMGT_DATA_POINTS_PKG dependencies on HZ_CONTACT_POINTS
12.1.1
-
APPS.HZ_MATCH_RULE_52 dependencies on HZ_CONTACT_POINTS
12.1.1
-
APPS.WSH_CARRIER_CONTACT_INFO_PKG dependencies on HZ_CONTACT_POINTS
12.1.1
-
APPS.ARH_DQM_CUST_HELPER dependencies on HZ_CONTACT_POINTS
12.2.2
-
APPS.HZ_MATCH_RULE_99 dependencies on HZ_CONTACT_POINTS
12.2.2
-
APPS.AS_IMPORT_SL_PVT dependencies on HZ_CONTACT_POINTS
12.2.2
-
APPS.AP_VENDOR_PARTY_MERGE_PKG dependencies on HZ_CONTACT_POINTS
12.2.2
-
APPS.AST_ROUTING_PUB dependencies on HZ_CONTACT_POINTS
12.2.2
-
APPS.AR_GTA_TXT_OPERATOR_PROC dependencies on HZ_CONTACT_POINTS
12.2.2
-
APPS.IBE_QUOTE_SAVESHARE_PVT dependencies on HZ_CONTACT_POINTS
12.2.2
-
APPS.JG_ZZ_SUMMARY_AR_PKG dependencies on HZ_CONTACT_POINTS
12.2.2
-
APPS.CS_STD dependencies on HZ_CONTACT_POINTS
12.2.2
-
APPS.HZ_MATCH_RULE_240 dependencies on HZ_CONTACT_POINTS
12.2.2