Search Results jg_zz_vat_final_reports




Overview
Explore in AI Chat

Overview

The JG.JG_ZZ_VAT_FINAL_REPORTS table is a Regional Localizations (JG) data object within Oracle E-Business Suite, validated across 12.1.1 and 12.2.2. It records the details of final print generation for VAT reports, organized by legal entity and accounting period. In practical terms, each row represents a completed publication event of a VAT/statutory report — capturing which report was generated, which concurrent request produced it, and which VAT register and reporting status it belongs to. This makes the table a representation of report lifecycle state rather than transaction-level VAT data.

Under the heuristic Data Vault classification mined from the foreign-key structure, this object is satellite-leaning. That is, it behaves as a descriptive satellite attached to a stronger hub or link via its reporting-status and VAT-register relationships, carrying contextual attributes (program, request, sequence numbers, audit columns) rather than acting as a central business key. This classification should be treated as a modeling suggestion, not an authoritative assertion.

Key Information Stored

The table is defined with 16 columns and is owned by the JG schema. The surrogate primary key is FINAL_REPORT_ID, enforced by JG_ZZ_VAT_FINAL_REPORTS_PK and reinforced by the unique index JG_ZZ_VAT_FINAL_REPORTS_U1. A second unique index, JG_ZZ_VAT_FINAL_REPORTS_U2, spans REPORTING_STATUS_ID, REPORT_NAME, and VAT_REGISTER_ID, and therefore serves as the principal business-key candidate — it asserts that a given report name, within a given VAT register and reporting status, is uniquely identified.

Common Use Cases and Queries

Typical scenarios include verifying that a final VAT report was produced for a given entity and period, tracing a report back to its concurrent request, and identifying the sequence range covered by the last print run.

  • Retrieve the latest final report for a register: 
    SELECT r.FINAL_REPORT_ID, r.REPORT_NAME, r.VAT_REGISTER_ID,
       r.START_SEQUENCE_NUM, r.LAST_START_SEQUENCE_NUM, r.CREATION_DATE
FROM   JG.JG_ZZ_VAT_FINAL_REPORTS r
WHERE  r.VAT_REGISTER_ID = :register_id
ORDER  BY r.CREATION_DATE DESC;
  • Join to reporting status for a human-readable state: 
    SELECT f.REPORT_NAME, s.STATUS_CODE, f.CREATION_DATE
FROM   JG.JG_ZZ_VAT_FINAL_REPORTS f,
       JG.JG_ZZ_VAT_REP_STATUS s
WHERE  f.REPORTING_STATUS_ID = s.REPORTING_STATUS_ID;
  • Audit report generation by concurrent request and program.
  • Reconciliation reporting to confirm that final prints exist for every period within a reporting cycle.

Related Objects

  • JG.JG_ZZ_VAT_REP_STATUS — referenced through REPORTING_STATUS_ID; the primary FK target supplying reporting status context.
  • JG_ZZ_VAT_FINAL_REPORTS_PK — primary key constraint on FINAL_REPORT_ID.
  • JG_ZZ_VAT_FINAL_REPORTS_U1 and JG_ZZ_VAT_FINAL_REPORTS_U2 — unique indexes enforcing surrogate and business-key uniqueness respectively.
  • Concurrent program and request entities (referenced by REQUEST_ID, PROGRAM_ID, PROGRAM_APPLICATION_ID) — used to trace report generation.
  • VAT register definitions (referenced by VAT_REGISTER_ID) — the entity/period context for each final report.