Results for “igi_recoverable_lines”

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

Overview

IGI_RECOVERABLE_LINES is a MultiOrg view owned by the APPS schema in Oracle E-Business Suite, delivered as part of the IGI – Public Sector Financials International product. It presents recoverable tax and item distribution line information associated with payables invoices processed through the IGI recoverable tax functionality. The view exposes recoverable amounts along with the corresponding Chart of Accounts combinations (CCIDs) for both the tax and item components of an invoice line, enabling reporting and integration consumers to reconcile recoverable tax amounts against their accounting distributions.

As a MultiOrg (business group / operating unit secured) view, IGI_RECOVERABLE_LINES applies an ORG_ID filter based on the session's CLIENT_INFO context, ensuring that queries executed within an operating unit session return only rows belonging to that organization. Its role in EBS reporting and integration is to provide a secured, denormalized projection over the recoverable lines entity, allowing concurrent programs, reports, and interfaces to retrieve recoverable tax and item data without directly accessing the underlying transaction table.

Underlying Base Objects

The view is defined over a single documented base object: the synonym IGI_RECOVERABLE_LINES_ALL. The definition selects a fixed list of columns from IGI_RECOVERABLE_LINES_ALL and applies the MultiOrg security predicate:

• INVOICE_ID — the invoice identifier linking the line to the payables invoice.
• ACCOUNTING_DATE and INVOICE_DATE — the accounting and invoice dates used for period and aging analysis.
• INV_CURRENCY_CODE — the invoice currency in which amounts are expressed.
• ACCRUAL_SET_OF_BOOKS_ID — the set of books (ledger) identifier for the accrual accounting context.
• REQUEST_ID — the concurrent request that generated the recoverable line records.
• TAX_DISTRIBUTION_ID and TAX_CCID — the tax distribution identifier and the accounting flexfield combination for the recoverable tax amount.
• TAX_AMOUNT — the recoverable tax amount for the line.
• ITEM_DISTRIBUTION_ID and ITEM_CCID — the item distribution identifier and its accounting flexfield combination.
• ORG_ID — the operating unit identifier used by the MultiOrg security predicate.
• JE_CREATED_FLAG — indicates whether the corresponding journal entry has been created.
• Audit columns — LAST_UPDATED_BY, LAST_UPDATE_DATE, CREATED_BY, CREATED_DATE, LAST_UPDATE_LOGIN.

Key Columns

The column most relevant to the searched term tax_ccid is TAX_CCID. TAX_CCID holds the accounting flexfield combination identifier for the recoverable tax distribution, corresponding to the tax portion of the recoverable amount. It pairs with TAX_DISTRIBUTION_ID, which identifies the tax distribution record, and with TAX_AMOUNT, which holds the recoverable tax value. Together these columns allow a report to join recoverable tax amounts to the general ledger Chart of Accounts via the CCID.

The corresponding ITEM_CCID and ITEM_DISTRIBUTION_ID expose the item-side accounting combination and distribution. JE_CREATED_FLAG indicates whether journal entries have already been generated for the line, which is important for controlling duplicate accounting. ORG_ID supports operating unit level filtering and reporting.

Common Use Cases and Queries

Typical scenarios include reconciling recoverable tax amounts to their accounting combinations, identifying lines whose journal entries have not yet been created, and reporting recoverable tax by operating unit or currency. A representative query filtering on the tax CCID is:

• SELECT INVOICE_ID, ACCOUNTING_DATE, TAX_CCID, TAX_AMOUNT, ITEM_CCID, JE_CREATED_FLAG FROM APPS.IGI_RECOVERABLE_LINES WHERE TAX_CCID = :tax_ccid;
• SELECT INVOICE_ID, TAX_AMOUNT FROM APPS.IGI_RECOVERABLE_LINES WHERE ORG_ID = :org_id AND JE_CREATED_FLAG = 'N';

Because the view enforces MultiOrg security derived from the CLIENT_INFO session context, consumers must initialize the operating unit context before querying; otherwise results are constrained to the -99 default organization value encoded in the view predicate.