Search Results hz_parties
The HZ_PARTIES
table is a fundamental component of Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2, serving as the central repository for all business entities within the Trading Community Architecture (TCA) module. TCA is a shared infrastructure that provides a unified data model for managing customer, supplier, and partner information across Oracle EBS applications. The HZ_PARTIES
table stores high-level information about parties, which can be individuals, organizations, or groups, and acts as the parent table for related entities such as customer accounts, addresses, and contact points.
In Oracle EBS 12.1.1 and 12.2.2, the HZ_PARTIES
table contains critical attributes that define the identity and classification of a party. Key columns include:
PARTY_ID
: A unique identifier for each party, serving as the primary key.PARTY_NUMBER
: A user-assigned or system-generated identifier for reference.PARTY_NAME
: The name of the party (e.g., individual name or organization name).PARTY_TYPE
: Specifies whether the party is anORGANIZATION
,PERSON
, orGROUP
.STATUS
: Indicates the active/inactive status of the party.CREATED_BY_MODULE
: Tracks the source application that created the party record.
The HZ_PARTIES
table integrates with other TCA tables to provide a comprehensive view of business relationships. For example:
HZ_PARTY_SITES
: Links parties to physical or digital addresses.HZ_CONTACT_POINTS
: Stores communication details like phone numbers and email addresses.HZ_CUST_ACCOUNTS
: Extends party data for customer-specific attributes in Order Management and Receivables.HZ_ORGANIZATION_PROFILES
: Captures additional organization-specific details.
In Oracle EBS 12.2.2, enhancements to the TCA model include improved data quality controls and support for globalization, such as multi-language party names and addresses. The HZ_PARTIES
table also plays a pivotal role in data security through VPD (Virtual Private Database) policies, restricting access based on operating unit or responsibility. Customizations or extensions to the table should adhere to Oracle's guidelines to avoid upgrade conflicts, as the TCA schema is heavily leveraged by standard APIs like HZ_PARTY_API
for CRUD operations.
For reporting and analytics, the HZ_PARTIES
table is frequently joined with transactional tables (e.g., OE_ORDER_HEADERS
or AP_INVOICES
) to analyze customer or supplier behavior. Performance optimization techniques, such as indexing on PARTY_ID
and PARTY_NUMBER
, are recommended for large-scale deployments. In summary, the HZ_PARTIES
table is the cornerstone of party management in Oracle EBS 12.1.1 and 12.2.2, enabling centralized, reliable, and scalable master data governance across the enterprise.
-
Table: HZ_PARTIES
12.2.2
owner:AR, object_type:TABLE, fnd_design_data:AR.HZ_PARTIES, object_name:HZ_PARTIES, status:VALID, product: AR - Receivables , description: Information about parties such as organizations, people, and groups , implementation_dba_data: AR.HZ_PARTIES ,
-
Table: HZ_PARTIES
12.1.1
owner:AR, object_type:TABLE, fnd_design_data:AR.HZ_PARTIES, object_name:HZ_PARTIES, status:VALID, product: AR - Receivables , description: Information about parties such as organizations, people, and groups , implementation_dba_data: AR.HZ_PARTIES ,
-
APPS.FII_AR_TPDUE_TBL_REFRESH dependencies on HZ_PARTIES
12.1.1
-
APPS.IBY_FNDCPT_COMMON_PUB dependencies on HZ_PARTIES
12.1.1
-
APPS.IGS_FI_GEN_007 dependencies on HZ_PARTIES
12.1.1
-
APPS.IGS_AD_TST_UH_PKG dependencies on HZ_PARTIES
12.1.1
-
APPS.QP_INT_LOADER_PUB dependencies on HZ_PARTIES
12.1.1
-
APPS.ENGECOBO dependencies on HZ_PARTIES
12.1.1
-
APPS.ENG_ENGRCNDR_XMLP_PKG dependencies on HZ_PARTIES
12.1.1
-
APPS.FV_RECEIVABLES_ACTIVITY_PKG dependencies on HZ_PARTIES
12.1.1
-
APPS.PON_NEW_SUPPLIER_REG_PKG dependencies on HZ_PARTIES
12.1.1
-
APPS.HZ_MATCH_RULE_53 dependencies on HZ_PARTIES
12.1.1
-
APPS.AR_RECEIPT_LIB_PVT dependencies on HZ_PARTIES
12.1.1
-
APPS.IBE_PARTY_V2PVT dependencies on HZ_PARTIES
12.1.1
-
APPS.HZ_MATCH_RULE_99 dependencies on HZ_PARTIES
12.1.1
-
APPS.GR_VALIDATE dependencies on HZ_PARTIES
12.1.1
-
APPS.OKL_ACTIVATE_IB_PVT dependencies on HZ_PARTIES
12.1.1
-
APPS.IGS_CO_SUBMIT dependencies on HZ_PARTIES
12.1.1
-
APPS.ZX_TRN_VALIDATION_PKG dependencies on HZ_PARTIES
12.1.1
-
APPS.AR_PURGE dependencies on HZ_PARTIES
12.1.1
-
APPS.IGS_FI_PRC_LOCKBOX dependencies on HZ_PARTIES
12.1.1
-
APPS.ARP_RW_BATCHES_PKG dependencies on HZ_PARTIES
12.1.1
-
APPS.IGS_FI_PRC_APINT dependencies on HZ_PARTIES
12.1.1
-
APPS.ASO_CHECK_TCA_PVT dependencies on HZ_PARTIES
12.1.1
-
APPS.OE_OE_HTML_HEADER dependencies on HZ_PARTIES
12.1.1
-
APPS.HZ_ORIG_SYSTEM_REF_PVT dependencies on HZ_PARTIES
12.1.1
-
APPS.OE_HEADER_UTIL dependencies on HZ_PARTIES
12.1.1
-
APPS.OKL_DEAL_CREAT_PVT dependencies on HZ_PARTIES
12.1.1
-
APPS.ASL_EXCEL_UTIL_PVT dependencies on HZ_PARTIES
12.1.1
-
APPS.PV_ASSIGNMENT_PVT dependencies on HZ_PARTIES
12.1.1
-
APPS.AHL_DI_DOC_INDEX_PVT dependencies on HZ_PARTIES
12.1.1
-
APPS.CSI_DIAGNOSTICS_PKG dependencies on HZ_PARTIES
12.1.1
-
APPS.RLM_PS_SV dependencies on HZ_PARTIES
12.1.1
-
APPS.HZ_BES_BO_RAISE_PKG dependencies on HZ_PARTIES
12.1.1
-
APPS.PA_ADVERTISEMENTS_PVT dependencies on HZ_PARTIES
12.1.1
-
APPS.IGS_PE_GEN_001 dependencies on HZ_PARTIES
12.1.1
-
APPS.IEX_OPEN_INTERFACE_PUB dependencies on HZ_PARTIES
12.1.1
-
APPS.HZ_EXTRACT_CUST_ACCT_BO_PVT dependencies on HZ_PARTIES
12.1.1
-
APPS.OKL_SLA_ACC_SOURCES_PVT dependencies on HZ_PARTIES
12.1.1
-
APPS.IBE_UTIL dependencies on HZ_PARTIES
12.1.1
-
APPS.CS_CHG_AUTO_SUB_CON_PKG dependencies on HZ_PARTIES
12.1.1
-
APPS.OE_OE_INLINE_ADDRESS dependencies on HZ_PARTIES
12.1.1
-
APPS.IBY_PAYMENT_FORMAT_VAL_PVT dependencies on HZ_PARTIES
12.1.1
-
APPS.AP_MATCHING_UTILS_PKG dependencies on HZ_PARTIES
12.1.1
-
APPS.RCV_RMA_TRANSACTIONS dependencies on HZ_PARTIES
12.1.1
-
APPS.CS_ASSIGN_RESOURCE_CON_PKG dependencies on HZ_PARTIES
12.1.1
-
APPS.OE_BATCH_PRICING dependencies on HZ_PARTIES
12.1.1
-
APPS.EGO_DATA_SECURITY dependencies on HZ_PARTIES
12.1.1
-
APPS.HZ_DQM_QUALITY_UH_PKG dependencies on HZ_PARTIES
12.1.1
-
APPS.PA_WORKFLOW_HISTORY dependencies on HZ_PARTIES
12.1.1