Search Results je_it_setup_hdr_u1

Overview

JE.JE_IT_SETUP_HDR_ALL is a transactional setup table in the Oracle E-Business Suite Financials schema JE (the Subledger Accounting / European Localizations component). It stores header-level setup information for Italian VAT (IVA) reporting entities, specifically the parameters that govern period freezing and declaration-year configuration for a given VAT reporting entity. Each row represents the setup state of a reporting entity for a specific period and declaration year. The table resides in the APPS_TS_TX_DATA tablespace with a PCT Free of 10, consistent with transactional data objects.

In heuristic Data Vault terms, this table classifies as a satellite: it holds descriptive, non-key attributes (setup flags, limits, audit columns) that describe the state of a business entity keyed by the combination of VAT reporting entity and declaration year. It is not a hub (no single surrogate key is documented) nor a link (no many-to-many association is modeled within this table). The classification is a modeling suggestion only; it reflects the dependency structure mined from the FK relationships.

Key Information Stored

The table contains 11 documented columns. The most significant are:

• VAT_REPORTING_ENTITY_ID — Numeric identifier of the Italian VAT reporting entity; part of the unique business key and a foreign key to JG_ZZ_VAT_REP_ENTITIES.
• YEAR_OF_DECLARATION — The declaration year to which the setup applies; the second component of the unique business key.
• PERIOD_NAME — Accounting period name (VARCHAR2 15) associated with the setup record.
• ORG_ID — Operating unit / organization identifier supporting multi-org data partitioning.
• FREEZE_INDICATOR_FLAG — Flag indicating whether the period or declaration is frozen from further amendment.
• EFT_PARTY_LIMIT_NUM — Numeric limit value related to EFT party transactions.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATION_DATE, CREATED_BY — Standard EBS audit columns recording who created and last modified the row and when.

No single surrogate primary key column is documented. The business-key candidate is captured by the unique index JE_IT_SETUP_HDR_U1, defined on (VAT_REPORTING_ENTITY_ID, YEAR_OF_DECLARATION) in the APPS_TS_TX_IDX tablespace. Note that the table is named with the _ALL suffix, which in EBS typically indicates a multi-org table whose queries are filtered by ORG_ID through a corresponding _ALL synonym and org-id secured view.

Common Use Cases and Queries

Typical use cases include: determining whether a VAT declaration period is frozen before allowing adjustments, reporting setup state by reporting entity and year, and validating the EFT party limit applied to a given entity. A representative query follows:

• SELECT s.VAT_REPORTING_ENTITY_ID, s.YEAR_OF_DECLARATION, s.PERIOD_NAME, s.FREEZE_INDICATOR_FLAG, s.EFT_PARTY_LIMIT_NUM FROM JE.JE_IT_SETUP_HDR_ALL s WHERE s.ORG_ID = :org AND s.YEAR_OF_DECLARATION = :year;
• Joining to validate the reporting entity name: SELECT r.ENTITY_NAME, s.* FROM JE.JE_IT_SETUP_HDR_ALL s, JG_ZZ_VAT_REP_ENTITIES r WHERE s.VAT_REPORTING_ENTITY_ID = r.VAT_REPORTING_ENTITY_ID;
• Frozen-period exception report: SELECT VAT_REPORTING_ENTITY_ID, PERIOD_NAME FROM JE.JE_IT_SETUP_HDR_ALL WHERE FREEZE_INDICATOR_FLAG = 'Y';

Because the table only reads and does not reference other database objects directly, reporting joins must resolve the entity name via JG_ZZ_VAT_REP_ENTITIES.

Related Objects

The most significant related objects are:

• JG_ZZ_VAT_REP_ENTITIES — Master VAT reporting entity table; joined on VAT_REPORTING_ENTITY_ID.
• JE_IT_SETUP_HDR_ALL# — The internal dependent object of JE_IT_SETUP_HDR_ALL; the documentation notes JE_IT_SETUP_HDR_ALL is referenced by this object, reflecting the underlying base/editioning structure.
• JE_IT_SETUP_HDR_U1 — The unique index enforcing the (VAT_REPORTING_ENTITY_ID, YEAR_OF_DECLARATION) business key.
• Italian localization (JG) reporting views and the Subledger Accounting (JE) setup APIs that validate freeze flags and period membership before posting VAT declarations.

No foreign keys are documented as originating from this table other than the reference to JG_ZZ_VAT_REP_ENTITIES; the object is otherwise standalone, as reflected in its heuristic classification.