Search Results pay_adjust_batch_lines




Overview
Explore in AI Chat

Overview

PAY_ADJUST_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 adjustment lines that make up a balance adjustment batch, forming the transactional detail layer beneath the batch definition. Balances adjustment batches allow payroll administrators to load or correct payroll balance values directly for assignments, elements, and tax units without running a full payroll process. Each row in PAY_ADJUST_BATCH_LINES represents a single assignment-level adjustment entry, including the element, input values, and cost allocation context associated with that entry.

The table is documented as VALID in ETRM for 12.2.2 and contains 64 columns. Based on its foreign key structure, the heuristic Data Vault classification is link: the table resolves and connects multiple business entities — the parent batch header, the batch group, and the cost allocation key flexfield — rather than acting as a standalone hub or descriptive satellite. This classification is offered as a modeling suggestion consistent with the mined FK relationships.

Key Information Stored

The documented primary key is PAY_ADJUST_BATCH_LINES_PK on BATCH_LINE_ID, a surrogate identifier with no intrinsic business meaning. No alternative unique index is documented, so BATCH_LINE_ID is the sole documented business-key candidate. The most significant columns include:

Common Use Cases and Queries

Typical use cases include auditing a balance adjustment batch before or after processing, reconciling loaded entries against expected amounts, and reporting on adjustments by assignment or tax unit. A representative query joins the line to its header:

  • SELECT l.batch_line_id, l.batch_id, l.assignment_id, l.entry_value1, l.batch_line_status FROM pay_adjust_batch_lines l WHERE l.batch_id = :p_batch_id ORDER BY l.batch_line_sequence;
  • Join to PAY_BALANCE_BATCH_HEADERS on BATCH_ID to retrieve batch name and status.
  • Join to PAY_ADJUST_BATCH_GROUPS on BATCH_GROUP_ID to report grouped totals.
  • Aggregate ENTRY_VALUE columns by ASSIGNMENT_ID or TAX_UNIT_ID for adjustment summaries.

Related Objects

  • PAY_BALANCE_BATCH_HEADERS — parent batch header; join on BATCH_ID.
  • PAY_ADJUST_BATCH_GROUPS — batch grouping; join on BATCH_GROUP_ID.
  • PAY_COST_ALLOCATION_KEYFLEX — costing keyflex; join on COST_ALLOCATION_KEYFLEX_ID.
  • PAY_ELEMENT_TYPES_F and PAY_ELEMENT_LINKS_F — element and link definitions referenced via ELEMENT_TYPE_ID and ELEMENT_LINK_ID.
  • PAY_INPUT_VALUES_F — input value definitions behind INPUT_VALUE_ID1–15.
  • PER_ALL_ASSIGNMENTS_F — assignment details referenced by ASSIGNMENT_ID.