Search Results ozf_supp_trd_prfls_all




Overview
Explore in AI Chat

Overview

OZF_SUPP_TRD_PRFLS_ALL is a Trade Management (OZF) transactional table in Oracle E-Business Suite that stores supplier trade profiles. These profiles are created and maintained through the Supplier Trade Profile user interface and define the commercial, financial, and approval rules governing supplier-funded trade promotions, accruals, claims, and settlements. The table is a multi-org (partitioned by ORG_ID) and multi-lingual (_ALL suffix) object owned by the OZF schema, and it is documented with 110 physical columns in releases 12.1.1 and 12.2.2.

From a Data Vault modeling perspective, the heuristic classification for this table is standalone — that is, it behaves as a self-contained container without a strongly normalized parent-child relationship in the raw FK graph. In Data Vault terms this suggests it should be modeled as a satellite attached to a hub keyed on the surrogate trade profile identifier, rather than as a hub or link. The classification is mined heuristically from FK structure and is offered as guidance only.

Key Information Stored

The surrogate primary key is SUPP_TRADE_PROFILE_ID, supported by unique index OZF_SUPP_TRD_PRFLS_ALL_U1 (the documented business-key candidate). The most significant business columns include:

Common Use Cases and Queries

Typical reporting and integration scenarios include listing active supplier trade profiles for an operating unit, auditing claim and settlement configuration, and joining profiles to supplier and customer master data. A representative query:

SELECT p.supp_trade_profile_id,
       p.supplier_id,
       p.cust_account_id,
       p.auto_debit,
       p.claim_frequency,
       p.claim_currency_code
FROM   ozf.ozf_supp_trd_prfls_all p
WHERE  p.org_id = :p_org_id
AND    p.supplier_id = :p_supplier_id
ORDER BY p.last_update_date DESC;

Common use cases include supplier accrual reconciliation, claims automation validation, settlement method verification (SETTLEMENT_METHOD_SUPPLIER_INC/DEC), and audit trails via WHO columns. Because 30+30 flexfield attributes exist, reports frequently leverage ATTRIBUTE_CATEGORY and DPP_ATTRIBUTE_CATEGORY to unpack client-specific configurations.

Related Objects

  • HZ_CUST_ACCOUNTS — joined on CUST_ACCOUNT_ID to resolve customer identity.
  • HZ_CUST_ACCT_SITES_ALL — joined on CUST_ACCT_SITE_ID for customer site context.
  • FND_SECURITY_GROUPS — joined on SECURITY_GROUP_ID for row-level security enforcement.
  • Supplier master objects (e.g., POZ_SUPPLIERS / AP_SUPPLIERS) — resolved through SUPPLIER_ID and PARTY_ID.
  • OZF claim and settlement tables (e.g., OZF_CLAIMS_ALL and related accrual objects) — downstream consumers of the profile's claim and settlement rules.
  • OZF Supplier Trade Profile UI pages (OA Framework) — the primary maintenance interface.