Search Results igi_ar_system_options_v




Overview
Explore in AI Chat

Overview

The IGI_AR_SYSTEM_OPTIONS_V view is an APPS-owned database view within the IGI – Public Sector Financials International product. It is classified as VALID and is defined as the view for the system options form based on the IGI_AR_SYSTEM_OPTIONS view. In the Oracle EBS 12.1.1 and 12.2.2 environments, this view functions primarily as a presentation and validation layer, supplying the Oracle Forms-based user interface with the set of Receivables system options configured at the set-of-books level, enriched with descriptive names from related setup entities.

Its role in reporting and integration is to expose a denormalized, read-only projection of core Receivables options — accounting method, cash basis configuration, dunning transaction assignment, and auto-GL import flags — alongside human-readable names. Rather than requiring downstream queries to independently join to AR_RECEIVABLES_TRX and GL_SETS_OF_BOOKS, the view performs those joins internally, simplifying how the system options form and any dependent extracts resolve descriptive values.

Underlying Base Objects

The ETRM metadata documents the referenced base objects as AR_RECEIVABLES_TRX_ALL (accessed via SYNONYM) and IGI_AR_SYSTEM_OPTIONS (accessed via SYNONYM). The view text confirms this relationship directly. It joins:

  • IGI_AR_SYSTEM_OPTIONS IASO — the primary source of system-option attributes, driving the driving row per set of books.
  • AR_RECEIVABLES_TRX ART — joined through the DUNNING_RECEIVABLES_TRX_ID using a DECODE-based outer-join surrogate (-1) so that null dunning assignments are preserved.
  • GL_SETS_OF_BOOKS GSOB — joined on SET_OF_BOOKS_ID, supplying the chart of accounts identifier.
  • GL_SETS_OF_BOOKS GSOB2 — a second alias joined on NVL(ARC_CASH_SOB_ID, SET_OF_BOOKS_ID), supplying the cash set-of-books name.

A DISTINCT clause collapses any duplicate join combinations.

Key Columns

  • SET_OF_BOOKS_ID — identifies the accounting set of books the options apply to.
  • ACCOUNTING_METHOD — the Receivables accounting method (accrual or cash).
  • ARC_CASH_SOB_ID / ARC_CASH_SOB_NAME — the cash basis set of books identifier and its decoded name, derived via the DECODE on GSOB2.NAME.
  • CHART_OF_ACCOUNTS_ID — chart of accounts from the primary set of books.
  • ARC_UNALLOC_REV_CCID — the code combination for unallocated revenue.
  • RPI_* columns — context codes, charge identifiers, sequence values, line and price-break numbers supporting receivable policy/interest (RPI) processing.
  • ARC_AUTO_GL_IMPORT_FLAG — flag governing automatic General Ledger import.
  • DUNNING_RECEIVABLES_TRX_ID / DUNNING_RECEIVABLES_TRX_NAME — the dunning transaction identifier and its decoded name from AR_RECEIVABLES_TRX.
  • ARC_JE_SOURCE_NAME, ORG_ID — journal entry source name and operating unit identifier.
  • ROWID — the physical row identifier.

Common Use Cases and Queries

Typical usage includes retrieving dunning transaction setup per operating unit, auditing accounting method configuration, and powering the IGI system options form. A representative query:

SELECT set_of_books_id,
       accounting_method,
       arc_cash_sob_name,
       dunning_receivables_trx_name
FROM   apps.igi_ar_system_options_v
WHERE  org_id = :p_org_id;

Because the dunning assignment is preserved through a null-safe decode, records with no dunning transaction return a null name without dropping the set-of-books row. Analysts commonly filter on ARC_AUTO_GL_IMPORT_FLAG to audit automation of GL import, and join the view back to AR_RECEIVABLES_TRX_ALL when transaction-level detail is required beyond the resolved name.