Results for “risk_formula_id”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

IBY_RISK_FORMULAS is a Payments (IBY) module table in Oracle E-Business Suite 12.1.1 and 12.2.2 that stores risk formula configuration information. A risk formula is used by merchants (payees) to evaluate the risk associated with a customer. Because different goods or services offered by a merchant may carry different risk profiles, a merchant can define more than one risk formula to suit distinct business scenarios. The table resides in the IBY schema and holds 12 documented columns in the 12.2.2 physical schema.

From a Data Vault modeling perspective, the heuristic classification derived from the foreign key structure is satellite-leaning. This suggests the table is best modeled as a descriptive satellite attached to a payee hub (IBY_PAYEE), capturing attributes and context about a risk formula rather than representing an independent business entity or a pure relationship link. The primary surrogate key is RISK_FORMULA_ID.

Key Information Stored

The most significant columns documented for this table are:

• RISK_FORMULA_ID — The surrogate primary key, enforced by the IBY_RISK_FORMULAS_PK constraint and also carried by the unique index IBY_RISK_FORMULA_ID_U2. This value uniquely identifies each risk formula record and is the column referenced by dependent child tables.
• FORMULA_NAME — The business-key candidate, enforced by the unique index IBY_RISK_FORMULAS_UK1. This is the user-recognizable name of the risk formula.
• DESCRIPTION — Free-form descriptive text explaining the purpose or scope of the formula.
• PAYEEID — Foreign key to IBY_PAYEE, identifying the merchant or payee that owns the formula. This establishes the parent-child relationship between a payee and its formula(s).
• IMPLICIT_FLAG — Indicator of whether the formula is implicit (system-default or automatically applied) versus explicitly defined by the user.
• SECURITY_GROUP_ID — Foreign key to FND_SECURITY_GROUPS, supporting multi-org / security-group access partitioning.
• OBJECT_VERSION_NUMBER — Optimistic locking version column used for concurrent update control.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN — Standard WHO audit columns tracking record creation and modification.

The distinction is important: RISK_FORMULA_ID is the surrogate key used for referential integrity, whereas FORMULA_NAME serves as the natural business-key candidate. The combination of PAYEEID and FORMULA_NAME effectively scope and identify a formula within a given merchant.

Common Use Cases and Queries

Typical usage includes retrieving all formulas belonging to a merchant, identifying the default or implicit formula, and joining to the formula items that define evaluation details.

List formulas for a payee:

• SELECT r.risk_formula_id, r.formula_name, r.description, r.implicit_flag FROM iby.iby_risk_formulas r WHERE r.payeeid = :payee_id ORDER BY r.formula_name;

Find the implicit formula across merchants:

• SELECT r.risk_formula_id, r.formula_name, p.payee_name FROM iby.iby_risk_formulas r JOIN iby.iby_payee p ON p.payee_id = r.payeeid WHERE r.implicit_flag = 'Y';

Retrieve formula detail with items for reporting:

• SELECT r.formula_name, i.* FROM iby.iby_risk_formulas r JOIN iby.iby_risk_formula_item i ON i.risk_formula_id = r.risk_formula_id WHERE r.risk_formula_id = :formula_id;

Reporting scenarios include audit trails of formula changes using the WHO columns, and security-group-filtered extracts using SECURITY_GROUP_ID.

Related Objects

The following objects have the most significant relationships with IBY_RISK_FORMULAS:

• IBY_PAYEE — Parent table; joined on IBY_RISK_FORMULAS.PAYEEID = IBY_PAYEE.PAYEE_ID.
• IBY_RISK_FORMULA_ITEM — Child table holding formula line items; joined on IBY_RISK_FORMULA_ITEM.RISK_FORMULA_ID = IBY_RISK_FORMULAS.RISK_FORMULA_ID.
• FND_SECURITY_GROUPS — Referenced by SECURITY_GROUP_ID for access control partitioning.
• IBY_RISK_FORMULAS_PK / IBY_RISK_FORMULAS_UK1 / IBY_RISK_FORMULA_ID_U2 — Constraints and unique indexes that enforce PK integrity and business-key uniqueness.

These relationships establish IBY_RISK_FORMULAS as the central header record for merchant risk evaluation configuration within the Payments module.