Search Results gre_exists

Overview

PAY_MX_YREND_ARCH is an Oracle EBS payroll package in the APPS schema that supports the year-end archiving process for Mexican payroll (MX legislation). Its purpose is to move historical payroll data out of the active transactional tables and into dedicated archive tables, preserving the records required for statutory Mexican year-end reporting — including annual tax summaries, payroll tax returns, and electronic accounting file generation — while keeping the operational tables performant. The package carries a VALID status in both 12.1.1 and 12.2.2 and is classified as API type OTHER, meaning it is not a published open interface but an internal component that the application and dependent packages invoke.

Key Procedures and Functions

The ETRM documentation records seven procedures and functions within this package.

• GET_PAYROLL_ACTION_INFO — retrieves payroll action details for the period being archived, supplying the action context needed to drive the archive run.
• RANGE_CODE — determines the range or grouping code that governs which payroll records fall within the archive scope.
• ASSIGNMENT_ACTION_CODE — resolves the assignment action classification used to identify the payroll assignment actions eligible for archival.
• INITIALIZATION_CODE — performs the setup and initialization logic that prepares the package for an archive execution.
• ARCHIVE_CODE — the principal archive routine that moves or copies the identified year-end records into the archive structures.
• GRE_EXISTS — a Boolean/existence check that determines whether a GRE (Group Registration Employer) record already exists for the organization.
• LOAD_GRE — loads or creates the GRE record when GRE_EXISTS returns false, ensuring the employer registration data required for Mexican year-end output is present.

Tables Accessed

Dependency metadata shows a broad set of APPS synonyms being read and, in the archive path, written. Payroll action and period definitions are drawn from PAY_ACTION_INFORMATION, PAY_ACTION_CLASSIFICATIONS, PAY_ALL_PAYROLLS_F, PAY_ASSIGNMENT_ACTIONS, and PAY_ASSIGNMENT_ACTIONS_S. Employee and assignment context comes from PER_PEOPLE_F, PAY_EMP_ACTION_ARCH, HR_ASSIGNMENT_SETS, HR_ASSIGNMENT_SET_AMENDMENTS, and HR_LOCATIONS_ALL. Employer registration and organization data are sourced from HR_ORGANIZATION_INFORMATION. Archive configuration and Flexfields-driven archive metadata are held in FF_ARCHIVE_ITEMS, FF_ARCHIVE_ITEM_CONTEXTS, and FF_USER_ENTITIES. Balance dimension setup is read from PAY_BALANCE_ATTRIBUTES and PAY_BALANCE_DIMENSIONS, and FND_LOOKUP_VALUES supplies seeded lookup values used during classification and validation.

Usage Notes

PAY_MX_YREND_ARCH is invoked as part of the Mexican year-end payroll cycle, generally through a concurrent program or an internally chained call invoked by another package rather than by direct user action on a form. ETRM shows it is referenced by one other package, PAY_MX_PTU_CALC (profit-sharing calculation), and by itself, indicating that the PTU calculation process relies on the year-end archive state. Because it manipulates payroll assignment actions and balance dimensions, it should be run in a controlled window, after payroll completion and before downstream statutory reporting, with the standard prerequisite that the fiscal year’s payroll actions are closed. Custom code should not call individual procedures out of sequence; the intended entry point is the archive execution path, since GET_PAYROLL_ACTION_INFO, RANGE_CODE, and INITIALIZATION_CODE establish context consumed by ARCHIVE_CODE. The GRE_EXISTS and LOAD_GRE pair should be exercised against HR_ORGANIZATION_INFORMATION to confirm the employer registration is valid prior to generating Mexican year-end electronic reporting.