Search Results jg_zz_vat_rep_entities




Overview
Explore in AI Chat

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:

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.