Search Results je_it_setup_lines_all

Overview

The JE_IT_SETUP_LINES_ALL table is a configuration and reference data object within the JE (European Localizations) product family in Oracle E-Business Suite 12.1.1 and 12.2.2. It stores the setup lines that drive the Italian Annual Supplier and Customer Listing report, a statutory reporting obligation under Italian VAT law that requires businesses to disclose annual totals of taxable transactions with suppliers and customers. Each row defines a reporting rule — such as the listing column, tax rate, and declaration year — that the Italian localization processes use to determine which transactions qualify for inclusion and how they are categorized on the annual listing.

From a Data Vault modeling perspective, the metadata classifies this table heuristically as standalone. This suggests treating JE_IT_SETUP_LINES_ALL as a pure setup/reference construct rather than a transactional hub, link, or satellite. It holds the configuration that governs downstream reporting, not the business event data itself. The single foreign key to JG_ZZ_VAT_REP_ENTITIES anchors each setup line to a specific VAT reporting entity, making the table conceptually similar to a link between a reporting entity and a reporting rule dimension.

Key Information Stored

The table contains 13 documented columns, with the most significant including:

• VAT_REPORTING_ENTITY_ID — the foreign key to JG_ZZ_VAT_REP_ENTITIES, identifying the legal entity responsible for the declaration.
• YEAR_OF_DECLARATION — the fiscal year the setup line applies to, enabling year-over-year configuration variation.
• APPLICATION_ID — identifies the EBS application (typically Payables or Receivables) supplying the transactions for the listing.
• TAX_RATE_ID — the tax rate associated with a given listing rule, used to filter transactions by applicable VAT rate.
• LISTING_COLUMN_CODE — the column classification on the Italian listing form into which qualifying amounts are aggregated.
• TAX_ID — the tax registration identifier associated with the reporting entity.
• PERIOD_NAME — the accounting period scope for the setup line.
• ORG_ID — the operating unit associated with the setup line, supporting multi-org environments.
• Audit columns — LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATION_DATE, and CREATED_BY, providing standard who/when tracking.

Uniqueness is enforced by the unique index JE_IT_SETUP_LINES_U1 on the combination (VAT_REPORTING_ENTITY_ID, YEAR_OF_DECLARATION, APPLICATION_ID, TAX_RATE_ID, LISTING_COLUMN_CODE), which acts as the business-key candidate. The table does not expose a documented single-column surrogate primary key in the provided metadata, so the composite unique key effectively governs record identity. Because it is a setup table without significant transactional velocity, the audit columns are still essential for controlled configuration changes.

Common Use Cases and Queries

Typical uses center on verifying or troubleshooting the Italian annual listing configuration for a given entity and year. A common query returns the setup lines for a reporting entity and declaration year:

SELECT VAT_REPORTING_ENTITY_ID, YEAR_OF_DECLARATION,
       APPLICATION_ID, TAX_RATE_ID, LISTING_COLUMN_CODE
FROM   JE.JE_IT_SETUP_LINES_ALL
WHERE  VAT_REPORTING_ENTITY_ID = :entity_id
AND    YEAR_OF_DECLARATION = :year;

Reporting and reconciliation queries join the setup lines to transaction sources to confirm that each tax rate and application combination maps to a valid listing column. Auditors frequently compare configuration across years to identify missed rate mappings or incorrectly scoped periods. A join to the reporting entity table confirms which legal entity a line belongs to:

SELECT s.LISTING_COLUMN_CODE, e.ENTITY_NAME
FROM   JE_IT_SETUP_LINES_ALL s,
       JG_ZZ_VAT_REP_ENTITIES e
WHERE  s.VAT_REPORTING_ENTITY_ID = e.VAT_REPORTING_ENTITY_ID;

Related Objects

• JG_ZZ_VAT_REP_ENTITIES — referenced via VAT_REPORTING_ENTITY_ID; the parent entity definition for each setup line.
• AP / AR transaction tables — APPLICATION_ID points to the source application (Payables, Receivables) supplying listing amounts.
• Tax rate definitions (e.g., ZX_RATES) — TAX_RATE_ID links to the tax rate used for filtering.
• Period definitions (GL_PERIODS) — PERIOD_NAME aligns setup scoping with the accounting calendar.
• Operating unit entities — ORG_ID ties lines to a specific operating unit.

Together these objects form the configuration spine behind the Italian Annual Supplier and Customer Listing report in Oracle EBS.