Search Results pay_puc_bus




Overview
Explore in AI Chat

Overview

PAY_PUC_BUS is a PL/SQL business-layer package in the Oracle EBS APPS schema that supports the Payroll User Column and User Table (PUC) framework. This framework allows implementers and customers to extend payroll processing with customer-defined columns and tables that participate in payroll run results without modifying Oracle-delivered database objects. In EBS 12.1.1 and 12.2.2, user columns and user tables are the standard mechanism for storing bespoke payroll balances, statutory values, or calculation inputs alongside delivered payroll data.

PAY_PUC_BUS acts as the central business rule enforcement point for the PUC feature set. It is responsible for security group context, legislation derivation, and validation of insert, update, and delete operations against user column and user table definitions. It sits between the maintenance forms/APIs and the underlying data model, delegating some work to the shadow package PAY_PUC_SHD, which it depends on. The package is classified as OTHER, indicating it is not a public, supported API in the traditional sense but an internal business component.

Key Procedures and Functions

  • SET_SECURITY_GROUP_ID — Establishes the security group context for subsequent PUC operations, ensuring that user column and user table processing is scoped to the correct business group/security group.
  • RETURN_LEGISLATION_CODE — Returns the legislation code applicable to the PUC context, which drives territory-specific validation and behaviour.
  • INSERT_VALIDATE — Performs validation logic before a user column or user table definition is inserted, verifying business rules and referential expectations.
  • UPDATE_VALIDATE — Validates proposed changes to an existing PUC definition, guarding against invalid or inconsistent modifications.
  • DELETE_VALIDATE — Validates that a PUC definition may be safely deleted, preventing removal of records still referenced or otherwise in use.

Tables Accessed

The package references these tables through APPS synonyms:

  • FF_FORMULAS_F and FF_FORMULA_TYPES — FastFormula definition and type metadata, consulted to associate PUC definitions with formula-based processing.
  • FND_TERRITORIES — Territory/legislation reference data supporting RETURN_LEGISLATION_CODE and territory validation.
  • PAY_USER_COLUMNS — The definition table for user columns added to payroll results.
  • PAY_USER_COLUMN_INSTANCES_F — The date-effective instances of those user column definitions.
  • PAY_USER_TABLES — The definition table for customer-defined user tables.

These reads and writes enforce consistency between PUC definitions, legislation, and formula metadata during validation.

Usage Notes

PAY_PUC_BUS is referenced by the shadow package PAY_PUC_SHD as well as PAY_PUC_DEL, PAY_PUC_INS, and PAY_PUC_UPD, the DML wrapper packages that perform the actual insert, update, and delete operations on PUC definitions. This confirms its role as the validation and context layer invoked by those wrappers, which are themselves called from Oracle Payroll setup forms, the User Tables and Columns maintenance UI, and related concurrent programs.

Custom code should generally not call PAY_PUC_BUS directly, since it is an internal business component; external integrations should use the supported DML packages or the setup forms. When troubleshooting PUC setup failures, PAY_PUC_BUS and its PAY_PUC_SHD dependency are first points of investigation, particularly for security group, legislation, or validation-driven errors. The package is VALID in the documented release, and understanding its validation gates is essential for any upgrade or customization touching the payroll user column and user table data model.