Search Results input_value

Overview

PSP_ENC_ELEMENTS_V is a PL/SQL view owned by the APPS schema within the PSP (Labor Distribution) product family in Oracle E-Business Suite 12.1.1 and 12.2.2. Its documented purpose is to expose the setup data required for defining elements that participate in labor encumbrance. Labor distribution encumbers project and grant budgets against labor costs, and the configuration of which element input values drive that encumbrance is stored in the PSP_ENC_ELEMENTS table. This view flattens that configuration table together with the descriptive attributes of the associated element type and the element input value, producing a denormalized, reporting-friendly result set.

Because it joins the encumbrance setup table to the Payroll element definition tables, the view is the natural access point for technical consultants, report writers, and integration developers who need to confirm which input value on which element has been flagged for encumbrance. Rather than navigating three separate tables, consumers query PSP_ENC_ELEMENTS_V directly and receive element names and input value names in human-readable form.

Underlying Base Objects

The documented view metadata for 12.2.2 identifies four referenced base objects, all accessed through APPS synonyms: PSP_ENC_ELEMENTS, PAY_ELEMENT_TYPES_F, PAY_INPUT_VALUES_F, and FF_FORMULAS_F. The view text confirms the principal joins:

• PSP_ENC_ELEMENTS — the driving table (aliased A), which stores the labor encumbrance configuration rows keyed by ENC_ELEMENT_ID, with foreign keys to ELEMENT_TYPE_ID and INPUT_VALUE_ID.
• PAY_ELEMENT_TYPES_F — the element type definition (aliased B), supplying ELEMENT_NAME. The view applies a ROWID filter using a MIN(ROWID) subquery to collapse the date-effective rows in the _F table to a single effective row per element type, preventing duplicate output.
• PAY_INPUT_VALUES_F — the input value definition (aliased PIV), supplying the INPUT_VALUE name that matches the stored INPUT_VALUE_ID. This is the column most frequently searched for as "input_value."
• FF_FORMULAS_F — referenced in the documented base object list, associated with the Fast Formula definitions that govern how the element's input values are populated or processed.

Key Columns

• ENC_ELEMENT_ID — Primary key of the encumbrance setup row in PSP_ENC_ELEMENTS; unique identifier for the configuration record.
• INPUT_VALUE — The user-facing name of the input value (from PAY_INPUT_VALUES_F) that is designated for labor encumbrance. This is the column consumers most often filter on.
• INPUT_VALUE_ID — The internal identifier linking the configuration row to the input value definition.
• ELEMENT_NAME — The name of the payroll element type to which the input value belongs.
• ELEMENT_TYPE_ID — Internal identifier of the element type.
• ELEMENT_TYPE_CATEGORY — Classification of the element type, useful for restricting the view to a specific category of earnings or deductions.
• BUSINESS_GROUP_ID — The HR business group (legislative context) under which the setup applies.
• SET_OF_BOOKS_ID — The ledger context for the encumbrance setup.
• Audit columns — LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, and CREATION_DATE support change tracking and reconciliation.

Common Use Cases and Queries

Typical scenarios include auditing which element input values are enabled for labor encumbrance, diagnosing missing or duplicate encumbrance configuration, and feeding downstream integrations that require the element-to-input-value mapping.

To retrieve all encumbrance input values for a business group:

• SELECT element_name, input_value, input_value_id, element_type_category FROM apps.psp_enc_elements_v WHERE business_group_id = :p_bg_id ORDER BY element_name, input_value;

To locate a specific input value across all elements:

• SELECT element_name, input_value, element_type_category FROM apps.psp_enc_elements_v WHERE input_value = :p_input_value;

To review recently changed configuration:

• SELECT enc_element_id, element_name, input_value, last_update_date, last_updated_by FROM apps.psp_enc_elements_v WHERE last_update_date >= :p_since ORDER BY last_update_date DESC;

Because the view resolves element and input value names through the date-effective payroll tables and applies the MIN(ROWID) deduplication, results represent the effective definition of each configured encumbrance element, making the view reliable for both ad hoc reporting and integration extraction.