Results for “last_reported_period”

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

Overview

The JG.JG_ZZ_VAT_REP_ENTITIES table is a configuration repository within the Oracle E-Business Suite JG – Regional Localizations product family. It stores the setup information that defines which legal entities participate in Value Added Tax (VAT) reporting and how each entity is parameterized for reporting, register generation, allocation, and annual allocation processing. The table is central to the European and international localizations that require country-specific VAT reporting, as it links a reporting entity to its underlying party, ledger, and legal entity context.

Its role in Oracle EBS is that of a controlling setup table: downstream VAT registers, allocation rules, reporting status records, and Italy-specific reporting setup tables all carry a foreign key back to VAT_REPORTING_ENTITY_ID, which means no VAT reporting activity can be configured without a corresponding row in this table. In Data Vault terms, the FK topology is hub-leaning: the primary key VAT_REPORTING_ENTITY_ID functions as a durable business key for a reporting entity, and the table is referenced by multiple dependent tables rather than being a pure transactional satellite.

Key Information Stored

The table documents 24 columns. The most significant include:

• VAT_REPORTING_ENTITY_ID – Surrogate primary key, enforced by JG_ZZ_VAT_REP_ENTITIES_PK and also by the unique index JG_ZZ_VAT_REP_ENTITIES_U1. This is the business-key candidate propagated to all child tables.
• LEGAL_ENTITY_ID – References FV_LEGAL_ENTITIES, identifying the legal entity that owns the reporting obligation.
• PARTY_ID – References HZ_PARTIES, tying the reporting entity to the Trading Community Architecture party record.
• LEDGER_ID – References GL_LEDGERS, identifying the ledger from which VAT transactions are drawn.
• TAX_REGIME_CODE and TAX_REGISTRATION_NUMBER – Identify the applicable tax regime and the registered VAT number.
• TAX_CALENDAR_NAME – The reporting calendar used to determine reporting periods.
• ENABLE_REGISTERS_FLAG, ENABLE_REPORT_SEQUENCE_FLAG, ENABLE_ALLOCATIONS_FLAG, ENABLE_ANNUAL_ALLOCATION_FLAG – Feature switches governing which VAT reporting functions are active for the entity.
• ENTITY_LEVEL_CODE, ENTITY_TYPE_CODE, ENTITY_IDENTIFIER – Classify the reporting entity for localization processing.
• BALANCING_SEGMENT_VALUE – Used to derive balancing segment context for reporting.
• DRIVING_DATE_CODE, LAST_REPORTED_PERIOD – Control period determination and track reporting progress.
• MAPPING_VAT_REP_ENTITY_ID – Supports mapping between reporting entities.

Common Use Cases and Queries

Typical uses include identifying active VAT reporting entities for a ledger, validating feature flags before running registers or allocations, and joining setup with party and ledger master data for reporting.

• List reporting entities for a given ledger with their party and VAT registration details.
• Find entities where registers, allocations, or annual allocations are enabled before running localization processes.
• Check the last reported period for each entity to determine processing readiness.
• Join to JG_ZZ_VAT_REGISTERS_B, JG_ZZ_VAT_ALLOC_RULES, and JG_ZZ_VAT_REP_STATUS to trace configuration to generated output and status.

Example pattern:

SELECT r.VAT_REPORTING_ENTITY_ID, r.TAX_REGISTRATION_NUMBER,
       p.PARTY_NAME, l.LEDGER_NAME
FROM   JG_ZZ_VAT_REP_ENTITIES r,
       HZ_PARTIES p, GL_LEDGERS l
WHERE  r.PARTY_ID = p.PARTY_ID
AND    r.LEDGER_ID = l.LEDGER_ID
AND    r.LAST_REPORTED_PERIOD = :period;

Related Objects

• HZ_PARTIES – joined on JG_ZZ_VAT_REP_ENTITIES.PARTY_ID = HZ_PARTIES.PARTY_ID.
• GL_LEDGERS – joined on LEDGER_ID.
• FV_LEGAL_ENTITIES – joined on LEGAL_ENTITY_ID for legal entity attributes.
• JG_ZZ_VAT_REGISTERS_B – child table via VAT_REPORTING_ENTITY_ID.
• JG_ZZ_VAT_ALLOC_RULES – child table via VAT_REPORTING_ENTITY_ID.
• JG_ZZ_VAT_REP_STATUS – child table tracking reporting status.
• JE_IT_SETUP_HDR_ALL and JE_IT_SETUP_LINES_ALL – Italy localization setup tables referencing the entity.
• JE_IT_LIST_HDR_ALL, JE_IT_LIST_LINES_ALL, JE_IT_LIST_PARTIES_ALL – Italy list configuration tables referencing the entity.