Search Results pay_balance_batch_lines




Overview
Explore in AI Chat

Overview

PAY_BALANCE_BATCH_LINES is a Payroll (PAY) module table owned by the HR schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It stores the individual batch lines that make up the balance upload process, which allows balances to be loaded into Oracle Payroll for processing or reporting. Each row represents a single balance batch line associated with a parent batch record. The table is an operational staging entity that links uploaded or calculated balance values to an assignment, a balance dimension, and the payroll action that will consume them.

From a Data Vault modeling perspective, the FK structure suggests this object leans toward a satellite. Its primary key identifies each line, while the foreign keys to parent batch, balance dimension, and payroll action tables provide the surrounding context. Analysts should treat this as a modeling suggestion rather than a fixed classification.

Key Information Stored

The table contains 22 documented columns. The most significant are:

Only BATCH_LINE_ID is documented as a unique-index business-key candidate; the remaining columns are descriptive or foreign-key attributes.

Common Use Cases and Queries

Typical scenarios include validating uploaded balance lines before processing, reconciling line counts against the parent batch, and reporting balances by assignment or dimension. A common pattern joins lines to their parent batch headers:

  • SELECT bl.batch_line_id, bl.batch_id, bl.assignment_number, bl.balance_name, bl.value, bl.batch_line_status FROM pay_balance_batch_lines bl WHERE bl.batch_id = :batch_id;
  • Status monitoring: count lines grouped by BATCH_LINE_STATUS within a given BATCH_ID to detect incomplete uploads.
  • Assignment reporting: filter by ASSIGNMENT_NUMBER or ASSIGNMENT_ID to trace all balance lines loaded for a worker.
  • Reconciliation: join PAY_TEMP_BALANCE_ADJUSTMENTS on BATCH_LINE_ID to compare staged adjustments against uploaded lines.

Related Objects

  • PAY_BALANCE_BATCH_HEADERS — parent table; join on PAY_BALANCE_BATCH_LINES.BATCH_ID = PAY_BALANCE_BATCH_HEADERS.BATCH_ID.
  • PAY_BALANCE_DIMENSIONS — join on BALANCE_DIMENSION_ID.
  • PAY_PAYROLL_ACTIONS — join on PAYROLL_ACTION_ID.
  • PAY_TEMP_BALANCE_ADJUSTMENTS — child table referencing this table via BATCH_LINE_ID.
  • PAY_BALANCE_TYPES and PAY_BALANCES — related through the balance type identifier for balance-level reporting.