Search Results get_balance_value

Overview

PAY_FI_PAYLIST_ARCHIVE is an Oracle EBS Payroll (PAY) package body classified as a concurrent-program support module rather than a public API. Its business purpose is to archive payment list (payslip) data for a payroll run, producing the stored paylist records that Oracle Payroll uses for government-mandated and statutory paylist reporting such as the Finnish paylist (PAY_FI) requirement implied by the package prefix. The package operates in the standard Oracle Payroll concurrent processing model: it reads the legislative parameters supplied to a payroll action, executes archive logic in the range, assignment action, initialization, and archive phases, and writes archived assignment action and balance information for later reporting. State is maintained through package globals including the business group, effective date, payroll and pay period identifiers, legal employer, and the run and archive payroll action identifiers, along with a lock table used to coordinate processing.

Key Procedures and Functions

• GET_PARAMETER — parses a token/value pair from the payroll action legislative parameter string, supporting both space and pipe delimiters, and is the general utility used to decode concurrent program parameters.
• GET_ALL_PARAMETERS — populates the package-level globals (business group, effective date, trade union, legal employer, start date, payroll, pay period, and related descriptive fields) from the parameter string in a single pass.
• RANGE_CODE — the range code phase of the payroll action, used to define the chunking or action ranges processed by the concurrent request.
• ASSIGNMENT_ACTION_CODE — the assignment action phase, invoked per assignment action to perform paylist archive work for the assignments within the current range.
• INITIALIZATION_CODE — the initialization phase, invoked before processing begins to set up globals and archive context for the run.
• ARCHIVE_CODE — the archive phase, which executes the final archive action and writes the archived paylist data for the payroll action.
• GET_BALANCE_VALUE — the function associated with the user's search term; it retrieves a defined balance value for an assignment from the balance and defined-balance tables, used to obtain paylist amounts and accumulators.

Tables Accessed

The package reads and writes Oracle Payroll core tables through APPS synonyms. PAY_PAYROLL_ACTIONS supplies the legislative parameter string and action context; PAY_ASSIGNMENT_ACTIONS and PAY_ASSIGNMENT_ACTIONS_S hold the assignment-level action rows being archived. Balance retrieval uses PAY_DEFINED_BALANCES, PAY_BALANCE_TYPES, and PAY_BALANCE_DIMENSIONS, with FF_DATABASE_ITEMS and associated fast-formula objects for balance definition metadata. Assignment, person, and period context come from PER_ALL_ASSIGNMENTS_F, PER_ALL_PEOPLE_F, and PER_TIME_PERIODS. PAY_ALL_PAYROLLS_F provides payroll definitions, PAY_ACTION_INFORMATION holds parameter and reporting information, PAY_ACTION_INTERLOCKS serializes concurrent payroll actions, and DUAL supports utility queries.

Usage Notes

PAY_FI_PAYLIST_ARCHIVE is invoked as the PL/SQL body behind the Finnish paylist archive concurrent program in Oracle Payroll. It is not referenced by any other documented package (referenced by 0 packages), which indicates it is an entry-point module driven by concurrent processing rather than by a shared API. Typical invocation is through the Submit Request flow, where the payroll action framework calls the range, initialization, assignment action, and archive phases in sequence, passing legislative parameters that GET_ALL_PARAMETERS decodes. The debug flag derived from HR_UTILITY.DEBUG_ENABLED allows tracing through HR_UTILITY.SET_LOCATION. Custom code should not call this package directly; where paylist or balance data is required, supported APIs and views should be used instead. Organizations implementing statutory paylist reporting in Oracle EBS 12.1.1 or 12.2.2 should treat this package as internal infrastructure and rely on the delivered concurrent program and its parameters.