Search Results use_workflow_flag

Overview

The IGI_ITR_CHARGE_SETUP_SS_V view is a public-sector financials setup view owned by the APPS schema in Oracle E-Business Suite (validated for 12.1.1 and 12.2.2). It belongs to the IGI — Public Sector Financials International product family, which delivers functionality for government and public-sector organizations, including interagency (trading partner) charge processing and internal transaction reconciliation. The "SS" suffix denotes a single-segment (SS) presentation variant of the underlying charge setup definition.

The view exposes the configuration parameters stored in the interagency transaction reconciliation (ITR) charge setup table, presenting each setup record keyed by set of books. It is intended for reporting, inquiry, and integration use — allowing implementation consultants, support analysts, and custom concurrent programs to read charge setup behavior without directly accessing the base table. Because it is a view, it provides a stable, read-only interface for extracting setup metadata used by downstream charge, encumbrance, approval, and workflow logic.

Underlying Base Objects

The view is defined over a single synonym-referenced base object:

• IGI_ITR_CHARGE_SETUP — the base table holding one row per set of books, storing the charge/reconciliation processing options.

The view logic is a simple projection: it selects SETUP.ROWID as ROW_ID and passes through designated setup columns with no joins, filters, or aggregations. Consequently, IGI_ITR_CHARGE_SETUP_SS_V is a one-to-one, row-preserving representation of the base table — one setup row per set of books. This simplicity is deliberate: the view functions as a decoupling layer, so dependent forms, reports, and interfaces can reference a fixed object name while the physical table remains shielded from direct consumer access.

Key Columns

• ROW_ID — the underlying row identifier (ROWID), useful for uniquely addressing a setup record.
• SET_OF_BOOKS_ID — identifies the ledger/set of books the setup applies to; the primary contextual key.
• USE_ENCUMBRANCE_FLAG and ENCUMBRANCE_TYPE_ID — control whether encumbrance accounting is engaged and which encumbrance type is used. (Note the documented column alias preserves the internal spelling ENCUMRANCE_TYPE_ID.)
• ORIGINATOR_APPROVE_FLAG — determines whether the originator may also act as approver.
• SEGMENT_NAME and SEGMENT_PROMPT — define the key flexfield segment used for charge classification and its display prompt.
• FIND_APPROVER_METHOD — specifies the strategy used to resolve the approver.
• USE_WORKFLOW_FLAG — indicates whether Oracle Workflow drives the approval process.
• USE_DOUBLE_TIMEOUT_FLAG — governs whether the dual (two-stage) timeout escalation behavior is enabled for approval routing.
• AUTO_APPROVE_EXCEED_DAYS — the aging threshold (in days) after which pending items are auto-approved.
• Audit columns — CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN, LAST_UPDATE_DATE, LAST_UPDATED_BY.

Common Use Cases and Queries

This view is typically queried to audit or verify charge setup per ledger, and to drive reporting or comparisons across sets of books. A representative query isolating the double-timeout option is:

• SELECT SET_OF_BOOKS_ID, USE_DOUBLE_TIMEOUT_FLAG, USE_WORKFLOW_FLAG, AUTO_APPROVE_EXCEED_DAYS FROM IGI_ITR_CHARGE_SETUP_SS_V WHERE USE_DOUBLE_TIMEOUT_FLAG = 'Y';
• SELECT SET_OF_BOOKS_ID, USE_ENCUMBRANCE_FLAG, ENCUMRANCE_TYPE_ID, FIND_APPROVER_METHOD FROM IGI_ITR_CHARGE_SETUP_SS_V ORDER BY SET_OF_BOOKS_ID;
• SELECT v.SET_OF_BOOKS_ID, v.SEGMENT_NAME, v.SEGMENT_PROMPT FROM IGI_ITR_CHARGE_SETUP_SS_V v WHERE v.AUTO_APPROVE_EXCEED_DAYS IS NOT NULL;

These queries support configuration reviews, migration validation between environments, and troubleshooting approval/encumbrance behavior in public-sector deployments.