Results for “expiry_checking_level_code”

2 results




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

Overview

PAYBV_BALANCE_DIMENSION is an APPS-owned database view within the Payroll (PAY) product family of Oracle E-Business Suite, valid in both 12.1.1 and 12.2.2. It presents balance dimension definitions stored in the PAY_BALANCE_DIMENSIONS table, decoded for human-readable reporting and secured according to the session's business group and legislation context. Balance dimensions define the level at which payroll balances accumulate — for example, assignment, assignment action, or run — and therefore govern how gross-to-net, tax, deduction, and accrual balances are maintained.

The view exists primarily to support Oracle Business Intelligence (BIS) reporting and balance-related inquiry screens. Rather than exposing raw lookup codes, it joins to HR_BIS.BIS_DECODE_LOOKUP to translate coded values for DIMENSION_TYPE, PAYMENTS_FLAG, EXPIRY_CHECKING_LEVEL, and SAVE_RUN_BALANCE_ENABLED into their display meanings. A search for expiry_checking_level resolves directly to the decoded EXPIRY_CHECKING_LEVEL column, which controls whether a balance dimension enforces an expiry check and at what level that check is applied.

Underlying Base Objects

The view is defined over two documented referenced objects:

  • PAY_BALANCE_DIMENSIONS (SYNONYM) — the base table holding the authoritative balance dimension definitions. The view aliases this table as PBD and selects from it with a WITH READ ONLY clause, guaranteeing that consumers cannot perform DML through the view.
  • HR_BIS (PACKAGE) — the decoding package invoked for each translated attribute via BIS_DECODE_LOOKUP, and for security context through GET_LEGISLATION_CODE and GET_SEC_PROFILE_BG_ID.

Because the view is read-only and reflects the base table directly, it aligns one-to-one with rows in PAY_BALANCE_DIMENSIONS; no aggregation or filtering is applied beyond the derived security flag.

Key Columns

Common Use Cases and Queries

The view is commonly queried to audit dimension configuration, to verify expiry checking behaviour, and to drive reports that must respect business group security. A representative query filters on expiry checking level:

  • SELECT dimension_name, dimension_type, expiry_checking_level, expiry_checking_level_code, legislation_code FROM paybv_balance_dimension WHERE bg_security_flag_code = 'Y' ORDER BY dimension_name;
  • SELECT dimension_name, database_item_suffix, save_run_balance_enabled FROM paybv_balance_dimension WHERE payments_flag = 'Yes' AND expiry_checking_code IS NOT NULL;
  • SELECT dimension_name, dimension_level, period_type FROM paybv_balance_dimension WHERE balance_dimension_id = :p_dim_id;

Filtering on BG_SECURITY_FLAG_CODE ensures only dimensions valid for the current business group and legislation are returned, which is essential for multi-legislative implementations.