Results for “item_distribution_id”

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

Overview

IGI_RECOVERABLE_LINES_ALL is a table owned by the IGI schema (Public Sector Financials International) within Oracle E-Business Suite 12.1.1 and 12.2.2. Its documented purpose is to store additional recoverable information for cash basis transaction information used by the Gross Based VAT functionality. In practice, the table supports the determination and tracking of VAT amounts that a public sector or international organization can reclaim against invoices processed in Oracle Payables, particularly where cash basis accounting and Gross Based VAT rules apply.

The table is closely tied to the Payables invoice and tax distribution model. Each row links an invoice, a tax distribution, and an associated item distribution, providing the accounting context (codes combinations, accounting dates, and amounts) required to recognize and reclaim recoverable tax. From a Data Vault modeling perspective, the metadata classifies this object heuristically as standalone, suggesting it is best interpreted as a satellite-style descriptive entity — one that hangs off a business key (such as the invoice/tax distribution combination) rather than acting as a hub or link in its own right.

Key Information Stored

The table contains 18 documented columns. The most significant are summarized below.

• TAX_DISTRIBUTION_ID — A key foreign key referencing JAI_AP_MATCH_INV_TAXES; identifies the tax distribution line to which the recoverable information pertains.
• INVOICE_ID — The Payables invoice associated with the recoverable line.
• ITEM_DISTRIBUTION_ID — The Payables item distribution line tied to the recoverable tax calculation.
• TAX_CCID and ITEM_CCID — The accounting flexfield code combinations for the tax and item distribution lines, respectively, driving the recoverable accounting entries.
• TAX_AMOUNT — The recoverable tax amount recorded for the line.
• ACCOUNTING_DATE and INVOICE_DATE — The GL accounting date and the invoice date, used for cash basis and period-based reporting.
• INV_CURRENCY_CODE — The invoice currency applicable to the amounts.
• ACCURAL_SET_OF_BOOKS_ID — Identifies the accrual set of books tied to the transaction (note the spelling as documented).
• ORG_ID — The operating unit, enabling multi-org security and reporting.
• JE_CREATED_FLAG — Indicates whether the related journal entry has been generated.
• REQUEST_ID — The concurrent request that created or processed the row.
• Audit columns — CREATED_BY, CREATED_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN provide standard who-column auditing.

No explicit surrogate primary key is documented in the metadata; the business key is effectively the combination of invoice, tax distribution, and item distribution identifiers. No unique index columns are documented beyond the foreign key relationship to JAI_AP_MATCH_INV_TAXES.

Common Use Cases and Queries

Typical scenarios include reconciling recoverable VAT amounts against Payables invoices, auditing cash basis tax recognition, and confirming that journal entries have been generated for recoverable lines.

• Listing recoverable lines for a given invoice or operating unit, filtered by ORG_ID and INVOICE_ID.
• Reporting on lines where JE_CREATED_FLAG is not set, to identify unposted recoverable entries.
• Joining to JAI_AP_MATCH_INV_TAXES on TAX_DISTRIBUTION_ID to resolve underlying tax detail.
• Period-based summaries via ACCOUNTING_DATE and INV_CURRENCY_CODE for VAT reclaim reporting.

A representative query pattern is: select recoverable lines joined to tax lines by TAX_DISTRIBUTION_ID, constrained by ORG_ID and a date range on ACCOUNTING_DATE, selecting INVOICE_ID, TAX_AMOUNT, and JE_CREATED_FLAG.

Related Objects

• JAI_AP_MATCH_INV_TAXES — Referenced via IGI_RECOVERABLE_LINES_ALL.TAX_DISTRIBUTION_ID; the primary foreign key relationship.
• AP_INVOICES_ALL — Joined on INVOICE_ID for invoice header context.
• AP_INVOICE_DISTRIBUTIONS_ALL — Joined on ITEM_DISTRIBUTION_ID for item distribution detail.
• AP_TAX_CODES / JAI_AP_TAXES_ALL — Tax code and calculation context for Gross Based VAT.
• GL_CODE_COMBINATIONS — Resolves TAX_CCID and ITEM_CCID accounting flexfields.
• GL_JE_HEADERS / GL_JE_LINES — Journal entries corresponding to recoverable lines where JE_CREATED_FLAG is set.