Search Results ozf_resale_logs_all




Overview
Explore in AI Chat

Overview

OZF_RESALE_LOGS_ALL is a Trade Management (OZF) transaction log table that captures error and diagnostic information generated during the processing of resale interface records. In Oracle EBS 12.1.1 and 12.2.2, resale data — customer-specific resale numbers, resale identifiers, and related exemption information — is frequently loaded from external systems or partner feeds through an interface/import mechanism. When a record fails validation or encounters a processing exception during that load, a row is written to this table to record the offending value, the column involved, the error code, and a descriptive error message. The table therefore serves as the reconciliation and troubleshooting substrate for the resale interface cycle, allowing functional users and technical support to diagnose why a given resale record was rejected without re-running the entire import.

From a Data Vault modeling perspective, the heuristic classification mined from the foreign-key structure identifies this object as standalone. In practice, the table behaves as a satellite-style audit log: each row is descriptive, event-oriented, and dependent on the identity of the resale record it references rather than acting as an independent hub or a link connecting multiple business entities.

Key Information Stored

The documented physical schema for 12.2.2 contains nine columns. The most significant are:

  • RESALE_LOG_ID — the surrogate primary key, enforced by the OZF_RESALE_LOGS_ALL_PK constraint and additionally backed by the unique index OZF_RESALE_LOGS_ALL_U1. It uniquely identifies each log entry.
  • RESALE_ID — the identifier of the resale record that triggered the logged event. This is the principal business reference used to correlate logs back to the source interface row.
  • RESALE_ID_TYPE — indicates the type or context of the RESALE_ID value, distinguishing among the various identifier schemes used in resale processing.
  • ERROR_CODE — the coded reason the record was rejected, suitable for grouping and trend reporting.
  • ERROR_MESSAGE — the human-readable description accompanying the error code, typically the text surfaced to the user.
  • COLUMN_NAME — the specific interface column that failed validation, enabling column-level root-cause analysis.
  • COLUMN_VALUE — the actual value supplied in that column, preserved for remediation.
  • ORG_ID — the operating unit under which the transaction was processed, supporting multi-org reporting and security.
  • SECURITY_GROUP_ID — a foreign key to FND_SECURITY_GROUPS, used in the standard EBS multi-tenant security model to partition data visibility.

RESALE_LOG_ID is the surrogate key; no separate composite business-key candidate is documented beyond the unique index on RESALE_LOG_ID itself.

Common Use Cases and Queries

Typical usage centers on diagnosing failed resale loads and reporting on interface quality. A common pattern retrieves all errors for a specific resale record:

SELECT resale_log_id, resale_id, column_name, column_value,
       error_code, error_message
FROM   ozf.ozf_resale_logs_all
WHERE  resale_id = :p_resale_id
ORDER BY resale_log_id;

For multi-org environments, queries are usually restricted by ORG_ID and SECURITY_GROUP_ID to respect operating unit and security group boundaries. Error trend reporting aggregates by ERROR_CODE and COLUMN_NAME to identify the most common validation failures across a batch. Because the table retains COLUMN_VALUE, support staff can reproduce or correct the bad input directly. Log rows are generally purged or archived periodically, so reports frequently join back to the resale interface staging table to confirm whether a rejected record was subsequently corrected and reprocessed.

Related Objects

  • FND_SECURITY_GROUPS — joined on SECURITY_GROUP_ID; the only documented foreign-key relationship, providing the security group definition for each log row.
  • Resale interface/staging tables (OZF resale interface objects) — the source of RESALE_ID values; joined to reconcile logged errors against the records that produced them.
  • OZF_RESALE_LOGS_ALL_PK / OZF_RESALE_LOGS_ALL_U1 — the primary key constraint and unique index on RESALE_LOG_ID that enforce row uniqueness.
  • Trade Management resale concurrent programs — the import and validation processes that insert into this table during execution.
  • OZF lookup and error-code reference objects — used to decode ERROR_CODE values into business-friendly categories.