Search Results psb_formula_parameters_pk

Overview

The PSB_FORMULA_PARAMETERS table is a core data object within the Oracle E-Business Suite (EBS) module for Public Sector Budgeting (PSB), which is documented as obsolete in the provided ETRM metadata for versions 12.1.1 and 12.2.2. This table serves as a repository for the input parameters required by a formula. In the context of budgeting, formulas are used to automate complex calculations for budget allocations, adjustments, or forecasts. Each row in this table defines a single parameter—such as a rate, base amount, or date—that must be supplied for its parent formula to execute correctly. The table's existence is critical for maintaining the integrity and reusability of calculation logic within the PSB module, allowing for dynamic and configurable budgeting rules.

Key Information Stored

The table's structure is defined by its primary key and its link to the master formula definition. The most critical columns, as documented, are:

• FORMULA_ID: A foreign key column that uniquely identifies the parent formula in the PSB_FORMULAS table. This creates a one-to-many relationship where a single formula can have multiple parameters.
• SEQUENCE_NUMBER: Works in conjunction with FORMULA_ID to form the primary key (PSB_FORMULA_PARAMETERS_PK). This column dictates the order in which parameters are presented or processed, which is often essential for the formula's execution logic.

While the specific metadata for additional columns (like PARAMETER_NAME, DATA_TYPE, or DEFAULT_VALUE) is not provided in the excerpt, typical parameter tables in EBS would store such attributes to fully define each input variable's name, expected data type, and optional default value.

Common Use Cases and Queries

Primary use cases involve the setup, maintenance, and auditing of budgeting formulas. Administrators or implementers would query this table to understand the required inputs for a formula before executing a budget batch process or to troubleshoot calculation errors. A common reporting need is to list all parameters for a specific formula. A sample SQL query, based on the documented structure, would be:

SELECT * FROM PSB_FORMULA_PARAMETERS WHERE FORMULA_ID = :formula_id ORDER BY SEQUENCE_NUMBER;

Another practical scenario is validating formula setup by joining to the master formula table to ensure all referenced formulas have their necessary parameters defined:

SELECT f.FORMULA_NAME, p.SEQUENCE_NUMBER FROM PSB_FORMULAS f LEFT JOIN PSB_FORMULA_PARAMETERS p ON f.FORMULA_ID = p.FORMULA_ID WHERE p.FORMULA_ID IS NULL;

Related Objects

The table has a direct and documented dependency on the PSB_FORMULAS table, which stores the master definition of the formula itself. The relationship is enforced by a foreign key constraint:

• Primary Table: PSB_FORMULAS
• Foreign Key in PSB_FORMULA_PARAMETERS: FORMULA_ID
• Relationship: PSB_FORMULA_PARAMETERS.FORMULA_ID references PSB_FORMULAS. This ensures that every parameter record is associated with a valid, existing formula. No other foreign key relationships for this table are indicated in the provided metadata.

It is important to note the ETRM explicitly states this table is "Not implemented in this database" for the queried instance, indicating it may exist in the data dictionary but not be populated or actively used in certain deployments, consistent with the module's obsolete status.