Search Results pay_mx_archive_dbi_pkg




Overview
Explore in AI Chat

Overview

PAY_MX_ARCHIVE_DBI_PKG is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite, classified under the Oracle Payroll (PAY) module with a Mexico (MX) localization scope. The package name indicates its role in the archival and DataBase Item (DBI) handling of payroll-related configuration data, specifically in support of the Mexican year-end reporting processes. In Oracle Payroll, "DBI" refers to DataBase Items within the Oracle FastFormula framework — named values that are stored and retrieved from database tables for use in formula processing and reporting. The package is responsible for creating archive routes and archive database items, allowing historical payroll data structures to be preserved or regenerated for statutory reporting purposes.

The package is a supporting component of the Mexico year-end archival architecture, evidenced by the fact that it is referenced by the PAY_MX_YREND_ARCH object, which orchestrates the year-end archival process for Mexican payroll. The package status is VALID in the ETRM metadata, confirming it compiles cleanly against the documented table structures.

Key Procedures and Functions

Two documented procedures are exposed by this package:

  • CREATE_ARCHIVE_ROUTES — Creates the archive route definitions required to store archived DataBase Items. Routes in the FastFormula framework define the path by which a database item resolves to a value within a specific context. This procedure establishes the route records needed so that archived payroll values remain accessible through the formula and reporting layer.
  • CREATE_ARCHIVE_DBI — Creates the archived DataBase Items themselves. This procedure registers the DBI definitions into the FastFormula database item repository so that the archived values can be referenced by formulas and year-end reports without reliance on live transactional data.

No parameter lists are documented in the metadata, and none are inferred here.

Tables Accessed

The package operates on the Oracle FastFormula foundation tables through APPS synonyms:

Usage Notes

This package is not exposed through an end-user form; it is invoked programmatically as part of the Mexico year-end archival flow. The primary caller is PAY_MX_YREND_ARCH, which typically runs from a concurrent program during year-end processing. Because the package relies on the FastFormula foundation tables, it must run after the relevant pay elements and formulas have been defined for the period being archived. The procedures are idempotent in intent — routing and DBI records are created once per archival scope — and should generally be executed within the standard year-end archival sequence rather than in isolation. Custom code referencing this package directly should account for the absence of documented parameters and treat the procedures as internal building blocks of the supported year-end process.