Results for “je_it_year_ex_limit”

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

Overview

The JE_IT_YEAR_EX_LIMIT table is a Payables-owned configuration and reference table within the JE – European Localizations product family in Oracle E-Business Suite 12.1.1 and 12.2.2. It is registered in the AP schema and carries VALID status. Its purpose is to store the yearly exemption limits applicable under Italian Payables exemption legislation, together with the monthly adjustments applied to those limits. The table is populated and maintained by the Italian Payables Exemption Limit Manager concurrent program. When a new year is entered through that program, twelve records are generated, one for each month of the year, giving the table a predictable annual cardinality per set of books and legal entity.

From a Data Vault modeling perspective, the metadata classifies this object as standalone, based on a heuristic examination of its foreign key structure. In that modeling idiom, JE_IT_YEAR_EX_LIMIT is best treated as a satellite-style reference table attached to the legal entity and set of books hubs, since it records descriptive, time-versioned limit amounts rather than transactional events. The annual regeneration pattern means the table behaves as a slowly changing reference set keyed to a calendar year.

Key Information Stored

The table contains twelve documented columns. The most significant are listed below.

• SET_OF_BOOKS_ID – Identifies the accounting set of books (ledger) to which the exemption limit applies. This column participates in the primary key.
• YEAR – The calendar year for which the exemption limit is defined. This column participates in the primary key.
• MONTH – The month within the year. Twelve rows are created per year, so this column completes the composite primary key.
• ORIGINAL_LIMIT_AMOUNT – The base yearly exemption limit before any adjustments are applied.
• ADJUSTMENT_AMOUNT – The monthly adjustment value applied against the original limit.
• ADJUSTED_LIMIT_AMOUNT – The resulting limit after the adjustment is factored in; typically ORIGINAL_LIMIT_AMOUNT plus or minus ADJUSTMENT_AMOUNT depending on the business rule in force.
• LEGAL_ENTITY_ID – The legal entity associated with the limit; this is the sole documented foreign key, referencing FV_LEGAL_ENTITIES.
• CREATED_BY, CREATION_DATE – Standard Oracle EBS audit columns recording row creation.
• LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN – Standard audit columns capturing the most recent modification and the login session responsible for it.

The primary key is JE_IT_YEAR_EX_LIMIT_PK, defined over (SET_OF_BOOKS_ID, YEAR, MONTH). These three columns are therefore the surrogate/business-key candidates that guarantee uniqueness. The combination of SET_OF_BOOKS_ID, YEAR, MONTH, and LEGAL_ENTITY_ID forms the practical business identifier for reporting purposes.

Common Use Cases and Queries

The primary use case is reporting on exemption limit consumption against Italian Payables transactions. A typical query retrieves the adjusted limit for a given legal entity and period:

• SELECT set_of_books_id, year, month, legal_entity_id, original_limit_amount, adjustment_amount, adjusted_limit_amount FROM ap.je_it_year_ex_limit WHERE set_of_books_id = :p_sob AND year = :p_year AND legal_entity_id = :p_entity ORDER BY month;

Analysts frequently sum the monthly adjustments to reconcile the annual adjusted limit against statutory thresholds, and they join the table to legal entity definitions to resolve entity names for presentation. Auditors use it to verify that the twelve monthly rows exist for each active year and that adjustment amounts tie back to the Exemption Limit Manager run log.

Related Objects

• FV_LEGAL_ENTITIES – Referenced by JE_IT_YEAR_EX_LIMIT.LEGAL_ENTITY_ID; supplies legal entity attributes.
• AP_LEGAL_ENTITIES and related AP legal entity views – provide the Payables-side view of the same entities.
• GL_SETS_OF_BOOKS / GL_LEDGERS – Supplies the definition of SET_OF_BOOKS_ID used in the primary key.
• Italian Payables Exemption Limit Manager concurrent program – The program that populates the table each year.
• AP_INVOICES_ALL / AP_INVOICE_LINES_ALL – Transaction tables whose exemption treatment is validated against the limits recorded here.
• FND_CONCURRENT_REQUESTS – Tracks the concurrent program runs that generated or refreshed the yearly rows.