Search Results ozf_supp_code_conversions_all




Overview
Explore in AI Chat

Overview

OZF_SUPP_CODE_CONVERSIONS_ALL is a Trade Management (OZF) module table in Oracle E-Business Suite, owned by the OZF schema. It stores the code mapping between the supplier item code and the internal item codes used within Oracle EBS. This object supports supplier-facing trade promotion and procurement workflows by allowing external (supplier-provided) product identifiers to be translated into the standardized internal item codes that downstream applications consume. It is present and documented for both 12.1.1 and 12.2.2 releases, and the ETRM metadata classifies it as VALID.

From a dimensional modeling perspective, the heuristic Data Vault classification mined from the foreign-key structure is standalone. This suggests the table behaves largely as a reference or lookup structure without being a formal hub, link, or satellite within the supplied relationship graph, though the presence of a unique business key and audit columns means it can optionally be treated as a link-like mapping entity if a Data Vault model were derived.

Key Information Stored

The table contains 37 columns. The most operationally significant are:

Common Use Cases and Queries

Typical usage centers on resolving supplier codes to internal items for purchasing, trade promotion settlement, and supplier collaboration reporting. A common query retrieves active mappings for a given supplier profile and operating unit:

  • SELECT external_code, internal_code FROM ozf.ozf_supp_code_conversions_all WHERE supp_trade_profile_id = :profile AND org_id = :org AND SYSDATE BETWEEN start_date_active AND NVL(end_date_active, SYSDATE + 1);
  • Join to OZF_CODE_CONVERSIONS_ALL on code_conversion_id to retrieve parent conversion metadata.
  • Reporting on conversions created by a specific concurrent program using program_id and request_id.
  • Auditing changes by filtering on last_update_date and last_updated_by.

Related Objects

The metadata documents two foreign keys that link this table to related objects:

  • OZF_CODE_CONVERSIONS_ALL — referenced via CODE_CONVERSION_ID; the parent conversion definition.
  • FND_SECURITY_GROUPS — referenced via SECURITY_GROUP_ID for security group assignment.

Additional related objects logically include supplier trade profile tables referenced by SUPP_TRADE_PROFILE_ID, standard inventory item master tables keyed by the internal code, and the OZF Trade Management concurrent programs that populate REQUEST_ID, PROGRAM_ID, and PROGRAM_APPLICATION_ID. These support the table's role as the supplier-to-internal code translation layer within Oracle Trade Management.