Search Results main_retro

Overview

HXT_RETRO_PROCESS is a PL/SQL package owned by the APPS schema that forms part of the Oracle Time and Labor (OTL) module within Oracle E-Business Suite. Its principal business function is the retroactive processing of timecard data. In time and labor environments, retroactive adjustments occur when a previously approved or transferred timecard is subsequently corrected—for example through a late-arriving timesheet, a correction approved after the original pay period closed, or a change to a time entry that must be pushed back into payroll costing and distribution. The package provides the programmatic infrastructure to detect, stage, and re-drive these retrospective transactions so that downstream payroll processing receives the corrected hours and associated costs.

The package is classified under the ETRM API classification scheme as OTHER, indicating it is an internal processing utility rather than a published open interface. Its status is VALID, and it is documented in the ETRM repository for both EBS 12.1.1 and 12.2.2.

Key Procedures and Functions

The documented interface exposes a single procedure, MAIN_RETRO. This is the driver routine for the retrospective processing cycle. Its purpose is to control the orchestration of retroactive timecard handling—identifying candidate records, evaluating batch state, and coordinating the transfers required to make corrected time data available for payroll retrieval. The ETRM metadata does not document a parameter list for MAIN_RETRO; parameter details must be obtained from the package source (HXT_RETRO_PROCESS package specification).

Dependency analysis shows the package references FND_GLOBAL (for session context such as user and responsibility identifiers) and FND_USER (for resolving the acting user). It also references STANDARD, the standard Oracle package commonly used for errbuf and retcode output parameters, which strongly suggests MAIN_RETRO is designed to be invoked as a concurrent program entry point. The package references itself (recursive or internal call patterns) and is referenced by HXT_OTC_RETRIEVAL_INTERFACE.

Tables Accessed

• HXT_BATCH_STATES — Holds the processing state of timecard batches. The retro process reads this table to determine which batches have reached a state eligible for retroactive reprocessing and updates it as batches move through the retro cycle.
• HXT_DET_HOURS_WORKED_F_AR — The detail-level hours worked fact table used by OTL for reporting and retrieval. Retro processing reads corrected hours from this table and marks them for transfer downstream.
• PAY_BATCH_HEADERS — The Oracle Payroll batch header table. Referenced so that retroactively adjusted time can be associated with, or validated against, the payroll batch that will consume it.
• FND_USER — Used to resolve the user identity associated with the retro run or with the original timecard action.
• PLITBLM — A PL/SQL index-by table type declaration used by Oracle for bulk collect and array processing; its presence indicates the package performs set-based, bulk operations over the volume of retroactive records.

Usage Notes

HXT_RETRO_PROCESS is an internal engine rather than a public API. It is typically invoked either from the HXT_OTC_RETRIEVAL_INTERFACE package—which retrieves timecard data for downstream consumption—or through a concurrent program registered against MAIN_RETRO, since the presence of the STANDARD package implies standard concurrent manager return parameters. It may also be called from custom code, but doing so is not supported and requires that the APPS schema and FND_GLOBAL session context be correctly established first.

Administrators and implementers encounter this package indirectly during retroactive timecard troubleshooting, payroll retro reconciliation, and time-to-payroll transfer failures. Because the package performs direct manipulation of state tables, any diagnostic or re-run activity should be performed in a controlled environment, with the OTL and payroll batch states understood before invocation.