Search Results hz_cust_accounts
The HZ_CUST_ACCOUNTS
table is a fundamental component of Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically within the Trading Community Architecture (TCA) module. It serves as the central repository for storing customer account information, enabling organizations to manage customer relationships, transactions, and interactions efficiently. This table is part of the broader Oracle TCA framework, which provides a unified model for managing complex customer data across multiple business functions, including Order Management, Receivables, and Service Contracts.
Structure and Key Columns
TheHZ_CUST_ACCOUNTS
table contains critical columns that define customer accounts, such as:
- CUST_ACCOUNT_ID: Primary key uniquely identifying each customer account.
- PARTY_ID: Foreign key linking to the
HZ_PARTIES
table, associating the account with a party (individual or organization). - ACCOUNT_NUMBER: User-defined identifier for the customer account.
- STATUS: Indicates the active/inactive status of the account (e.g., 'A' for active, 'I' for inactive).
- CUSTOMER_TYPE: Classifies the account (e.g., 'I' for individual, 'O' for organization).
- CUSTOMER_CLASS_CODE: Categorizes the account based on predefined classes.
- PRIMARY_PHONE_CONTACT_PT_ID: References the primary phone contact point in
HZ_CONTACT_POINTS
. - LAST_UPDATE_DATE and CREATION_DATE: Audit columns tracking record changes.
Functional Role in Oracle EBS
The table plays a pivotal role in customer-centric processes:- Order Management: Links sales orders to customer accounts, ensuring accurate billing and shipping.
- Accounts Receivable: Tracks invoices, payments, and credit limits associated with accounts.
- Service Contracts: Manages service agreements tied to customer accounts.
- Customer Hierarchy: Supports parent-child relationships between accounts for consolidated reporting.
Integration with Other TCA Tables
HZ_CUST_ACCOUNTS
integrates with key TCA tables:
- HZ_PARTIES: Stores party details (name, tax identifiers).
- HZ_CUST_ACCT_SITES_ALL: Manages account addresses and site uses.
- HZ_CUSTOMER_PROFILES: Stores credit and payment terms.
- HZ_RELATIONSHIPS: Defines relationships between accounts/parties.
Technical Considerations
- Indexing: Primary key (
CUST_ACCOUNT_ID
) and foreign key (PARTY_ID
) are indexed for performance. - Multi-Org Support: In EBS 12.2.2, the table is multi-org enabled via
ORG_ID
column. - Data Security: Access controlled via Oracle's Function Security and VPD policies.
- API Usage: Modifications should use TCA APIs (
HZ_CUST_ACCOUNT_V2PUB
) rather than direct DML.
Customization and Extensions
Organizations often extend the table via:- Descriptive Flexfields (DFFs): Adding custom attributes.
- Business Events: Triggering workflows on account status changes.
- Views: Creating custom joins for reporting (e.g.,
HZ_CUSTOMERS
view).
Upgrade Implications
Between EBS 12.1.1 and 12.2.2, the table structure remains largely consistent, but 12.2.2 introduces:- Enhanced multi-org support.
- Improved performance through partitioning options.
- Tighter integration with Oracle Fusion Middleware.
HZ_CUST_ACCOUNTS
is the cornerstone of customer data management in Oracle EBS, enabling end-to-end customer lifecycle processes while maintaining data integrity through its relational design and API-driven access model.
-
Table: HZ_CUST_ACCOUNTS
12.1.1
owner:AR, object_type:TABLE, fnd_design_data:AR.HZ_CUST_ACCOUNTS, object_name:HZ_CUST_ACCOUNTS, status:VALID, product: AR - Receivables , description: Stores information about customer accounts. , implementation_dba_data: AR.HZ_CUST_ACCOUNTS ,
-
Table: HZ_CUST_ACCOUNTS
12.2.2
owner:AR, object_type:TABLE, fnd_design_data:AR.HZ_CUST_ACCOUNTS, object_name:HZ_CUST_ACCOUNTS, status:VALID, product: AR - Receivables , description: Stores information about customer accounts. , implementation_dba_data: AR.HZ_CUST_ACCOUNTS ,
-
APPS.XLA_TB_AP_REPORT_PVT dependencies on HZ_CUST_ACCOUNTS
12.1.1
-
APPS.INV_LABEL_PVT7 dependencies on HZ_CUST_ACCOUNTS
12.1.1
-
APPS.MRP_CL_FUNCTION dependencies on HZ_CUST_ACCOUNTS
12.1.1
-
APPS.IGIRRPI dependencies on HZ_CUST_ACCOUNTS
12.1.1
-
APPS.OZF_QP_QUAL_PVT dependencies on HZ_CUST_ACCOUNTS
12.1.1
-
APPS.AR_AME_CM_ATTRIBUTES_API dependencies on HZ_CUST_ACCOUNTS
12.1.1
-
APPS.OKL_CREDIT_PUB dependencies on HZ_CUST_ACCOUNTS
12.1.1
-
APPS.AR_BILLS_CREATION_VAL_PVT dependencies on HZ_CUST_ACCOUNTS
12.1.1
-
APPS.QOT_DEFAULT_PVT dependencies on HZ_CUST_ACCOUNTS
12.1.1
-
APPS.CE_AUTO_BANK_MATCH dependencies on HZ_CUST_ACCOUNTS
12.1.1
-
APPS.ARP_EXCHANGE_MERGE dependencies on HZ_CUST_ACCOUNTS
12.1.1
-
APPS.JTF_TASK_CUST_MERGE_PKG dependencies on HZ_CUST_ACCOUNTS
12.1.1
-
APPS.OZF_SD_REQUEST_PUB dependencies on HZ_CUST_ACCOUNTS
12.1.1
-
APPS.FII_AR_REVENUE_B_C dependencies on HZ_CUST_ACCOUNTS
12.1.1
-
APPS.OE_DEFAULT_PVT dependencies on HZ_CUST_ACCOUNTS
12.1.1
-
APPS.AR_RAXIIR_XMLP_PKG dependencies on HZ_CUST_ACCOUNTS
12.1.1
-
APPS.SR_UWQ_INTEG dependencies on HZ_CUST_ACCOUNTS
12.1.1
-
APPS.CSI_MASS_EDIT_PUB dependencies on HZ_CUST_ACCOUNTS
12.1.1
-
APPS.OKE_AGREEMENT_PVT dependencies on HZ_CUST_ACCOUNTS
12.1.1
-
APPS.LNS_REP_UTILS dependencies on HZ_CUST_ACCOUNTS
12.1.1
-
APPS.HZ_CUST_ACCOUNT_SITE_V2PUB dependencies on HZ_CUST_ACCOUNTS
12.1.1
-
APPS.GMD_COMMON_VAL dependencies on HZ_CUST_ACCOUNTS
12.1.1
-
APPS.CN_GET_TX_DATA_PUB dependencies on HZ_CUST_ACCOUNTS
12.1.1
-
APPS.JA_CN_ACC_JE_ITEMIZATION_PKG dependencies on HZ_CUST_ACCOUNTS
12.1.1
-
APPS.CSL_SERVICE_REQUESTS_PKG dependencies on HZ_CUST_ACCOUNTS
12.1.1
-
APPS.OKL_PARTY_MERGE_PUB dependencies on HZ_CUST_ACCOUNTS
12.1.1
-
APPS.DPP_ACCOUNT_MERGE_PVT dependencies on HZ_CUST_ACCOUNTS
12.1.1
-
APPS.PA_PROJECTS_MAINT_PVT dependencies on HZ_CUST_ACCOUNTS
12.1.1
-
APPS.HZ_ACCOUNT_VALIDATE_V2PUB dependencies on HZ_CUST_ACCOUNTS
12.1.1
-
APPS.HZ_CONTACT_POINT_V2PUB dependencies on HZ_CUST_ACCOUNTS
12.1.1
-
APPS.PNRX_SP_ASSIGN_BY_LEASE dependencies on HZ_CUST_ACCOUNTS
12.1.1
-
APPS.OKL_CREDIT_MGNT_PVT dependencies on HZ_CUST_ACCOUNTS
12.1.1
-
APPS.OE_DEFAULT_LINE dependencies on HZ_CUST_ACCOUNTS
12.1.1
-
APPS.OZF_UTILITY_PVT dependencies on HZ_CUST_ACCOUNTS
12.1.1
-
APPS.INV_MGD_MVT_SO_MDTR dependencies on HZ_CUST_ACCOUNTS
12.1.1
-
APPS.ARRX_COGS_REP_INNER dependencies on HZ_CUST_ACCOUNTS
12.1.1
-
APPS.XTR_HEDGE_PROCESS_P dependencies on HZ_CUST_ACCOUNTS
12.1.1
-
APPS.OZF_CLAIM_ACCRUAL_PVT dependencies on HZ_CUST_ACCOUNTS
12.1.1
-
APPS.ARP_CMREQ_WF dependencies on HZ_CUST_ACCOUNTS
12.1.1
-
APPS.IBE_PRICE_PVT dependencies on HZ_CUST_ACCOUNTS
12.1.1
-
APPS.OKS_TAX_UTIL_PVT dependencies on HZ_CUST_ACCOUNTS
12.1.1
-
APPS.OKL_TEH_PVT dependencies on HZ_CUST_ACCOUNTS
12.1.1
-
APPS.CSI_T_UTILITIES_PVT dependencies on HZ_CUST_ACCOUNTS
12.1.1
-
APPS.WMS_WMSSCHS1_XMLP_PKG dependencies on HZ_CUST_ACCOUNTS
12.1.1
-
APPS.OKS_IMPORT_VALIDATE dependencies on HZ_CUST_ACCOUNTS
12.1.1
-
APPS.AR_ARXKIR_XMLP_PKG dependencies on HZ_CUST_ACCOUNTS
12.1.1
-
APPS.CSM_SERVICE_REQUESTS_PKG dependencies on HZ_CUST_ACCOUNTS
12.1.1
-
APPS.ARP_PROGRAM_BR_REMIT dependencies on HZ_CUST_ACCOUNTS
12.1.1