Search Results hxt_retrieval_rollback




Overview
Explore in AI Chat

Overview

APPS.HXT_RETRIEVAL_ROLLBACK is an Oracle E-Business Suite package that implements the rollback and reversal logic for Oracle Time and Labor (OTL) retrieval processing. Its primary business purpose is to reverse timecard transactions that were previously retrieved and transferred into Oracle Payroll — including standard (normal) batches, retroactive batches, BEE (Batch Element Entry) transfers, and timecard overtime/labor (OTLR) transfer records. Rollback is required whenever a retrieval batch must be undone because of incorrect payroll processing, rejected data, data set corrections, or re-submission of timecards prior to actual payroll run. The package maintains a set of package-global associative arrays that act as an in-memory cache, tracking reversal batches, replacement batches, reversal batch sequence numbers, IV (invalid/timecard) positions, batch status, archive status, data set status, rollback eligibility, and error counts while processing large retrieval operations.

Key Procedures and Functions

  • ROLLBACK_NORMAL_BATCHES — Rolls back a normal (non-retroactive) retrieval batch identified by batch, batch status, and optionally person.
  • ROLLBACK_RETRO_BATCHES — Handles rollback of retroactive batches, which contain prior-period adjustments that must be reversed differently from current-period normal batches.
  • PUT_LOG — Writes diagnostic/audit text to the rollback log, optionally bypassing the package cache based on the p_cache flag.
  • ROLLBACK_BEE — Performs the rollback for Batch Element Entry transfers, accepting BEE/batch group identifiers, a validate mode, from/to batch range, batch reference, person, single-record flag, and rollback mode. Parameters are supplied as documented; their lists are not redefined here.
  • ROLLBACK_BEE_RETRO — Retroactive counterpart of ROLLBACK_BEE, reversing BEE transfers for prior-period retro batches.
  • ROLLBACK_XFER_TIME_OTLR — Reverses timecard transfers that were sent to OTLR (Time and Labor Retrieval), typically invoked from the retrieval/transfer rollback flow when a transferred timecard batch must be withdrawn. This is the procedure associated with the user's search term "rollback_xfer_time_otlr".

Tables Accessed

The package reads and writes several Oracle Time and Labor and Payroll tables through APPS synonyms. HXC_TRANSACTIONS and HXC_TRANSACTION_DETAILS hold retrieved timecard transactions. HXC_ROLLBACK_LOG, HXC_ROLLBACK_TIMECARDS_ALL, HXC_RET_PAY_DETAILS, and HXC_RET_PAY_LATEST_DETAILS record rollback attempts and the retrieved payroll details. HXC_TIMECARD_SUMMARY, HXC_DATA_SETS, and HXC_PAY_LATEST_DETAILS support batch/summary and data set state checking. HXT_BATCH_STATES, HXT_REVERSED_BATCH_LINES_ALL, HXT_REVERSED_BATCH_TC_ALL, HXT_DET_HOURS_WORKED_F, and HXT_SEQNO maintain batch reversal line detail, reversed timecards, hours worked facts, and the sequence used to generate reversal identifiers. FND_SESSIONS is referenced to track the session context. These tables are joined and updated to validate rollback eligibility, create reversal records, and log the rollback outcome.

Usage Notes

HXT_RETRIEVAL_ROLLBACK is typically invoked by Oracle Time and Labor concurrent programs and the Retrieve/Transfer rollback forms rather than directly by users. The BEE procedures are commonly called from payroll batch element entry rollback flows, while ROLLBACK_NORMAL_BATCHES and ROLLBACK_RETRO_BATCHES are invoked from OTL batch retrieval rollback processes. Customizations should call the documented procedures only, respecting the validate mode and rollback mode parameters, and should query HXC_ROLLBACK_LOG and HXT_BATCH_STATES to confirm completion. Because the package caches state in package-global arrays, a single session should not attempt to roll back overlapping batches concurrently.