Search Results pay_ce_reconciled_payments




Overview
Explore in AI Chat

Overview

PAY_CE_RECONCILED_PAYMENTS 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 reconciliation information for payments that have been processed through Oracle Cash Management. When a payroll run produces payments — typically via check, EFT, or other disbursement methods — those payments flow to Cash Management for bank statement matching and clearing. This table captures the outcome of that clearing process, recording the reconciled amount, the date of clearing, and the base-currency equivalent of the cleared funds, linked back to the originating assignment action.

From a data modeling perspective, the heuristic classification derived from the foreign key structure is satellite-leaning. This suggests the table functions primarily as a dependent attribute store that enriches a parent business entity (the assignment action/payment) with reconciliation context, rather than acting as a standalone hub or a pure many-to-many link. Modelers should treat it as a descriptive satellite around the payment/assignment-action grain.

The table carries the primary key constraint PAY_CE_RECONCILED_PAYMENTS_PK on the RECONCILED_PAYMENT_ID column, and its documented physical schema contains seven columns.

Key Information Stored

The table's documented column set is compact and purpose-driven:

  • RECONCILED_PAYMENT_ID — The surrogate primary key. This is a system-generated identifier unique to each reconciliation record and is the sole documented unique index (business-key candidate) on the table.
  • ASSIGNMENT_ACTION_ID — Foreign key to PAY_ASSIGNMENT_ACTIONS. This ties the reconciliation record to the specific assignment-level payroll action that generated the payment, making it the principal business join key.
  • TRX_TYPE — Identifies the transaction type associated with the reconciled payment, distinguishing the nature of the underlying Cash Management transaction.
  • STATUS_CODE — Records the reconciliation status of the payment (for example, cleared, uncleared, or reconciled), enabling filtering and progress reporting.
  • CLEARED_AMOUNT — The monetary amount that was cleared against the bank statement, expressed in the transaction currency.
  • CLEARED_DATE — The date on which the payment was cleared/reconciled in Cash Management.
  • CLEARED_BASE_AMOUNT — The base-currency equivalent of the cleared amount, used for general ledger and reporting where multiple currencies are involved.

The primary key (RECONCILED_PAYMENT_ID) is a pure surrogate with no business meaning, whereas ASSIGNMENT_ACTION_ID serves as the practical business-key candidate connecting the record to the payroll process.

Common Use Cases and Queries

Typical uses include reconciliation reporting, unpaid/outstanding payment analysis, and audit of the payroll-to-Cash-Management clearing cycle. A representative query joins the table to its parent assignment action to retrieve employee-level payment status:

  • Identify unreconciled payroll payments for a period by filtering on STATUS_CODE.
  • Report total cleared amounts (CLEARED_AMOUNT and CLEARED_BASE_AMOUNT) by date or status.
  • Reconcile Payroll disbursements against Cash Management clearing data by joining on ASSIGNMENT_ACTION_ID to PAY_ASSIGNMENT_ACTIONS.
  • Multicurrency reporting comparing the cleared transaction amount to its base equivalent.

A sample pattern: SELECT r.RECONCILED_PAYMENT_ID, r.ASSIGNMENT_ACTION_ID, r.STATUS_CODE, r.CLEARED_AMOUNT, r.CLEARED_DATE FROM PAY_CE_RECONCILED_PAYMENTS r WHERE r.CLEARED_DATE BETWEEN :from_date AND :to_date. Because the table is satellite-leaning, most reporting is done through a join to the parent action rather than in isolation.

Related Objects

The following objects are significant due to documented or structural relationships:

  • PAY_ASSIGNMENT_ACTIONS — The documented foreign-key target via ASSIGNMENT_ACTION_ID; the immediate parent of each reconciliation record.
  • PAY_PAYROLL_ACTIONS — Parent of assignment actions, used to group reconciliations by payroll run.
  • PAY_PAYMENT_METHODS / payment-related payroll tables — Define the disbursement method that produced the payment being reconciled.
  • CE_STATEMENT_LINES / Cash Management clearing tables — Source of the bank clearing data reflected in STATUS_CODE, CLEARED_AMOUNT, and CLEARED_DATE.
  • PAY_ACTION_INFORMATION / PAY_RUN_RESULTS — Contextual payroll results tied through the assignment action for downstream reporting.

Together these objects support tracing a reconciled payment from the payroll run through Cash Management and back into payroll reporting.