Search Results enable_annual_allocation_flag




Overview
Explore in AI Chat

Overview

The APPS.JG_ZZ_VAT_REP_ENTITIES_V view is a reporting and integration layer exposed by the Oracle E-Business Tax (EBS Tax / ETRM) module in Oracle E-Business Suite 12.1.1 and 12.2.2. It presents configuration data for VAT reporting entities — the legal entities, tax regimes, and registration records for which VAT reporting and periodic reporting obligations are defined within the ETRM architecture. The view surfaces the operational control flags that govern how an entity performs allocations, annual allocations, register maintenance, and report sequencing, together with identifying attributes such as the ledger, balancing segment, and tax calendar. Because it is defined over the base table JG_ZZ_VAT_REP_ENTITIES without complex joins or filters, it behaves as a thin projection of the underlying entity configuration, making it suitable for both ad hoc reporting and downstream integration extracts. The user searching for ENABLE_ANNUAL_ALLOCATION_FLAG will find that column exposed directly by this view.

Underlying Base Objects

According to the ETRM 12.2.2 metadata, the view is owned by APPS and is defined with a single referenced base object: the synonym JG_ZZ_VAT_REP_ENTITIES. Its view text is a straight SELECT of column names and ROWID from that table, with no filtering predicates, no WHERE clause, and no aggregations. Consequently, every row present in the base table is exposed by the view, and the view carries no additional row-level security or derivation logic of its own. Any change to the columns of JG_ZZ_VAT_REP_ENTITIES directly affects the view's shape. From an administration standpoint, the base table resides in the APPS schema (or is granted to it), and the synonym resolves to the ETRM-owned data object.

Key Columns

The view exposes identity, control, and organizational columns:

Common Use Cases and Queries

Typical uses include auditing which entities have annual allocation enabled, verifying reporting configuration against ledger or regime, and extracting data for reconciliation or migration testing. A routine check for the searched flag:

  • SELECT VAT_REPORTING_ENTITY_ID, LEGAL_ENTITY_ID, TAX_REGIME_CODE, ENABLE_ANNUAL_ALLOCATION_FLAG FROM APPS.JG_ZZ_VAT_REP_ENTITIES_V WHERE ENABLE_ANNUAL_ALLOCATION_FLAG = 'Y';

Reporting by ledger and regime:

  • SELECT LEDGER_ID, TAX_REGIME_CODE, COUNT(*) FROM APPS.JG_ZZ_VAT_REP_ENTITIES_V GROUP BY LEDGER_ID, TAX_REGIME_CODE;

Comparing all enable flags for a given entity:

  • SELECT VAT_REPORTING_ENTITY_ID, ENABLE_ALLOCATIONS_FLAG, ENABLE_ANNUAL_ALLOCATION_FLAG, ENABLE_REGISTERS_FLAG, ENABLE_REPORT_SEQUENCE_FLAG FROM APPS.JG_ZZ_VAT_REP_ENTITIES_V WHERE TAX_REGISTRATION_NUMBER = :reg_num;

Because the view is a direct projection with no joins, these queries are efficient and reflect the base configuration table exactly, as documented in the ETRM metadata.