Search Results wsh_report_sets

Overview

The MTL_CLIENT_PARAMETERS table is a master data repository within the Oracle E-Business Suite Inventory (INV) module. It serves as the central definition table for third-party logistics (3PL) clients or trading partners. In a 3PL warehousing model, a single physical inventory organization may manage stock for multiple external client entities. This table stores the critical parameters and operational rules that govern how inventory, shipping, and billing transactions are processed for each distinct client, enabling partitioned logistics management within a shared operational framework.

Key Information Stored

The table's structure centers on identifying the client and linking to broader Oracle Trading Community Architecture (TCA) entities. The primary identifier is CLIENT_ID, a foreign key to HZ_CUST_ACCOUNTS, which ties the client to a formal customer account. The CLIENT_CODE provides a unique, often abbreviated, identifier used by transactional tables. Other significant columns define operational rules, including TRADING_PARTNER_SITE_ID (linking to HZ_PARTY_SITES for the client's address), SHIP_CONFIRM_RULE_ID (linking to WSH_SHIP_CONFIRM_RULES), and crucially for the user's search context, DELIVERY_REPORT_SET_ID. This column holds a foreign key to WSH_REPORT_SETS, defining the specific set of shipping documents (like packing slips or bills of lading) to be printed for deliveries associated with this client.

Common Use Cases and Queries

A primary use case is configuring and reporting on client-specific shipping documentation. The link to WSH_REPORT_SETS via DELIVERY_REPORT_SET_ID allows administrators to assign different output formats per client. Common queries include identifying clients and their assigned report sets, or troubleshooting shipping document issues by verifying this parameter. For example:

• To list all 3PL clients with their assigned delivery report set: SELECT mcp.client_code, mcp.client_id, mcp.delivery_report_set_id, wrs.name FROM mtl_client_parameters mcp, wsh_report_sets wrs WHERE mcp.delivery_report_set_id = wrs.report_set_id(+);
• To find the setup for a specific client code: SELECT * FROM mtl_client_parameters WHERE client_code = '&CLIENT_CODE';

This table is also essential for any inventory or billing transaction that must be segregated by client code, as seen in its foreign key relationships to tables like MTL_3PL_LOCATOR_OCCUPANCY.

Related Objects

As per the provided metadata, MTL_CLIENT_PARAMETERS has integral relationships with several key objects. It is a child table to TCA (HZ_CUST_ACCOUNTS, HZ_PARTY_SITES) and Shipping Execution (WSH_SHIP_CONFIRM_RULES, WSH_REPORT_SETS) entities. Conversely, it acts as a parent table to various transactional and setup tables within Inventory, including MTL_3PL_LOCATOR_OCCUPANCY and MTL_BILLING_RULE_LINES, which use the CLIENT_CODE for data segregation. This positions it as a pivotal hub connecting master data, operational rules, and transactional execution in a 3PL environment.