Search Results ozf_product_allocations_pkg




Overview
Explore in AI Chat

Overview

OZF_PRODUCT_ALLOCATIONS_PKG is a PL/SQL package owned by the APPS schema that supports the Oracle E-Business Suite Trade Management (ETRM) product allocation feature. Product allocations allow organizations to define how limited or controlled product quantities are distributed across customers, segments, or channels within a defined period. The package encapsulates the core data manipulation logic against the OZF_PRODUCT_ALLOCATIONS table, providing a controlled API layer through which allocation records are created, modified, removed, and locked.

In the ETRM architecture, this package serves as a low-level persistence utility. It is classified as an OTHER API in the ETRM 12.2.2 metadata and does not expose public business-level workflow methods; instead, it provides the row-level operations that higher-level engine and public packages invoke. The package is documented as VALID in the APPS schema for both EBS 12.1.1 and 12.2.2 environments and references FND_MSG_PUB for message handling, indicating standardized error and notification behavior consistent with Oracle Application Object Library conventions.

Key Procedures and Functions

  • INSERT_ROW — Inserts a new product allocation record into the OZF_PRODUCT_ALLOCATIONS table, setting the attribute values supplied by the calling process and applying standard WHO column handling.
  • UPDATE_ROW — Updates an existing product allocation row, allowing the caller to modify the mutable attributes of a previously created allocation record.
  • DELETE_ROW — Removes a product allocation record from the underlying table, supporting maintenance and cleanup of obsolete or superseded allocation definitions.
  • LOCK_ROW — Acquires a row-level lock on the target allocation record, providing concurrency control so that competing sessions do not simultaneously modify the same allocation row.

Each procedure follows the CRUD-plus-locking pattern typical of Oracle EBS table-handler packages. Parameter lists are not reproduced here because the ETRM metadata does not document them; consumers should inspect the package specification in the APPS schema to confirm exact signatures before invoking these routines directly.

Tables Accessed

The package operates primarily on OZF_PRODUCT_ALLOCATIONS, accessed through the APPS synonym. This table stores the allocation definitions that drive product allocation processing in Trade Management. All four documented procedures act on this table: INSERT_ROW adds records, UPDATE_ROW modifies them, DELETE_ROW removes them, and LOCK_ROW selects a row for update.

The package also references DUAL, which is used for lightweight PL/SQL evaluations, sequence retrieval, or value checks that do not require a physical table. Message handling is performed through the dependency on FND_MSG_PUB, the standard Oracle Application Object Library message dictionary package.

Usage Notes

OZF_PRODUCT_ALLOCATIONS_PKG is an internal dependency rather than a standalone entry point. The ETRM metadata records that it is referenced by OZF_ALLOCATION_ENGINE_PVT and OZF_QUOTA_PUB, and it also references itself, confirming an internal call pattern. The allocation engine relies on this package to persist allocation records during allocation processing, while the quota public API uses it when quota-related operations touch allocation data.

Because the package is not classified as a public API, direct invocation from custom code is generally discouraged. Customers and integrators should instead use the documented public APIs such as OZF_QUOTA_PUB, which in turn call this package. When debugging allocation record behavior—such as unexpected inserts, updates, or lock waits on OZF_PRODUCT_ALLOCATIONS—the package is a relevant point of investigation, and its dependency on FND_MSG_PUB means errors are surfaced through the standard EBS message framework. As with all APPS-schema objects, any customization should be performed through supported extension mechanisms rather than modification of the packaged code.