Search Results hz_orig_system_ref_pub_jw

Overview

The APPS.HZ_ORIG_SYSTEM_REF_PUB_JW package body is a public PL/SQL package in the Oracle E-Business Suite Trading Community Architecture (TCA) module. The _JW suffix identifies it as a Java Web Services wrapper, a generated companion to the base package HZ_ORIG_SYSTEM_REF_PUB. Its function is to expose the original system reference APIs of the TCA Registry to external or service-oriented callers, allowing integration layers, middleware, and Java-based web service clients to create and maintain the mappings between records in the EBS instance and their counterparts in external or legacy source systems. In EBS 12.1.1 and 12.2.2 the object is shipped in the APPS schema with a status of VALID. The ETRM classifies the API as OTHER, indicating it is a supporting wrapper rather than a primary business API, and it is documented as not being referenced by any other database object.

Key Procedures and Functions

The documented interface comprises four entry points. The metadata records only their names and purpose, so parameter signatures are not reproduced here.

• GET_ORIG_SYS_ENTITY_MAP_REC_1 — Retrieves the original system entity mapping record, returning the mapping that ties an entity in the EBS Registry to its definition in an external source system.
• GET_ORIG_SYS_REFERENCE_REC_2 — Retrieves an original system reference record, returning the stored cross-reference between a TCA entity and the corresponding key value in the source system.
• CREATE_ORIG_SYSTEM_REFERENC_3 — Creates a new original system reference, inserting the cross-reference that links an EBS entity to an identifier supplied by an external system.
• UPDATE_ORIG_SYSTEM_REFERENC_4 — Updates an existing original system reference, modifying the stored cross-reference value when the source system key changes.

Tables Accessed

The ETRM metadata for this package does not enumerate the underlying tables through APPS synonyms; the logical target of the read and write operations is the TCA original system reference schema, principally HZ_ORIG_SYS_REFERENCES and its associated entity-mapping structures. The GET procedures read these tables to return the current cross-reference or entity mapping. The CREATE and UPDATE procedures write to them to register a new original system reference or to amend an existing one. Because access occurs through APPS synonyms, the package executes with the privileges of the APPS schema and observes the same TCA validation and security rules as the base public API.

Usage Notes

This wrapper is invoked whenever TCA original system reference data must be manipulated from outside PL/SQL, typically through Java web services, SOA composites, or middleware adapters that call the published interface rather than the base package. It is not referenced by any other database object, confirming that it is a leaf integration point rather than a component of internal EBS processing. Its only recorded dependencies are the standard Oracle packages FND_API and STANDARD, and the base package HZ_ORIG_SYSTEM_REF_PUB, which carries the substantive implementation. Consequently, custom code and integration teams should treat HZ_ORIG_SYSTEM_REF_PUB as the authoritative API and regard this package as the service-facing façade. The presence of the same object at both 12.1.1 and 12.2.2 indicates a stable, long-standing interface suitable for cross-release integrations.