Search Results ozf_cust_trd_prfls




Overview
Explore in AI Chat

Overview

APPS.OZF_CUST_TRD_PRFLS_V is a reporting and integration view in the Oracle E-Business Suite Trade Management (formerly Oracle Trade Management / OZF) module. It exposes customer trade profiles — the configuration records that determine how a customer account is treated for trade management, claims, settlements, and payment activities. The view denormalizes the base trade profile table by joining it to Oracle Receivables and Oracle Payables master data, so that a single query returns human-readable customer, account, site, and vendor context alongside the operational trade profile attributes.

In EBS 12.1.1 and 12.2.2 the view is owned by APPS and is typically consumed by concurrent programs, OAF/Forms-based trade management screens, BI Publisher reports, and outbound integration extracts. Because it is a view rather than a table, it is read-only and inherits the security and multi-org behavior of its underlying tables, most notably the ORG_ID column sourced from OZF_CUST_TRD_PRFLS for operating unit (Multi-Org) filtering.

Underlying Base Objects

The view is defined over five documented base objects, joined as follows:

The join chain therefore requires a valid customer account and site use for each trade profile row; only the vendor relationship is optional.

Key Columns

Common Use Cases and Queries

Typical uses include listing customers configured for autopay, auditing claim and write-off thresholds by operating unit, and feeding vendor payment or claims extracts. A representative query restricts to a single operating unit and returns the profile with its customer, site, and vendor context:

  • SELECT TRADE_PROFILE_ID, PARTY_NAME, ACCOUNT_NUMBER, SITE_USE_CODE, DAYS_DUE, PAYMENT_METHOD, VENDOR_NAME, AUTOPAY_FLAG, CLAIM_THRESHOLD, CLAIM_CURRENCY, ORG_ID FROM APPS.OZF_CUST_TRD_PRFLS_V WHERE ORG_ID = :p_org_id AND AUTOPAY_FLAG = 'Y';
  • SELECT TRADE_PROFILE_ID, ACCOUNT_NUMBER, POS_WRITE_OFF_THRESHOLD, NEG_WRITE_OFF_THRESHOLD, HEADER_TOLERANCE_OPERAND, LINE_TOLERANCE_OPERAND FROM APPS.OZF_CUST_TRD_PRFLS_V WHERE CUST_ACCOUNT_ID = :p_cust_account_id;
  • SELECT SITE_USE_CODE, COUNT(*) FROM APPS.OZF_CUST_TRD_PRFLS_V WHERE ORG_ID = :p_org_id GROUP BY SITE_USE_CODE ORDER BY 2 DESC;

Because the view relies on inner joins to HZ_CUST_ACCOUNTS, HZ_CUST_SITE_USES, and HZ_PARTIES, trade profiles lacking complete customer or site setup will not appear; reports requiring orphan profiles should query OZF_CUST_TRD_PRFLS directly. All queries should respect ORG_ID to honor Multi-Org access controls.