Search Results reporting_siret_len




Overview
Explore in AI Chat

Overview

APPS.PER_FR_ELECTION is a French localization package body within Oracle E-Business Suite 12.1.1 and 12.2.2 that supports the generation of statutory election and employee-representation reporting required under French labour law. Specifically, it assembles the data structures used to produce the electoral roll and related establishment-level reporting used to determine voting constituencies, electoral colleges, and voting places for employee representative elections. The package is classified under the ETRM taxonomy as OTHER, reflecting that it is a localization support utility rather than a general-purpose HRMS API.

The single documented entry point, PROCESS, is a concurrent-program style procedure. It accepts a company identifier, an establishment identifier, a reporting establishment identifier, and an effective date, together with the standard concurrent manager OUT parameters ERRBUFF and RETCODE. The header comment indicates a legacy source base (pefrphmm.pkb, version 115.6), consistent with the long-standing French payroll and HR localization shipped in EBS.

The body declares a large set of fixed-length constants that mirror the French statutory reporting layout: SIRET_LEN and REPORTING_SIRET_LEN (14), NAF_CODE_LEN (4), INSEE_CODE_LEN (5), POSTAL_CODE_LEN (5), SS_NUMBER_LEN (13), SS_KEY_LEN (2), DATE_OF_BIRTH_LEN (6), DEPARTMENT_OF_BIRTH_LEN (2), ELECTORAL_COLLEGE_LEN (1), SECTION_LEN (1), and VOTING_PLACE_LEN (1). These constants govern the column widths used when the procedure formats each reporting record, and they are the mechanism by which the package enforces the fixed-format requirements of the French declaration.

In addition to the numeric lengths, the body defines paired VARCHAR2 variables for title, underline, record, and log lines for each report section (establishment header, person, reporting establishment, start record, footer, and end record), along with counters for person, error, and warning totals and error/warning status flags. This structure indicates that PROCESS writes a formatted report, tracks the number of persons processed, and accumulates validation errors and warnings for each run.

Key Procedures and Functions

  • PROCESS — The sole documented procedure. It drives the production of the French election/representation output for a given company, establishment, reporting establishment, and effective date. It returns a completion status through RETCODE and an error message through ERRBUFF, following the standard concurrent program calling convention. Internally it initializes the report headings and formatting variables, resolves the establishment and person data, applies the fixed-length validation rules implied by the declared constants, and accumulates error and warning counts before emitting the report records.

Tables Accessed

The package reads from the following tables through APPS synonyms:

  • HR_ALL_ORGANIZATION_UNITS — supplies the establishment and reporting establishment definitions.
  • HR_ORGANIZATION_INFORMATION — supplies organization-level descriptive attributes such as establishment names and identifiers used in the report header.
  • HR_SOFT_CODING_KEYFLEX — supplies the French SIRET, NAF, and INSEE code values held in the organization key flexfield.
  • PER_ADDRESSES — supplies establishment address lines used in the header and footer records.
  • PER_ALL_PEOPLE_F — supplies employee names, birth names, first and last names, dates of birth, and places of birth required for the electoral roll.
  • PER_ALL_ASSIGNMENTS_F — supplies the assignment records that determine an employee's establishment, section, and eligibility.
  • PER_ASSIGNMENT_STATUS_TYPES — determines whether an assignment is active for the effective date, so that only current employees appear on the roll.
  • PER_CONTRACTS_F — supplies contract details used to classify employees for electoral college and section assignment.
  • PER_PEOPLE_EXTRA_INFO — supplies French-specific person attributes, including social security number components and other statutory fields.

Usage Notes

PER_FR_ELECTION.PROCESS is typically invoked as a concurrent program submitted from the French HRMS responsibility, or called directly from custom code that reproduces the statutory report. Because it conforms to the concurrent manager interface (ERRBUFF, RETCODE), it can be registered as an executable and scheduled. It is not referenced by any other documented package, so it sits at the leaf of the dependency tree and is safe to call in isolation. The package has no documented dependencies beyond the listed tables, which simplifies impact analysis during patching. Note that the header comment dates to 2003, so the logic reflects earlier French statutory formats; customers on 12.2.2 should verify that the fixed-length constants still match current regulatory requirements before relying on the output for filing. When searching for "decode_lookup", it is relevant that this package performs its code decoding through explicit constants and HR key flexfield lookups rather than a shared DECODE_LOOKUP utility, so tuning or extending the decoding logic requires modifying the package body itself.