Search Results pay_fi_archive_psta




Overview
Explore in AI Chat

Overview

PAY_FI_ARCHIVE_PSTA is an Oracle Application Object Library package owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It belongs to the Oracle Payroll (PAY) product family and is classified under the ETRM API classification of OTHER, indicating it is an internal utility package rather than a published public API. The package supports the archival branch of the Oracle Payroll "FI" (Future Information / payroll data retention) processing stream, most commonly associated with the Payroll Archive and Payroll Purge functionality delivered through the Payroll Archive Process. Its role is to identify the payroll action context in which archival is being performed, resolve configuration parameters, and then write or move the relevant payroll, balance, assignment action, and person address records into the archive structures.

Key Procedures and Functions

The ETRM documentation records ten callable units within the package:

  • GET_PARAMETER — retrieves a single named parameter value used to drive the archival run.
  • GET_ALL_PARAMETERS — bulk-loads the full set of archival parameters for the current invocation.
  • RANGE_CODE — resolves the range/selection code that determines which payroll actions or assignments fall within the archival scope.
  • ASSIGNMENT_ACTION_CODE — derives the assignment action context, linking the archive to the specific payroll run and action.
  • INITIALIZATION_CODE — performs setup of internal state and working values before the main archival logic executes.
  • ARCHIVE_CODE — establishes the archive identifier/context used to tag archived records.
  • ARCHIVE_DATA — the primary worker routine that writes the selected payroll data into the archive tables.
  • ARCHIVE_PERSON_ADDRESS_DETAILS — archives person address information associated with the archived assignments.
  • GET_COUNTRY_NAME — resolves the country name for a given territory, supporting address archival.
  • GET_BALANCE_VALUE — retrieves and returns a balance value for archival against the defined balance structure.

Tables Accessed

The package reads and writes a focused set of Payroll and HR tables via APPS synonyms:

Usage Notes

PAY_FI_ARCHIVE_PSTA is invoked internally by the Payroll archival and purge flow, not by end users directly. It is typically triggered from the Oracle Payroll Archive Process concurrent program and related FI processing that coordinates the retirement of historical payroll data. The ETRM metadata shows the package is referenced by no other packages, and outside of SYS.STANDARD it has no further package dependencies, confirming it sits at the leaf of the call hierarchy. Custom code should not call this package directly; it relies on the calling framework having already established parameters and archive context.