Search Results mtl_billing_rule_headers_b




Overview
Explore in AI Chat

Overview

The MTL_BILLING_RULE_HEADERS_B table is a core data object within the Oracle E-Business Suite Inventory (INV) module, specifically for versions 12.1.1 and 12.2.2. As its description indicates, it serves as the base table for defining Third-Party Logistics (3PL) Billing Rules. This table stores the header-level definition and metadata for billing rules, which are used to automate and standardize the calculation of charges for logistics services provided by a 3PL partner. These rules are critical for managing complex billing scenarios in outsourced warehouse and distribution operations, enabling systematic invoicing based on predefined activities, transactions, or storage metrics.

Key Information Stored

The table's primary purpose is to hold the unique identifier and control attributes for a billing rule definition. The primary key column, BILLING_RULE_HEADER_ID, uniquely identifies each rule. While the full column list is not detailed in the provided metadata, typical columns in such a base header table would include creation and last update dates (CREATION_DATE, LAST_UPDATE_DATE), user IDs (CREATED_BY, LAST_UPDATED_BY), and a code or name for the rule (e.g., RULE_NAME, RULE_CODE). It would also likely contain control columns such as START_DATE_ACTIVE, END_DATE_ACTIVE, DESCRIPTION, and ENABLED_FLAG to manage the rule's lifecycle and usage within the application.

Common Use Cases and Queries

This table is primarily accessed for setup, maintenance, and reporting on 3PL billing rule definitions. Common operational scenarios include auditing active rules, identifying rules used within a specific date range, and troubleshooting billing calculations by examining rule headers. A typical query would join this table with its associated lines table (MTL_BILLING_RULE_LINES) to get a complete view of a rule's criteria and charges. For example:

  • Listing all active billing rules: SELECT BILLING_RULE_HEADER_ID, RULE_NAME FROM INV.MTL_BILLING_RULE_HEADERS_B WHERE SYSDATE BETWEEN START_DATE_ACTIVE AND NVL(END_DATE_ACTIVE, SYSDATE) AND ENABLED_FLAG = 'Y';
  • Finding rules created by a specific user: SELECT * FROM INV.MTL_BILLING_RULE_HEADERS_B WHERE CREATED_BY = :user_id ORDER BY CREATION_DATE DESC;

Reporting often focuses on summarizing rule usage and validating setup data against transactional data generated by the billing engine.

Related Objects

The most direct relationship, as defined by the foreign key in the metadata, is with the MTL_BILLING_RULE_LINES table. The BILLING_RULE_HEADER_ID links the header to its detailed line items, which define specific billing conditions, rates, and calculations. This header table is also referenced by various application programming interfaces (APIs) and user interfaces (Forms) within the Inventory module for creating and maintaining 3PL billing rules. While not listed, it is common for transactional billing tables (which store the results of applying these rules) to indirectly reference the header ID. Furthermore, key descriptive flexfield (DFF) columns may exist on this table to capture custom attributes, and it may have associated translatable views (e.g., MTL_BILLING_RULE_HEADERS_TL) for multilingual support.