Search Results hz_mosr_validate_pkg




Overview
Explore in AI Chat

Overview

HZ_ORIG_SYSTEM_REF_PVT is the private implementation package for the Oracle E-Business Suite Trading Community Architecture (TCA) original system reference framework. It resides in the APPS schema and carries an API classification of PVT, meaning it is intended to be invoked exclusively by the corresponding public package, HZ_ORIG_SYSTEM_REF_PUB, and by other TCA infrastructure packages rather than by external custom code. The package provides the core business logic that lets Oracle EBS record and maintain the linkage between a party or party-related entity and the identifier that identifies that same entity in an external or legacy source system. This capability underpins customer and contact data migration, multi-source data consolidation, duplicate prevention, and party merge processing across Oracle Receivables, Oracle Customers Online, and related TCA applications. Because the object holds a VALID status in the APPS schema for both 12.1.1 and 12.2.2, it is part of the supported, delivered code line.

Key Procedures and Functions

The documented package exposes eleven procedures and functions. CREATE_ORIG_SYSTEM_REFERENCE and UPDATE_ORIG_SYSTEM_REFERENCE handle the creation and maintenance of individual original system reference records for a given entity. CREATE_ORIG_SYS_ENTITY_MAPPING and UPDATE_ORIG_SYS_ENTITY_MAPPING manage the cross-reference mapping that ties an original system reference to a specific TCA entity. CREATE_ORIG_SYSTEM and UPDATE_ORIG_SYSTEM maintain the definition of the originating system itself. CREATE_MOSR_FOR_MERGE supports party merge operations by constructing the references required when records are consolidated. REMAP_INTERNAL_IDENTIFIER reassigns an internal identifier, a function critical during merge and renumbering activities. GET_ORIG_SYS_REFERENCE_REC and GET_PARTY_ID are retrieval functions that return reference records and resolve the owning party identifier respectively. GET_SOURCE_SYSTEM_COUNT returns a count of source systems associated with an entity, commonly used for validation and duplicate checking.

Tables Accessed

The package reads and writes the foundational HZ tables through APPS synonyms. HZ_ORIG_SYS_REFERENCES and HZ_ORIG_SYS_MAPPING store the actual original system reference and mapping data, while HZ_ORIG_SYSTEMS_B holds the registered source system definitions. Party-level records are maintained in HZ_PARTIES and HZ_RELATIONSHIPS, with party site information in HZ_PARTY_SITES. Customer data flows through HZ_CUST_ACCOUNTS, HZ_CUST_ACCOUNT_ROLES, HZ_CUST_ACCT_SITES_ALL, and HZ_CUST_SITE_USES_ALL. Contact data is drawn from HZ_ORG_CONTACTS, HZ_ORG_CONTACT_ROLES, and HZ_CONTACT_POINTS, and descriptive attributes from HZ_ENTITY_ATTRIBUTES.

Usage Notes

Because this is a private package, it should not be called directly from custom code. Instead, developers invoke HZ_ORIG_SYSTEM_REF_PUB, which delegates to HZ_ORIG_SYSTEM_REF_PVT after performing public API validation. The package is referenced by ARP_CMERGE_ARCUS, HZ_MERGE_PKG, HZ_MOSR_VALIDATE_PKG, HZ_ORIG_SYSTEM_REF_PUB, and HZ_ORIG_SYSTEM_REF_PVT_JW, confirming its role in customer merge, source system validation, and Java Web Services integration. It is typically triggered by TCA forms, party merge concurrent programs, and bulk import processes that register legacy identifiers, rather than being exposed to end users directly. Customizations should always target the public wrapper to remain upgrade-safe.