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:
- PAY_NET_CALCULATION_RULES — the core table of net calculation rules (rule ID, accrual plan ID, input value ID, add/subtract flag, absence/attendance type ID).
- PAY_ACCRUAL_PLANS — provides ACCRUAL_PLAN_ID, ACCRUAL_PLAN_NAME, ACCRUAL_PLAN_ELEMENT_TYPE_ID, and ACCRUAL_UNITS_OF_MEASURE.
- PAY_ELEMENT_TYPES_F and PAY_ELEMENT_TYPES_F_TL — element type base and translated name rows (ELEMENT_TYPE_ID, ELEMENT_NAME).
- PAY_INPUT_VALUES_F and PAY_INPUT_VALUES_F_TL — input value definitions and translated names (INPUT_VALUE_ID, NAME).
- HR_LOOKUPS — decoded meanings for lookup codes. Two lookup types are used: ADD_SUBTRACT (mapping the add/subtract flag to a meaning) and HOURS_OR_DAYS (mapping ACCRUAL_UNITS_OF_MEASURE to a meaning such as Hours or Days).
- FND_SESSIONS — supplies the effective date used to restrict element type and input value rows to the currently effective versions.
- HR_API — a package referenced by the view definition for session or effective-date handling.
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.
-
Lookup Type: ADD_SUBTRACT 12.1.1
Add or Subtract
-
Lookup Type: ADD_SUBTRACT 12.2.2
Add or Subtract
-
Used to support user interface
APPS.PAY_VIEW_NET_CALC_RULES_V·↳ FND_SESSIONS·↳ HR_API·↳ HR_LOOKUPS·Explore PAY module →
-
Used to support user interface
APPS.PAY_VIEW_NET_CALC_RULES_V·↳ FND_GLOBAL·↳ FND_SESSIONS·↳ HR_API·Explore PAY module →
-
APPS.PAYBV_BALANCE_CLASSIFICATION_V·↳ HR_BIS·↳ PAY_BALANCE_CLASSIFICATIONS·Explore PAY module →
-
Used to support user interface
APPS.PAY_BALANCE_CLASSIFICATIONS_V·↳ HR_API·↳ HR_LOOKUPS·↳ PAY_BALANCE_CLASSIFICATIONS·Explore PAY module →
-
Used to support user interface
APPS.PAY_BALANCE_CLASSIFICATIONS_V·↳ FND_GLOBAL·↳ HR_API·↳ HR_LOOKUPS·Explore PAY module →
-
APPS.PAYBV_BALANCE_FEEDS_F_V·↳ HR_BIS·↳ PAY_BALANCE_FEEDS_F·Explore PAY module →
-
APPS.PAYBV_BALANCE_FEEDS_F_V·↳ HR_BIS·↳ PAY_BALANCE_FEEDS_F·Explore PAY module →
-
APPS.PAYBV_BALANCE_CLASSIFICATION_V·↳ HR_BIS·↳ PAY_BALANCE_CLASSIFICATIONS·Explore PAY module →
-
View: PAY_BALANCE_FEEDS_D 12.2.2
Used by DateTrack History
APPS.PAY_BALANCE_FEEDS_D·↳ FND_USER·↳ HR_API·↳ HR_LOOKUPS·Explore PAY module →
-
View: PAY_BALANCE_FEEDS_D 12.1.1
Used by DateTrack History
APPS.PAY_BALANCE_FEEDS_D·↳ FND_GLOBAL·↳ FND_USER·↳ HR_API·Explore PAY module →
-
This view returns Balance Feed of Separation Pay Process based on assignment_action_id and balance_type_id.
APPS.PAY_KR_SEP_RESULT_BALF_V·↳ HR_GENERAL·↳ PAY_ASSIGNMENT_ACTIONS·↳ PAY_BALANCE_FEEDS_F·Explore PAY module →
-
Used to support user interface
APPS.PAY_NET_CALCULATION_RULES_V·↳ FND_GLOBAL·↳ FND_SESSIONS·↳ HR_API·Explore PAY module →
-
This view returns Result Value for Voluntary Deductions of Separation Net Pay Process based on assignment_action_id.
APPS.PAY_KR_SEP_RESULT_NET_VOL_V·↳ HR_GENERAL·↳ PAY_ASSIGNMENT_ACTIONS·↳ PAY_BALANCE_FEEDS_F·Explore PAY module →
-
View: PAY_BALANCE_FEEDS_V 12.2.2
Used to support user interface
APPS.PAY_BALANCE_FEEDS_V·↳ FND_SESSIONS·↳ HR_API·↳ HR_LOOKUPS·Explore PAY module →
-
Used to support user interface
APPS.PAY_NET_CALCULATION_RULES_V·↳ FND_SESSIONS·↳ HR_API·↳ HR_LOOKUPS·Explore PAY module →
-
This view returns Balance Feed of Separation Pay Process based on assignment_action_id and balance_type_id.
APPS.PAY_KR_SEP_RESULT_BALF_V·↳ HR_GENERAL·↳ PAY_ASSIGNMENT_ACTIONS·↳ PAY_BALANCE_FEEDS_F·Explore PAY module →
-
View: PAY_BALANCE_FEEDS_V 12.1.1
Used to support user interface
APPS.PAY_BALANCE_FEEDS_V·↳ FND_GLOBAL·↳ FND_SESSIONS·↳ HR_API·Explore PAY module →
-
This view returns Result Value for Voluntary Deductions of Separation Net Pay Process based on assignment_action_id.
APPS.PAY_KR_SEP_RESULT_NET_VOL_V·↳ HR_GENERAL·↳ PAY_ASSIGNMENT_ACTIONS·↳ PAY_BALANCE_FEEDS_F·Explore PAY module →
-
This view returns Result Value for Involuntary Deductions of Separation Net Pay Process based on assignment_action_id.
APPS.PAY_KR_SEP_RESULT_NET_INVOL_V·↳ HR_GENERAL·↳ PAY_ASSIGNMENT_ACTIONS·↳ PAY_BALANCE_FEEDS_F·Explore PAY module →
-
This view returns Result Value for Involuntary Deductions of Separation Net Pay Process based on assignment_action_id.
APPS.PAY_KR_SEP_RESULT_NET_INVOL_V·↳ HR_GENERAL·↳ PAY_ASSIGNMENT_ACTIONS·↳ PAY_BALANCE_FEEDS_F·Explore PAY module →