Results for “je_fr_das2_le_headers_t”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

The JE_FR_DAS2_LE_HEADERS_T table is a legal entity header table within the JE – European Localizations product family of Oracle E-Business Suite. Its documented purpose is to store header information for a Legal Entity, specifically supporting the French DAS2 (Déclaration Annuelle des Salaires, version 2) regulatory reporting requirements. The table resides in the AP schema and is classified as VALID in both EBS 12.1.1 and 12.2.2 environments. The documented physical schema for 12.2.2 identifies 37 columns, reflecting the extensive set of French statutory address and identification attributes required for DAS2 declarations.

From a Data Vault modeling perspective, the heuristic classification derived from the foreign key structure is satellite. This is a modeling suggestion: the table carries a foreign key to FV_LEGAL_ENTITIES via LEGAL_ENTITY_ID, meaning it enriches the legal entity hub with descriptive, jurisdiction-specific attributes rather than acting as an independent hub or a link between two hubs.

Key Information Stored

The table combines a small set of standard EBS audit columns with a large block of French-localization reporting attributes. The most significant columns are:

• LEGAL_ENTITY_ID – The foreign key to FV_LEGAL_ENTITIES. This is the principal join column and the effective business-key reference for the record. In the absence of a separately documented surrogate key column in the metadata, it also functions as the de facto primary identifier for each header row.
• SET_OF_BOOKS_ID – Ties the legal entity header to a specific set of books, establishing the accounting context for the DAS2 declaration.
• SIRET_ENTR – The SIRET (Système d'Identification du Répertoire des Établissements) number of the enterprise, a mandatory French business identifier.
• RAISON_SOCIALE – The registered legal name (company name) of the declaring entity.
• CODE_APE – The APE/NAF activity code classifying the entity's principal business activity.
• TYPE_ENREG and TYPE_FICHIER – Record-type and file-type indicators used to control the DAS2 declaration format and submission mode.
• ADR_CPOSTAL, ADR_COMMUNE, ADR_INSEE, ADR_BUR_DIST, ADR_COMPL, ADR_CONCAT – The full postal address block for the enterprise, including postal code, commune/city, INSEE code, arrondissement/district, complementary address lines, and the concatenated address used in the flat-file output.
• SIRET_ETAB – The SIRET number of the establishment, distinct from the enterprise-level SIRET where an establishment-level declaration is required.
• ADR_CPOSTAL_ET, ADR_COMMUNE_ET, ADR_INSEE_ET, ADR_BUR_DIST_ET, ADR_COMPL_ET, ADR_CONCAT_ET – The parallel establishment-level address block.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN – Standard EBS WHO-column audit trail, enabling change tracking and concurrency validation across the 12.1.1 and 12.2.2 releases.

Several columns carry placeholder-style names (Z01, Z1, Z3, Z4, Z5, Z6, Z7, Z9, Z10, Z11, Z0_94_1, Z0_94_2). These are reserved or positional fields in the DAS2 file layout, used to pad or map to fixed positions in the statutory output file.

Common Use Cases and Queries

This table is primarily queried during DAS2 return preparation, French statutory reporting validation, and legal entity address reconciliation. A typical retrieval joins the header table to the legal entity view:

SELECT h.legal_entity_id,
       h.raison_sociale,
       h.siret_entr,
       h.code_ape,
       h.adr_cpostal,
       h.adr_commune
FROM   ap.je_fr_das2_le_headers_t h,
       fv_legal_entities           le
WHERE  h.legal_entity_id = le.legal_entity_id
AND    h.set_of_books_id = :p_sob_id;

Common scenarios include generating the DAS2 enterprise and establishment address blocks, verifying that SIRET and INSEE codes are populated before submission, and auditing which legal entities within a given set of books have complete header records. Reconciliation queries filtering on LAST_UPDATE_DATE support change auditing between reporting periods.

Related Objects

The most significant related objects, based on the documented foreign key and the EBS localization model, are:

• FV_LEGAL_ENTITIES – The parent legal entity definition, joined on LEGAL_ENTITY_ID. This is the sole documented foreign key relationship.
• JE_FR_DAS2_* detail tables – Companion DAS2 tables storing beneficiary and payment detail lines that consume the header context established here.
• AP_LEGAL_ENTITIES / legal entity setup views – Source of legal entity attributes such as registration numbers and tax identifiers.
• GL_SETS_OF_BOOKS – Provides the accounting context referenced by SET_OF_BOOKS_ID.
• HR_LOCATIONS_ALL and related address sources – Provide the postal, commune, and INSEE address attributes replicated into this table.
• FND_TERRITORIES – Validates country and territory codes for the address blocks.