Search Results pay_frr_data_pump




Overview
Explore in AI Chat

Overview

PAY_FRR_DATA_PUMP is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that supports the Formula Result Rules (FRR) infrastructure within Oracle Payroll. Formula Result Rules define how the output values produced by a payroll formula are written back into the assignment's element entry input values, statuses, or other payroll targets. The package functions as a data pump: it resolves the surrogate identifiers required to construct and manipulate Formula Result Rule definitions programmatically.

The package is classified as OTHER in the ETRM documentation, indicating it is a supporting utility package rather than a public, end-user-facing API. Its procedures retrieve the primary keys and identifiers needed when FRR records must be created, validated, or referenced through code — most commonly during bulk data loading, migration, or interfacing scenarios where formula result rules are assembled from external or staged data rather than entered through the Payroll forms.

In both EBS 12.1.1 and 12.2.2 the object resides in the APPS schema and is reported as VALID. The ETRM dependency metadata shows a self-referential entry, with APPS.PAY_FRR_DATA_PUMP listed as both referencing and referenced by itself in the dependency report, which is consistent with internal package-body references rather than any external consumer.

Key Procedures and Functions

The package exposes five documented procedures or functions, each oriented toward resolving an identifier used by the Formula Result Rules data model:

  • GET_STATUS_PROCESSING_RULE_ID — Resolves the identifier of a payroll status processing rule. Status processing rules govern how assignment status changes are applied when a payroll run processes an assignment, and the FRR framework references them when the rule being defined drives a status outcome.
  • GET_ELEMENT_TYPE_ID — Returns the element type identifier corresponding to a given element. Element type identifiers are the foreign key used throughout the payroll data model, and FRR definitions are keyed to element types.
  • GET_INPUT_VALUE_ID — Returns the identifier of an input value belonging to an element type. Formula result rules write results into element input values, so the input value identifier is a required component of the rule definition.
  • GET_FORMULA_RESULT_RULE_OVN — Returns the object version number for a formula result rule. Object version numbers support optimistic locking and change detection during updates to FRR records.
  • GET_FORMULA_RESULT_RULE_ID — Returns the primary key of an existing formula result rule, allowing callers to locate and reuse rule definitions rather than creating duplicates.

Tables Accessed

The package reads from and writes to the following tables through APPS synonyms:

Usage Notes

PAY_FRR_DATA_PUMP is not invoked directly from standard Payroll forms. It is a server-side utility called by other payroll PL/SQL code and by custom or Oracle-supplied batch processes that create or update formula result rules for an element. The presence of HR_PUMP_BATCH_LINE_USER_KEYS among its dependencies indicates it participates in batch data pump processing, where records are loaded from a staging table and identifiers must be resolved from user-entered keys before the FRR records can be inserted or updated.

The ETRM metadata records zero packages referencing this object, so it should be regarded as an internal component rather than a supported integration point. Customizations should not call it directly; instead, they should use the documented Formula Result Rules APIs or the Payroll element configuration forms. In both 12.1.1 and 12.2.2 the package remains VALID in the APPS schema, and no seeded invalidation is reported.