Results for “add_subtract”

50+ results




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

Overview

APPS.PAY_VIEW_NET_CALCULATION_RULES_V is a reporting and integration view in Oracle E-Business Suite Payroll (Oracle Payroll) that consolidates the rules governing how net pay calculations interact with accrual plans. In the Oracle EBS 12.1.1 and 12.2.2 data models, net calculation rules are stored in PAY_NET_CALCULATION_RULES and define how individual element input values (such as an absence or attendance element) add to or subtract from an accrual plan balance. This view flattens that relationship into a single, user-friendly row-per-rule format, resolving foreign keys into descriptive names and decoded lookup meanings. It is intended for use by concurrent programs, BI Publisher reports, Fast Formulas support diagnostics, and customer-built extracts. Because it exposes accrual unit-of-measure meanings and add/subtract indicators in readable form, it is particularly useful for auditing and troubleshooting accrual netting behavior without joining multiple transactional tables manually.

Underlying Base Objects

The view is defined as a UNION of at least three SELECT branches, each representing a different logical category of plan or rule row. Documented base objects referenced by the view include:

The userenv('LANG') predicate restricts translated tables to the session language, and USERENV('SESSIONID') ties FND_SESSIONS to the current session so that only effective-dated rows valid as of the session effective date are returned.

Key Columns

The view exposes the following notable columns:

  • NET_CALCULATION_RULE_ID — identifier of the net calculation rule (from PAY_NET_CALCULATION_RULES).
  • ACCRUAL_PLAN_ID / ACCRUAL_PLAN_NAME — the accrual plan to which the rule applies, with descriptive name.
  • ACCRUAL_UNITS_OF_MEASURE (and its decoded meaning) — the plan's unit of measure, resolved via HR_LOOKUPS with lookup type HOURS_OR_DAYS. This is the column most relevant to searches for "accrual_units_of_measure."
  • INPUT_VALUE_ID / NAME — the input value linked to the rule and its translated name.
  • ELEMENT_TYPE_ID / ELEMENT_NAME — owning element type for the input value.
  • ADD_OR_SUBTRACT and its meaning — whether the rule adds to or subtracts from the plan balance.
  • ABSENCE_ATTENDANCE_TYPE_ID — links the rule to an absence or attendance type, where applicable (null on the accrual plan summary row).

Common Use Cases and Queries

Typical scenarios include auditing accrual netting rules for a plan, verifying units of measure, and building extracts for payroll reconciliations. A representative query lists active rules with decoded values:

SELECT NET_CALCULATION_RULE_ID,
       ACCRUAL_PLAN_NAME,
       ACCRUAL_UNITS_OF_MEASURE,
       ELEMENT_NAME,
       NAME,
       ADD_OR_SUBTRACT,
       ABSENCE_ATTENDANCE_TYPE_ID
  FROM APPS.PAY_VIEW_NET_CALCULATION_RULES_V
 WHERE ACCRUAL_PLAN_ID = :p_plan_id;

To isolate rules by unit of measure, filter on ACCRUAL_UNITS_OF_MEASURE (for example, 'H' for hours or 'D' for days, depending on lookup configuration). Because the view is session- and language-sensitive, always invoke it from within an EBS session context (or set the LANG userenv) to ensure translated names and effective-dated rows resolve correctly.