Search Results hz_populate_bot_pkg




Overview
Explore in AI Chat

Overview

HZ_POPULATE_BOT_PKG is a technical PL/SQL package body in the APPS schema of Oracle E-Business Suite Release 12. It supports the Business Object Tracking (BOT) feature within the Trading Community Architecture (TCA) and Oracle Customer Data Management (CDM) modules. Its primary purpose is to seed and maintain the HZ_BUS_OBJ_TRACKING infrastructure, which records the state and lineage of business objects such as parties, customer accounts, sites, and contact entities as they are created or modified within TCA.

The package is classified as OTHER in the 12.2.2 ETRM metadata, indicating it is not a public or supported API surface but rather a utility package invoked by other TCA and CDM internal components. It carries no declared public API contract through FND_API, though it depends on FND_API for standard return-status and message-handling conventions. The package is VALID across both 12.1.1 and 12.2.2, though it is not referenced by any database object directly — it is a dependent package that calls into other TCA packages and tables rather than being called directly by triggers or views.

Key Procedures and Functions

The documented package body exposes 34 procedures, each following a consistent naming convention of POP_<TABLE_NAME>. Each procedure corresponds to a specific TCA entity and is responsible for inserting or refreshing a tracking record in HZ_BUS_OBJ_TRACKING for that entity. Documented procedures include:

Each procedure operates on a single entity and writes a corresponding tracking entry, preserving the object’s change history for CDM reconciliation and merge processing.

Tables Accessed

The package references a broad set of TCA and receivables tables through APPS synonyms. The central write target is HZ_BUS_OBJ_TRACKING, which stores tracking metadata for every business object. Supporting reads and writes span the full party model: HZ_PARTIES, HZ_PARTY_SITES, HZ_PARTY_SITE_USES, HZ_PARTY_PREFERENCES, HZ_PARTY_USG_ASSIGNMENTS, HZ_PARTY_SITES_EXT_B, HZ_ORG_CONTACTS, HZ_ORG_CONTACT_ROLES, HZ_ORGANIZATION_PROFILES, HZ_ORG_PROFILES_EXT_B, HZ_PERSON_PROFILES, HZ_PER_PROFILES_EXT_B, HZ_PERSON_LANGUAGE, HZ_PERSON_INTEREST, HZ_RELATIONSHIPS, HZ_ROLE_RESPONSIBILITY, HZ_WORK_CLASS, HZ_LOCATIONS, HZ_LOCATIONS_EXT_B, HZ_EDUCATION, HZ_EMPLOYMENT_HISTORY, HZ_FINANCIAL_NUMBERS, HZ_FINANCIAL_PROFILE, HZ_FINANCIAL_REPORTS, HZ_CREDIT_RATINGS, HZ_CERTIFICATIONS, HZ_CITIZENSHIP, HZ_CODE_ASSIGNMENTS, HZ_CONTACT_POINTS, HZ_CONTACT_PREFERENCES, HZ_CUSTOMER_PROFILES, HZ_CUST_ACCOUNTS, HZ_CUST_ACCOUNT_ROLES, HZ_CUST_ACCT_RELATE_ALL, HZ_CUST_ACCT_SITES_ALL, HZ_CUST_PROFILE_AMTS, HZ_CUST_SITE_USES_ALL, and RA_CUST_RECEIPT_METHODS. These tables provide the source entity rows whose tracking state must be registered or updated in HZ_BUS_OBJ_TRACKING.

Usage Notes

HZ_POPULATE_BOT_PKG is not intended for direct invocation by end users or custom code. It is invoked internally by TCA and CDM components, particularly during party creation, updates, and customer data merge or deduplication operations. Because it is called by 22 other packages and depends on HZ_UTILITY_V2PUB and FND_LOG, it is part of the technical plumbing that supports the Oracle Customer Data Management Hub. Concurrent programs such as the Customer Data Management sync and party import processes may indirectly trigger these procedures. Customizations should avoid calling these procedures directly; instead, use the supported HZ_* public APIs. Modifications to this package are not recommended because it is an internal implementation detail whose behavior is subject to change across patch levels. In 12.2.2, the package remains VALID and continues to support the same object tracking semantics as 12.1.1.