Search Results remove_report_actions




Overview
Explore in AI Chat

Overview

PAY_ARCHIVE (source file pyarchiv.pkh, version 120.0.12010000.1) is an Oracle Payroll archive utility package owned by APPS that supports the archiving and de-archiving of payroll data against the Oracle FastFormula and payroll action framework. It provides the runtime plumbing—context loading, jurisdiction and database-item level resolution, chunk processing and de-initialisation—used when payroll results, defined balances and archive items are moved between the live application tables and the archive schema. In Oracle EBS 12.1.1 and 12.2.2 this package is part of the Payroll (PAY) module's archive infrastructure and is classified as OTHER rather than as a public business API, meaning it is intended for internal and upgrade/diagnostic use rather than for direct customer calls.

The package header carries a long change history reflecting its evolution between 1998 and 2004: multi-context functionality (40.1), set_jur_level, remove_report_actions, archive_aa, UTF8 support via the varchar_240_tbl type, the de-initialise section (115.4), get_jursd_level and the g_leg_code global (115.5), DBDRV standards (115.6), standard_deinit (115.7) and process_chunk (115.8). The presence of standard_deinit—the term the user searched for—dates from version 115.7 (16-JUL-2002) and provides a standardised teardown entry point used by the archive driver.

Key Procedures and Functions

  • ARCH_INITIALISE — initialises an archive run, establishing the session state and context collections required by subsequent archive operations.
  • GET_JURSD_LEVEL — returns the jurisdiction/defined-balance level used to determine which archive items are in scope.
  • DEINITIALISE — the original teardown routine, added in version 115.4, that releases package globals and archive session state.
  • STANDARD_DEINIT — the standardised de-initialisation entry point added in version 115.7; the routine most commonly referenced in archive driver code and the object of the "standard_deinit" search.
  • PROCESS_CHUNK — processes a bounded chunk of archive records, enabling large archive sets to be committed incrementally rather than in one transaction.
  • PROCESS_EMPLOYEE — processes archive data for an individual employee/assignment.
  • SET_DBI_LEVEL — sets the database-item (DBI) level controlling which FastFormula database items are archived.
  • REMOVE_REPORT_ACTIONS — cleans up report-related actions generated during the archive cycle.

Tables Accessed

The package reads and writes FastFormula archive metadata through APPS synonyms: FF_ARCHIVE_ITEMS, FF_ARCHIVE_ITEMS_S, FF_ARCHIVE_ITEM_CONTEXTS, FF_CONTEXTS, FF_DATABASE_ITEMS, FF_FDI_USAGES_F, FF_ROUTES, FF_ROUTE_CONTEXT_USAGES, FF_ROUTE_PARAMETERS, FF_ROUTE_PARAMETER_VALUES and FF_USER_ENTITIES. These define which items, contexts and route parameters are archived. Payroll-specific tables include PAY_ACTION_INTERLOCKS, PAY_ASSIGNMENT_ACTIONS, PAY_BALANCE_TYPES and PAY_DEFINED_BALANCES, which supply the action, assignment and balance data underpinning the archive set. Access is predominantly read-oriented for the FF_* metadata tables and read/write for the archive and payroll action tables.

Usage Notes

PAY_ARCHIVE is invoked indirectly—from concurrent programs and archive driver routines in the Payroll module, and from other packages (it is referenced by 24 packages) rather than from end-user forms. Custom code should not call the procedures directly unless reproducing Oracle's archive sequence; the correct invocation pattern is arch_initialise, one or more process_chunk/process_employee calls, then standard_deinit for teardown. Because standard_deinit and deinitialise clear package globals such as g_context_values and g_leg_code, they must always be executed to avoid stale session state leaking between archive runs. As an OTHER-classified package, its signatures are not guaranteed across patches; upgrades between 12.1.1 and 12.2.2 should be validated against the shipped pyarchiv.pkh.