Search Results get_token

Overview

APPS.PAY_SE_ALECTA_UPLOAD is a Swedish (SE) localizations upload utility within the Oracle E-Business Suite Payroll module. It is responsible for reading an external data file and loading its contents into the EBS database for processing in the context of a specific business group and effective date. The package is classified as an "OTHER" API type, meaning it is a supporting utility rather than a public, formally versioned API. Its name indicates that it is designed for Alecta, a Swedish occupational pension provider, and the file being uploaded is therefore likely a pension or insurance contribution file destined for downstream payroll processing. The package operates under the APPS schema and is associated with Oracle release line 120.0.12010000.1 (header pyseaaru.pkb), consistent with EBS 12.1.1 and 12.2.2.

Key Procedures and Functions

The package contains three documented procedures/functions, all serving the file ingestion cycle.

• UPLOAD — The primary entry point. It declares standard concurrent program output parameters (errbuf, retcode) along with the input file name, effective date, and business group ID. Its body initializes file reading against the PER_DATA_EXCHANGE_DIR directory, resolves the business group's legislation code and name via a cursor on PER_BUSINESS_GROUPS, creates an FND_SESSIONS row, and drives the line-by-line read (up to a maximum line size of 4000). It layers in error handling (warning/error constants, end-of-time date, and a fatal error exception) and logs progress via HR_UTILITY.SET_LOCATION. The procedure effectively orchestrates read-responsibility from source file to database content.
• COMPARE_RECORD — A helper routine used during or after upload to compare an incoming record against existing/expected data, thereby validating the file contents.
• GET_TOKEN — A parsing helper. Given the fixed-width or delimited nature of the Alecta upload file, this function extracts individual fields/tokens from a line of text so that each attribute can be mapped to its destination column. Users searching for "get_token" are typically troubleshooting how the package splits or interprets incoming file lines.

Tables Accessed

The package reads from and writes to the following objects via APPS synonyms:

• PER_BUSINESS_GROUPS — Read to determine the legislation code and name for the supplied business group, establishing that the upload is processed under the correct Swedish statutory context.
• FND_SESSIONS — Written during initialization to register the session ID and canonical effective date, a standard requirement for EBS processes that must be session-aware.
• PAY_ACTION_INFORMATION — The principal payroll target table; uploaded records are ultimately destined for this structure so that payroll processing can consume them.
• UTL_FILE — Database directory/file utility used to open the input file for sequential read in the PER_DATA_EXCHANGE_DIR directory.

Usage Notes

PAY_SE_ALECTA_UPLOAD is normally invoked as a concurrent program or via a host/request submission from the Swedish payroll localization. Its UPLOAD signature matches the standard concurrent-program parameter convention, indicating it is registered and run through the concurrent manager. Before execution, the source Alecta file must be placed in the directory referenced by the PER_DATA_EXCHANGE_DIR directory alias, and the caller must supply a valid business group ID and effective date. Because the package is not referenced by any other documented package (0 dependents), integrations call it directly rather than through a wrapping API. Administrators troubleshooting loads should verify the file location and format, the session insert into FND_SESSIONS, and the token parsing performed by GET_TOKEN, since malformed lines are a common cause of load failures.