Search Results risk_formula_id




Overview
Explore in AI Chat

Overview

The IBY_RISK_FORMULA_ITEM table is a core data object within the Oracle E-Business Suite Payments (IBY) module, specifically for versions 12.1.1 and 12.2.2. It functions as an intersection or junction table, establishing a many-to-many relationship between risk formulas and individual risk factors. Its primary role is to enable the configuration of sophisticated risk scoring models. By linking formulas to factors and storing a specific weight for each association, it allows the system to calculate an overall risk score for payment transactions, which is critical for automated payment decisioning and fraud prevention workflows.

Key Information Stored

The table's structure is designed to manage the relationship between two key entities. The RISK_FORMULA_ID column references a specific risk scoring model defined in the IBY_RISK_FORMULAS table. The RISK_FACTOR_ID column, which was the focus of the user's search, references a distinct risk criterion (e.g., transaction amount, payer history, country) defined in the IBY_RISK_FACTORS table. The most critical data element stored is the WEIGHT column (implied by the description, though not explicitly listed in the provided metadata), which quantifies the relative importance or contribution of the linked risk factor within the context of the specific formula. Together, RISK_FACTOR_ID and RISK_FORMULA_ID form the table's primary key (IBY_RISK_FORMULA_ITEM_UK1), ensuring a unique combination of factor and formula.

Common Use Cases and Queries

This table is central to querying and maintaining payment risk engine configurations. Common operational and reporting scenarios include auditing the composition of active risk formulas, modifying factor weights for tuning risk models, and troubleshooting scoring logic. A typical query to list all factors and their assigned weights for a given risk formula would be:

  • SELECT rf.factor_name, rfi.weight FROM iby_risk_formula_item rfi, iby_risk_factors rf WHERE rfi.risk_factor_id = rf.risk_factor_id AND rfi.risk_formula_id = :formula_id ORDER BY rfi.weight DESC;

Another frequent use case is identifying which formulas utilize a specific risk factor, which directly involves the searched column:

  • SELECT rfml.formula_name FROM iby_risk_formula_item rfi, iby_risk_formulas rfml WHERE rfi.risk_formula_id = rfml.risk_formula_id AND rfi.risk_factor_id = :risk_factor_id;

Related Objects

The IBY_RISK_FORMULA_ITEM table has defined dependencies on two primary master tables, as indicated by its foreign key constraints. It is a child table to IBY_RISK_FACTORS, which stores the definition of all available risk criteria, and to IBY_RISK_FORMULAS, which stores the header definition of each risk scoring model. This table sits at the intersection of these objects, enabling the flexible construction of risk models. Any API or business logic that creates, updates, or evaluates a payment risk formula will inherently interact with the data stored in IBY_RISK_FORMULA_ITEM to retrieve the component factors and their configured weights.

  • Table: IBY_RISK_FORMULA_ITEM 12.1.1

    owner:IBY,  object_type:TABLE,  fnd_design_data:IBY.IBY_RISK_FORMULA_ITEM,  object_name:IBY_RISK_FORMULA_ITEM,  status:VALID,  product: IBY - Payments ,  description: IBY_RISK_FORMULA_ITEM table is an intersection table between the IBY_RISK_FORMULA and IBY_RISK_FACTORS. It stores weight for different Risk Factors. ,  implementation_dba_data: IBY.IBY_RISK_FORMULA_ITEM , 

  • Table: IBY_RISK_FORMULA_ITEM 12.2.2

    owner:IBY,  object_type:TABLE,  fnd_design_data:IBY.IBY_RISK_FORMULA_ITEM,  object_name:IBY_RISK_FORMULA_ITEM,  status:VALID,  product: IBY - Payments ,  description: IBY_RISK_FORMULA_ITEM table is an intersection table between the IBY_RISK_FORMULA and IBY_RISK_FACTORS. It stores weight for different Risk Factors. ,  implementation_dba_data: IBY.IBY_RISK_FORMULA_ITEM , 

  • Table: IBY_RISK_FORMULAS 12.2.2

    owner:IBY,  object_type:TABLE,  fnd_design_data:IBY.IBY_RISK_FORMULAS,  object_name:IBY_RISK_FORMULAS,  status:VALID,  product: IBY - Payments ,  description: IBY_RISK_FORMULAS stores risk formula retaled information . Risk Formula is used by merchants to evaluate the risk of the customer. This formula could be different for different goods/services offered by the merchants. A Risk Formula may be ,  implementation_dba_data: IBY.IBY_RISK_FORMULAS , 

  • Table: IBY_RISK_FORMULAS 12.1.1

    owner:IBY,  object_type:TABLE,  fnd_design_data:IBY.IBY_RISK_FORMULAS,  object_name:IBY_RISK_FORMULAS,  status:VALID,  product: IBY - Payments ,  description: IBY_RISK_FORMULAS stores risk formula retaled information . Risk Formula is used by merchants to evaluate the risk of the customer. This formula could be different for different goods/services offered by the merchants. A Risk Formula may be ,  implementation_dba_data: IBY.IBY_RISK_FORMULAS ,