Search Results oke_billing_methods_b




Overview
Explore in AI Chat

Overview

The OKE_BILLING_METHODS_B table is a core reference data table within the Oracle E-Business Suite Project Contracts (OKE) module. It functions as the master repository for defining and storing all valid billing methods available for use in contract management. Billing methods are fundamental to the revenue and invoicing processes, dictating how and when amounts are billed to customers under contractual agreements. This table's role is to provide a centralized, validated list of codes that ensure consistency and data integrity across all project contracts, serving as a key lookup for transactional tables during contract creation, funding, and billing activities.

Key Information Stored

As a reference table, its structure is focused on the unique identification and description of each billing method. The primary column is BILLING_METHOD_CODE, which serves as the unique key for each method, such as 'FIXED_PRICE', 'TIME_AND_MATERIALS', or 'MILESTONE'. While the provided ETRM metadata does not list all columns, typical supporting columns in such base tables include LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, and LAST_UPDATE_LOGIN for auditing. A START_DATE_ACTIVE and END_DATE_ACTIVE may also be present to control the valid usage period of a billing method. The table likely has a corresponding translation table (e.g., OKE_BILLING_METHODS_TL) to store language-specific names and descriptions.

Common Use Cases and Queries

This table is primarily referenced in scenarios involving the setup, validation, and reporting of contract billing rules. A common use case is populating a list of values (LOV) in the "Billing Method" field during the creation of a contract line or funding arrangement. System administrators may query this table to audit active billing methods. For reporting, it is joined to transactional tables to decode billing method codes into meaningful descriptions. A typical query pattern involves a simple select to list all valid methods or a join to related contract headers or lines.

SELECT billing_method_code
FROM oke_billing_methods_b
WHERE SYSDATE BETWEEN start_date_active AND NVL(end_date_active, SYSDATE);

Another common pattern is joining to the transaction table OKE_K_BILLING_METHODS to report on contracts using a specific billing method.

Related Objects

The OKE_BILLING_METHODS_B table is central to the Project Contracts data model, with several key objects referencing its primary key. The documented foreign key relationships are:

  • OKE_K_BILLING_METHODS: This transactional table references OKE_BILLING_METHODS_B.BILLING_METHOD_CODE via its column of the same name. It associates specific billing methods with contract funding lines or deliverables.
  • OKE_K_BILLING_METHODS_H: This history table tracks changes to records in OKE_K_BILLING_METHODS and also references the master code via OKE_K_BILLING_METHODS_H.BILLING_METHOD_CODE.

These relationships enforce referential integrity, ensuring that any billing method used in a contract transaction is defined in the master OKE_BILLING_METHODS_B table.