Search Results pay_se_alecta_upload

Overview

PAY_SE_ALECTA_UPLOAD is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that supports the upload of external payroll data files supplied by Alecta, a Swedish occupational pension provider, into Oracle Payroll. The package is part of the localization layer for Swedish payroll processing and is declared with AUTHID CURRENT_USER, meaning its SQL statements execute under the privileges of the invoking user rather than the package owner. Its principal entry point is a procedure named UPLOAD, which is designed to be invoked as a concurrent program: it accepts the standard concurrent manager errbuf and retcode OUT parameters alongside the input file name, an optional effective date defaulting to SYSDATE, and a mandatory business group identifier. The presence of this signature indicates the package is intended to run in a batch context rather than interactively.

Key Procedures and Functions

The package exposes three documented program units:

• UPLOAD — The primary driver procedure. It reads an Alecta-provided file, parses its contents, and applies the resulting data into the Oracle Payroll tables for the specified business group. The p_effective_date parameter allows the caller to control the date context of the upload, while p_business_group_id scopes the operation to the correct legislative and payroll environment. The standard concurrent program OUT parameters allow the request to return a completion code and message to the concurrent manager.
• COMPARE_RECORD — A validation procedure that accepts a single line of input data (p_line) and returns an OUT flag (p_record_found) indicating whether a matching record already exists. This is used within the upload process to detect duplicate or previously loaded entries before insertion, ensuring idempotency and preventing duplicate payroll data. This procedure is directly relevant to users searching for compare_record, as it is the internal reconciliation routine of the package.
• GET_TOKEN — A helper function that returns a delimited token from an input string based on a positional index, with a default delimiter of semicolon (;). It provides the field-parsing mechanism used to decompose each line of the Alecta file into its constituent data elements before validation and loading.

Tables Accessed

The package references three documented objects through APPS synonyms:

• PAY_ACTION_INFORMATION — The core Oracle Payroll table holding informational entries associated with payroll actions. The upload process writes Alecta pension data into this table so that it is available to subsequent payroll runs and reporting.
• FND_SESSIONS — Used to establish or reference session context, a common requirement when a batch or API process must emulate an application session for audit and security purposes.
• UTL_FILE — The Oracle-supplied file I/O package invoked to read the external Alecta file from a directory on the database server. This confirms the upload operates against a server-side file located via an Oracle directory object rather than client-side input.

Usage Notes

PAY_SE_ALECTA_UPLOAD is invoked as a concurrent program in Oracle Payroll for Swedish business groups, typically from the Submit Requests form or via the concurrent manager. Because the UPLOAD procedure conforms to the standard concurrent program interface, it can be registered as a PL/SQL concurrent program definition and scheduled on a recurring basis to process periodic Alecta files. The package is not referenced by any other documented package, so it functions as a terminal entry point rather than a reusable API layer. Custom code may invoke COMPARE_RECORD or GET_TOKEN individually where line-level validation or token parsing of similarly formatted files is required, but these are secondary to the main batch upload flow. As with any process reading external files, the required Oracle directory object and file system permissions must be in place before submission.