Results for “issue_date”

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

Overview

The AP.JE_IT_EXEMPT_LETTERS table stores Italian exemption letter information for suppliers within the Oracle E-Business Suite European Localizations (JE) module. It belongs to the Payables (AP) schema and is marked VALID in the ETRM registry for releases 12.1.1 and 12.2.2. The table captures the declarations that Italian suppliers of goods and services issue to their customers, allowing the customer to apply withholding tax exemptions under Italian fiscal law. Each row represents a supplier exemption letter scoped to a specific set of books, legal entity, and validity window.

Under the heuristic Data Vault classification supplied in the metadata, this object is modeled as a standalone entity — it holds no dependent child tables and does not function as a pure link or satellite. In Data Vault terms it behaves most closely as a satellite-like record of supplier exemption attributes keyed by a composite business key, though no parent hub dependency is documented. The documented physical schema spans 19 columns in the 12.2.2 ETRM extract.

Key Information Stored

The primary key is the constraint JE_IT_EXEMPT_LETTERS_PK, defined on the composite of SET_OF_BOOKS_ID, VENDOR_ID, EFFECTIVE_FROM, and EFFECTIVE_TO. This is the surrogate/technical uniqueness anchor. A separate unique index, JE_IT_EXEMPT_LETTERS_U1, offers a broader business-key candidate over SET_OF_BOOKS_ID, LEGAL_ENTITY_ID, VENDOR_ID, EFFECTIVE_FROM, and EFFECTIVE_TO — the addition of LEGAL_ENTITY_ID distinguishes the legal entity context that the primary key alone omits.

The most operationally significant columns are:

• VENDOR_ID — the supplier to whom the exemption letter applies.
• SET_OF_BOOKS_ID and LEGAL_ENTITY_ID — the accounting and legal entity context, the latter referencing FV_LEGAL_ENTITIES.
• EFFECTIVE_FROM / EFFECTIVE_TO — the date range during which the exemption is valid.
• YEAR — the fiscal year of the declaration.
• EXEMPTION_LETTER_ID — the reference identifier of the letter.
• LETTER_TYPE — the category of exemption letter issued.
• CLAUSE_REF — the legal clause or article cited on the letter.
• LIMIT_AMOUNT — the monetary ceiling up to which the exemption applies.
• ISSUE_DATE — the date the letter was issued.
• ISSUE_FLAG, PRINT_FLAG, CUSTOM_FLAG — status indicators controlling issuance, printing, and customization behavior.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard WHO audit columns.

Common Use Cases and Queries

Typical scenarios include validating that a supplier holds a currently effective exemption before applying withholding logic, and generating exemption letter registries for Italian fiscal reporting.

• Confirming an active exemption for a supplier on a given date:

SELECT vendor_id, effective_from, effective_to, letter_type, limit_amount
FROM   ap.je_it_exempt_letters
WHERE  set_of_books_id = :p_sob
AND    vendor_id       = :p_vendor
AND    TRUNC(SYSDATE) BETWEEN effective_from AND effective_to;

• Listing all exemptions for a legal entity in a fiscal year:

SELECT vendor_id, exemption_letter_id, year, clause_ref, issue_date
FROM   ap.je_it_exempt_letters
WHERE  legal_entity_id = :p_le
AND    year            = :p_year
ORDER  BY vendor_id, effective_from;

• Audit/extract of recently maintained records using WHO audit columns to detect gaps.
• Reconciliation reporting against withholding tax withholding applied during payment.

Related Objects

The documented foreign key declares one parent reference and the key constraints imply supplier and accounting context dependencies:

• FV_LEGAL_ENTITIES — joined on JE_IT_EXEMPT_LETTERS.LEGAL_ENTITY_ID = FV_LEGAL_ENTITIES.LEGAL_ENTITY_ID.
• AP_SUPPLIERS / PO_VENDORS — joined on VENDOR_ID to resolve supplier names and tax identifiers.
• AP_SETS_OF_BOOKS / GL_SETS_OF_BOOKS — joined on SET_OF_BOOKS_ID to resolve the accounting context.
• AP_LEGAL_ENTITIES — alternate legal entity resolutions where the localization stores entity metadata.
• Italian withholding tax and supplier tax registration localization tables consuming EXEMPTION_LETTER_ID downstream.

These relationships support the joins required for exemption validation, reporting, and Italian withholding compliance within the JE localization footprint.