Search Results ozf_resale_logs_pkg




Overview
Explore in AI Chat

Overview

The APPS.OZF_RESALE_LOGS_PKG package is a PL/SQL API belonging to the Oracle E-Business Suite Trade Management (also referred to as Oracle Channel Revenue Management / ETRM) product family. It provides the canonical data-manipulation interface for the OZF_RESALE_LOGS_ALL table, which stores diagnostic and error information generated during resale processing. Resale records support trade-management resale arrangements, under which product is sold to a reseller for subsequent resale and the manufacturer issues compensating credits or payments. When the resale validation and processing engine encounters a mismatch, invalid value, or business-rule violation, it writes a structured log entry capturing the offending identifier, the nature of the error, and the specific column at fault. This package exposes that logging capability as a set of reusable, callable procedures.

The package is classified as an OTHER API in the ETRM metadata registry, indicating that it is an internal utility API rather than a public, fully supported integration interface. Its header, dated 2005, reflects a mature, stable object carried forward into EBS 12.1.1 and 12.2.2 without functional change.

Key Procedures and Functions

The package exposes four documented procedures. Each maps to a standard DML operation against the underlying table.

  • INSERT_ROW — Creates a new resale log entry. It accepts the resale identifier and its type, the error code and error message, and the name and value of the column responsible for the failure. The primary key (resale_log_id) and org_id are passed as IN OUT NOCOPY parameters, allowing the procedure to return system-generated values to the caller.
  • UPDATE_ROW — Modifies an existing log record, addressed by resale_log_id. All descriptive attributes — resale identifier, resale type, error code, error message, column name, column value, and org_id — may be revised.
  • DELETE_ROW — Removes a log entry identified solely by resale_log_id. This is typically used for purging obsolete diagnostics.
  • LOCK_ROW — Acquires a pessimistic row lock on the specified log record. It accepts the full row payload, consistent with the Oracle Forms lock-and-verify pattern, ensuring the in-memory record still matches the database before an update or delete proceeds.

No functions, and no additional documented procedures, are registered in the ETRM metadata.

Tables Accessed

The package reads and writes a single documented table: OZF_RESALE_LOGS_ALL, referenced through an APPS synonym. The _ALL suffix signifies a multi-organization table protected by Oracle Multi-Org row-level security, which explains the mandatory org_id parameter on every procedure. The table holds one row per logged anomaly, with columns corresponding to the resale ID, resale ID type, error code, error message, offending column name and value, and the owning operating unit.

Usage Notes

OZF_RESALE_LOGS_PKG is an internal utility rather than a user-facing API. It is referenced by three other packages in the ETRM schema, which call INSERT_ROW to record validation failures and diagnostic messages encountered while processing resale data. The LOCK_ROW, UPDATE_ROW, and DELETE_ROW procedures follow the Oracle Forms client/server interchange convention, supporting a maintenance form built directly on OZF_RESALE_LOGS_ALL. Because the procedures commit only their own DML and perform no validation or workflow logic, callers remain responsible for transaction control. Custom code should treat this package as a diagnostic-support component; direct invocation outside the packaged ETRM callers is generally unnecessary and is not covered by Oracle's public API commitment.