Search Results je_it_setup_hdr_all

Overview

The JE_IT_SETUP_HDR_ALL table is a setup and configuration object within the JE – European Localizations product module of Oracle E-Business Suite. It stores header-level setup data required for the Italian Annual Supplier and Customer Listing (the "Elenco Clienti e Fornitori"), a statutory reporting obligation administered by the Italian tax authority. Each row in this table defines the parameters under which the annual listing is generated for a given VAT reporting entity and a given declaration year, including the reporting period, operating unit context, freeze status, and certain monetary thresholds applied during report extraction.

In Oracle EBS 12.1.1 and 12.2.2, this table resides in the JE schema and is classified as VALID in the ETRM data dictionary, with eleven documented columns. The table appears as a standard transactional setup container rather than a high-volume fact table; its cardinality is expected to be low, with one configuration row per reporting entity per declaration year. Heuristic Data Vault classification mined from the foreign-key structure suggests this object behaves as a standalone construct, meaning it does not act as a link table between two or more business hubs. In a Data Vault model it would most naturally be modeled as a satellite attached to the VAT reporting entity hub, since its descriptive attributes qualify a single referenced entity.

Key Information Stored

The table's business-key candidate is defined by the unique index JE_IT_SETUP_HDR_U1, which spans VAT_REPORTING_ENTITY_ID and YEAR_OF_DECLARATION. This composite uniquely identifies one setup record per reporting entity per declaration year and should be treated as the logical key for integration and reconciliation purposes.

• VAT_REPORTING_ENTITY_ID – Foreign key to JG_ZZ_VAT_REP_ENTITIES; identifies the legal entity or reporting unit to which the annual listing setup applies.
• YEAR_OF_DECLARATION – The fiscal year for which the Italian annual listing is being configured or generated.
• PERIOD_NAME – The accounting period associated with the setup record, typically the period from which listings are extracted.
• ORG_ID – Operating unit identifier, enforcing multi-org security and partitioning the setup data by organization.
• FREEZE_INDICATOR_FLAG – Indicates whether the listing setup or the generated data is frozen against further modification.
• EFT_PARTY_LIMIT_NUM – A numeric limit applied to electronic fund transfer parties, used to filter which customers or suppliers are included in the annual listing.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN – Standard EBS audit columns capturing who last modified the row and when.
• CREATION_DATE, CREATED_BY – Standard audit columns recording initial row creation.

Common Use Cases and Queries

The primary use case is configuration validation and reporting control. Because the table governs whether an annual listing can be generated or regenerated for a given entity and year, the most frequent query pattern checks the setup status before extraction:

SELECT vat_reporting_entity_id, year_of_declaration, period_name,
       freeze_indicator_flag, eft_party_limit_num
FROM   je.je_it_setup_hdr_all
WHERE  org_id = :p_org_id
AND    year_of_declaration = :p_year;

Reporting scenarios include auditing which entities have completed their annual listing setup, verifying freeze status before period close, and confirming that no setup row exists for a year still open for modification. Integration or data-migration teams frequently join this table to JG_ZZ_VAT_REP_ENTITIES to resolve the entity name for output reports. Another common pattern compares setup rows across consecutive years to detect entities that have been omitted from the current declaration cycle.

Related Objects

• JG_ZZ_VAT_REP_ENTITIES – Referenced by the foreign key JE_IT_SETUP_HDR_ALL.VAT_REPORTING_ENTITY_ID; supplies the reporting entity definition and is the principal join for descriptive reporting.
• JE_IT_SETUP_LINES_ALL – The natural child table holding line-level Italian annual listing setup detail, joined by entity and declaration year.
• JE_IT_ANNUAL_LISTINGS – The generated listing output or staging structure that consumes the setup header parameters.
• JG_ZZ_VAT_REP_ENTITIES_VL / _TL – Entity views used for lookup and multi-language description resolution.
• FND_ORG_ACCESS / HR_OPERATING_UNITS – Join targets for resolving ORG_ID into an operating unit name.
• FND_USER – Used to resolve created_by and last_updated_by identifiers for audit reporting.