Search Results pay_element_classifications_s

Overview

The APPS.PAY_DB_LOCALISATION_PKG package is a seeded Oracle Payroll database-layer utility whose purpose is to install and maintain the legislative setup data required by a specific country's localisation. Its documented role is to create the balance dimensions, balance types, defined balances, element classifications, payment types, legislation rules and assignment information types that a payroll localisation depends upon, so that a fresh or upgraded environment contains the seed rows that the payroll engine expects.

The header comment dates the package to 26-Nov-92 and attributes it to Oracle Corporation UK Ltd., which confirms that the GB (United Kingdom) localisation was the original driver. The body file pylocaln.pkb and the sequential change history (create_BF_localisation added at version 3.2, create_payments_balance at 3.3, removal of the FORMULA_ID column from the pay_payment_types insert at 3.5) all point to a long-lived installation script rather than a transactional runtime API. The package is classified as OTHER; it is not a public HRMS business API, and it is not referenced by any other documented package.

Key Procedures and Functions

• CREATE_GB_LOCALISATION — performs the United Kingdom legislative installation. It inserts the seed rows that the GB payroll localisation requires across the balance, classification, payment type and assignment information type tables.
• CREATE_BF_LOCALISATION — performs the equivalent installation for the BF localisation. It was added at version 3.2 of the package and follows the same seed-data pattern as the GB routine.

Both procedures are installation-oriented: they are intended to be run once against an environment that does not yet hold the localisation rows, and they write directly to the underlying tables rather than calling validation APIs. Parameter lists are not part of the documented metadata and should be confirmed against the deployed source before invocation.

Tables Accessed

The package writes to the core payroll definition tables, which are accessed through APPS synonyms:

• PAY_BALANCE_DIMENSIONS — the dimensions (for example assignment, run, or period-to-date combinations) attached to each balance.
• PAY_BALANCE_TYPES and PAY_BALANCE_TYPES_S — the balance type definition and its translated (TL) counterpart, supplied here as seed balances.
• PAY_DEFINED_BALANCES and PAY_DEFINED_BALANCES_S — user-defined balances built from other balances; the package seeds the localisation's delivered examples.
• PAY_ELEMENT_CLASSIFICATIONS and PAY_ELEMENT_CLASSIFICATIONS_S — classification rows used to group elements; the change list notes the addition of the COSTABLE_FLAG column to this insert.
• PAY_LEGISLATION_RULES — the rules that bind balances and elements to a legislation for validation purposes.
• PAY_PAYMENT_TYPES and PAY_PAYMENT_TYPES_S — payment method definitions; the FORMULA_ID column was removed from this insert at version 3.5.
• PER_ASSIGNMENT_INFO_TYPES — assignment-level descriptive information types; the change list records that the ACTIVE_INACTIVE_FLAG was corrected in this insert.
• DUAL — used for single-row selection expressions within the procedural logic.

Usage Notes

Because PAY_DB_LOCALISATION_PKG is referenced by no other documented package, it is not invoked as part of routine payroll processing. It is a setup utility, and in practice it is executed as one-off seed data installation during localisation deployment, environment cloning, or remediation of missing delivered rows. The safest pattern for Oracle EBS 12.1.1 and 12.2.2 is to run the relevant procedure from a controlled SQL*Plus or concurrent request session under the APPS schema, after confirming that target rows are absent, and to take a backup of the affected PAY and PER tables beforehand. The change list shows that the INSERT statements have been amended repeatedly over the years, so the deployed body may differ between patch levels; the version in a given environment should always be checked before the package is used for data correction.