Search Results okl_fe_adj_mat_all_b

Overview

The OKL_FE_ADJ_MAT_ALL_B table is a core data object within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the Leasing and Finance Management (OKL) product. It functions as the pricing adjustment matrix header table. This table serves as the master definition for a pricing adjustment matrix, a critical component used to define and manage complex pricing rules, adjustments, and calculations within the leasing and finance modules. Each record represents a unique matrix definition, which is then detailed through associated version and line tables to govern how pricing adjustments are applied to transactions.

Key Information Stored

The primary data stored in this table centers on the unique identification and high-level attributes of a pricing adjustment matrix. The most critical column is the ADJ_MAT_ID, which serves as the primary key (PK) for the table via the constraint OKL_FE_ADJ_MAT_ALL_B_PK. This unique identifier is the anchor for all related data. While the provided ETRM excerpt does not list other specific columns, typical header information in such tables would include creation dates, last update dates, created by, last updated by, and descriptive fields like a matrix name or code. The ADJ_MAT_ID is the essential foreign key referenced by all related child entities.

Common Use Cases and Queries

This table is central to configuring and querying pricing adjustment setups. Common use cases include identifying all active adjustment matrices for reporting, troubleshooting pricing calculations by tracing back to the source matrix definition, and performing data integrity checks. A fundamental query involves joining the header to its version details. For example, to list all matrices and a count of their associated versions, a developer or analyst might use:

• SELECT h.ADJ_MAT_ID, COUNT(v.ADJ_MAT_ID) AS VERSION_COUNT FROM OKL_FE_ADJ_MAT_ALL_B h LEFT JOIN OKL_FE_ADJ_MAT_VERSIONS v ON h.ADJ_MAT_ID = v.ADJ_MAT_ID GROUP BY h.ADJ_MAT_ID;

Another critical pattern is validating the existence of a matrix before using it in a pricing engine or interface, typically by querying for a specific ADJ_MAT_ID.

Related Objects

The OKL_FE_ADJ_MAT_ALL_B table has defined relationships with several other objects, primarily through its primary key, ADJ_MAT_ID. According to the documented foreign key (FK) relationships:

• Self-Referencing Foreign Key: The table contains a foreign key where OKL_FE_ADJ_MAT_ALL_B.ADJ_MAT_ID references OKL_FE_ADJ_MAT_ALL_B. This suggests a potential hierarchical or parent-child relationship within the matrix headers themselves.
• Child Table - OKL_FE_ADJ_MAT_VERSIONS: This is a key dependent table. The column OKL_FE_ADJ_MAT_VERSIONS.ADJ_MAT_ID is a foreign key referencing OKL_FE_ADJ_MAT_ALL_B.ADJ_MAT_ID. This relationship stores the different versions or iterations of the pricing rules defined in the header.

These relationships form the structural backbone for the pricing adjustment functionality, with the header table (OKL_FE_ADJ_MAT_ALL_B) acting as the root entity.