Results for “date_input_value_name”

6 results




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

Overview

PAY_NET_CALCULATION_RULES_V is an APPS-owned database view in the Oracle E-Business Suite Payroll (PAY) module. Per the ETRM metadata, its documented purpose is to support the user interface. Rather than storing data, the view assembles net calculation rule definitions into a single, de-normalized result set that a form or self-service page can consume to render meaningful, translated values instead of raw identifiers. In the context of Oracle EBS 12.1.1 and 12.2.2, such interface-supporting views are common: they join a core transactional table to lookups, translated (_TL) tables, and session context so that the UI resolves language-specific names and the correct effective-dated row.

The view is also useful for reporting and integration. Because it resolves the rule's input value, the associated date input value, the element type, and the add-or-subtract direction into human-readable labels, developers can query it directly instead of reproducing the join logic. The search term "date_input_value_id" maps directly to the column DATE_INPUT_VALUE_ID exposed by this view, making it the natural starting point for anyone investigating date-driven net calculation rules.

Underlying Base Objects

ETRM documents the following referenced base objects: FND_SESSIONS (synonym), HR_API (package), HR_LOOKUPS (view), PAY_ACCRUAL_PLANS (synonym), PAY_ELEMENT_TYPES_F (synonym), PAY_ELEMENT_TYPES_F_TL (synonym), PAY_INPUT_VALUES_F (synonym), PAY_INPUT_VALUES_F_TL (synonym), and PAY_NET_CALCULATION_RULES (synonym).

The view text confirms how these objects are joined. The driving table is PAY_NET_CALCULATION_RULES (aliased NCR). PAY_INPUT_VALUES_F and its translations PAY_INPUT_VALUES_F_TL resolve the primary INPUT_VALUE_ID name; a second pair (PIV1/PIV1TL) resolves the optional DATE_INPUT_VALUE_ID name using an outer join ((+)). PAY_ELEMENT_TYPES_F and PAY_ELEMENT_TYPES_F_TL supply the element type and its name. HR_LOOKUPS (lookup type ADD_SUBTRACT) translates the ADD_OR_SUBTRACT code into a meaning. FND_SESSIONS provides session context, and the WHERE clause uses USERENV('LANG') and USERENV('SESSIONID') plus SES.EFFECTIVE_DATE to select rows effective as of the current session date, ensuring each base row is effective-dated correctly. HR_API is referenced as a package within the object's dependency set.

Key Columns

The documented columns are: ROW_ID, NET_CALCULATION_RULE_ID, ACCRUAL_PLAN_ID, BUSINESS_GROUP_ID, OBJECT_VERSION_NUMBER, INPUT_VALUE_ID, DATE_INPUT_VALUE_ID, INPUT_VALUE_NAME, DATE_INPUT_VALUE_NAME, ELEMENT_TYPE_ID, ELEMENT_TYPE_NAME, ADD_OR_SUBTRACT, and ADD_OR_SUBTRACT_NAME.

  • NET_CALCULATION_RULE_ID — primary identifier of the net calculation rule.
  • INPUT_VALUE_ID / INPUT_VALUE_NAME — the input value used by the rule and its translated name.
  • DATE_INPUT_VALUE_ID / DATE_INPUT_VALUE_NAME — the date input value associated with the rule and its translated name; this is the column corresponding to the user's search term and is populated via an outer join, so it may be null.
  • ADD_OR_SUBTRACT / ADD_OR_SUBTRACT_NAME — the operand direction code and its lookup meaning.
  • ELEMENT_TYPE_ID / ELEMENT_TYPE_NAME — the parent element type and its translated name.
  • ACCRUAL_PLAN_ID, BUSINESS_GROUP_ID, OBJECT_VERSION_NUMBER, ROW_ID — supporting identifiers and concurrency/row addressing columns.

Common Use Cases and Queries

A frequent scenario is retrieving the date input value attached to each net calculation rule, since the search term "date_input_value_id" points here. The following query lists rules with their resolved names:

  • SELECT net_calculation_rule_id, input_value_name, date_input_value_id, date_input_value_name, element_type_name, add_or_subtract_name FROM apps.pay_net_calculation_rules_v ORDER BY element_type_name, input_value_name;
  • SELECT * FROM apps.pay_net_calculation_rules_v WHERE date_input_value_id IS NOT NULL; — isolates rules that reference a date input value.
  • SELECT net_calculation_rule_id, accrual_plan_id FROM apps.pay_net_calculation_rules_v WHERE business_group_id = :p_bg_id; — filters rules by business group for a specific enterprise.

Because the view depends on FND_SESSIONS and USERENV('LANG'), effective-dated results reflect the session's effective date and language, so results can differ by user context. When used for integration, callers should be aware that translated name columns require the correct language environment, and that the date input value columns are nullable.