Results for “hz_organization_info_v2pub”

50+ results




Overview
Explore in AI Chat

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

HZ_ORGANIZATION_INFO_V2PUB is a public PL/SQL API within the Oracle E-Business Suite Trading Community Architecture (TCA) schema APPS. It is classified as a PUB (public) API, meaning it is intended for supported, external invocation by other Oracle applications, partner integrations, and customer extensions. The package provides the programmatic interface for maintaining the financial reporting and financial numbering information associated with organizations registered in the TCA model.

Within the Trading Community Architecture, organizations such as customers, suppliers, banks, and legal entities may carry financial identifiers and financial report data used for credit, regulatory, and compliance purposes. HZ_ORGANIZATION_INFO_V2PUB encapsulates the create, update, and retrieval logic for two closely related entities: financial reports and financial numbers. By centralizing this logic, the package enforces TCA validation rules, standard concurrent processing conventions, and consistent error handling through the FND_API framework rather than permitting direct DML against the underlying tables.

Key Procedures and Functions

The ETRM metadata documents six public procedures and functions within this package. Each addresses one of the two financial entity types.

The naming convention follows the TCA V2PUB pattern, in which create and update operations return status and message information through the standard FND_API error-handling mechanism. Parameter lists are not documented in the available metadata and should be confirmed against the package specification in the target environment.

Tables Accessed

The package operates against two documented base tables, accessed through APPS synonyms:

  • HZ_FINANCIAL_NUMBERS — Stores financial number records associated with organizations, including the financial identifier value and its classification. The CREATE_FINANCIAL_NUMBER and UPDATE_FINANCIAL_NUMBER procedures write to this table, while GET_FINANCIAL_NUMBER_REC reads from it.
  • HZ_FINANCIAL_REPORTS — Stores financial report records for organizations. CREATE_FINANCIAL_REPORT and UPDATE_FINANCIAL_REPORT write to this table, and GET_FINANCIAL_REPORT_REC reads from it.

Direct DML against these tables by external code is not supported; all modifications are expected to flow through this package to preserve data integrity and TCA validation.

Usage Notes

HZ_ORGANIZATION_INFO_V2PUB is referenced by six other packages in the ETRM dependency graph, including HZ_BUSINESS_EVENT_V2PVT, HZ_MAP_PARTY_PUB, HZ_ORGANIZATION_BO_PUB, HZ_ORGANIZATION_INFO_V2PVT, HZ_ORGANIZATION_INFO_V2PUB_JW, and HZ_REGISTRY_VALIDATE_V2PUB. This indicates the package is invoked both by Oracle's internal TCA business object layer and by registry validation logic during organization registration and maintenance. Itself, the package depends on FND_API and the SYS STANDARD package.

Typical invocation scenarios include TCA-based Oracle Forms for organization and customer maintenance, concurrent programs that load or synchronize financial data, and custom PL/SQL integrations that register or update organizations. Because it is a PUB API, it is the supported integration point for external systems needing to maintain financial report and financial number data. Callers should adhere to the standard FND_API calling convention, checking the returned status and interpreting the API's error messages rather than relying on exceptions.