Search Results ozf_le_upgrade_pvt




Overview
Explore in AI Chat

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

Overview

OZF_LE_UPGRADE_PVT is a private PL/SQL package owned by the APPS schema in Oracle E-Business Suite. It belongs to the Oracle Trade Management (OZF) product family and supports upgrade and migration processing for the Legal Entity (LE) data model. The PKG suffix "PVT" indicates that this is an internal, private API: it is not intended for direct invocation by external applications, forms, or custom code, and Oracle does not publish a supported signature for it.

The package exists primarily to reconcile and migrate trade management data — most notably claims records — against the legal entity structures introduced or consolidated across releases. In EBS 12.1.1 and 12.2.2, legal entity information is maintained through the XLE (Legal Entity) schema, and upgrade logic frequently must map legacy organization-based or operating-unit-based references to standardized legal entity identifiers. OZF_LE_UPGRADE_PVT provides that translation layer as part of the broader upgrade driver sequence. Its ETRM status is VALID in the 12.2.2 documentation set, confirming that it is a live, compiled object in a supported release.

Key Procedures and Functions

The documented metadata lists a single program unit within the package:

  • START_PROCESS — The entry point that drives the upgrade/processing activity performed by the package. In keeping with the private-API classification, it is a single control procedure that coordinates the package's internal logic rather than a granular, reusable business API. Detailed parameter lists are not published in the ETRM documentation and should not be assumed; the procedure is expected to be called by Oracle's own upgrade scripts or another internal driver with the appropriate context already established.

Because the package body and specification are not itemized in the available metadata, no additional subprograms should be inferred. Any behavior beyond START_PROCESS is encapsulated and subject to change between patch levels without notice.

Tables Accessed

Two tables are documented as referenced through APPS synonyms:

  • OZF_CLAIMS_ALL — The primary Trade Management claims table. The upgrade process reads and potentially updates claim records so that they align with the revised legal entity model, ensuring claims remain attributable to a valid legal entity after the upgrade completes.
  • XLE_ENTITY_PROFILES — The legal entity profiles table maintained by the Legal Entity (XLE) module. It supplies the valid legal entity identifiers that the upgrade uses as the target for re-pointing or validating trade management data.

These two dependencies frame the package's role: it bridges claim data in the OZF schema with the authoritative legal entity definitions in XLE.

Usage Notes

OZF_LE_UPGRADE_PVT is an internal upgrade utility and should not be called from customer-written code, Forms personalizations, or concurrent program registrations. It is most commonly executed in these contexts:

  • As part of Oracle's standard EBS upgrade or patch driver scripts when moving to or within 12.1.1 / 12.2.2, particularly during legal entity data consolidation steps.
  • Indirectly through the OZF product's own upgrade orchestration; the ETRM dependency data shows the package referencing only SYS.STANDARD and being referenced by itself, with no external packages depending on it, confirming its isolated, private status.
  • In diagnostics or data-remediation scenarios under Oracle Support direction, where a support engineer may invoke START_PROCESS manually to reprocess partially migrated claims data.

Because the object is VALID but private, any direct call carries risk of inconsistent results; the supported approach is to rely on the delivered upgrade path and to raise a Service Request if claims and legal entity data appear out of synchronization after an upgrade.