Search Results ozf_sd_customer_details




Overview
Explore in AI Chat

Overview

The OZF_SD_CUSTOMER_DETAILS table is a core data repository within the Oracle Trade Management (OZF) module of Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2. It is specifically designed to store detailed customer information pertinent to the "Ship and Debit" (S&D) process. Ship and Debit is a critical trade promotion mechanism where a manufacturer (the supplier) authorizes a distributor to sell a product at a lower, pre-negotiated price to a specific end customer, with the supplier later debiting the distributor for the price difference. This table acts as the master source for identifying and managing the end-customer entities involved in these S&D claims and agreements, ensuring the promotional benefits are correctly applied to authorized parties.

Key Information Stored

The table's primary purpose is to uniquely identify the customer within the context of Ship and Debit transactions. While the full column list is not detailed in the provided metadata, its structure is anchored by the primary key column, REQUEST_CUSTOMER_ID. This identifier is crucial for linking customer details to specific S&D requests or agreements. Typically, such a table would also store attributes to fully define the customer, which may include a customer name, address information, and potentially a link to the broader Trading Community Architecture (TCA) customer definitions (HZ_PARTIES) in EBS. The data ensures that S&D pricing and claims processing are executed for the correct, authorized end-customer entity.

Common Use Cases and Queries

This table is central to operations and reporting within the Ship and Debit workflow. Common use cases include validating customer eligibility during the creation of a new S&D claim, generating reports on all customers approved for S&D programs, and auditing S&D activity by customer. A fundamental query pattern involves joining this table to the main S&D request or agreement table to retrieve a list of customers associated with specific promotions.

  • Sample Query: Selecting basic customer details for a specific S&D request: SELECT * FROM ozf.ozf_sd_customer_details WHERE request_customer_id = :p_cust_id;
  • Reporting Use Case: Analysts often query this table to determine the volume or value of S&D claims processed per unique end-customer, which is vital for measuring program effectiveness and customer-level profitability.

Related Objects

Based on the documented primary key, OZF_SD_CUSTOMER_DETAILS is a parent table in the OZF schema. The REQUEST_CUSTOMER_ID column serves as a foreign key reference in related transactional tables. The most direct relationship is implied by the table's description; it is intrinsically linked to the core Ship and Debit request or agreement header table (likely named OZF_SD_REQUESTS or similar), where REQUEST_CUSTOMER_ID would be a foreign key. This relationship ensures referential integrity, guaranteeing that every S&D transaction references a valid, defined customer from OZF_SD_CUSTOMER_DETAILS. For comprehensive customer master data, this table may also have a relationship to the TCA base tables (HZ_PARTIES, HZ_CUST_ACCOUNTS) to pull in standardized name, address, and account information.