Search Results auto_na_complete




Overview
Explore in AI Chat

Overview

APPS.IGF_AP_GEN_SETUP_V is a reporting and integration view in Oracle E-Business Suite that exposes the general setup parameters governing the Oracle Grants / Federal (IGF) accounts payable processing behavior. The view is defined in the APPS schema and is referenced by ETRM documentation under both the 12.1.1 and 12.2.2 releases. Its principal role is to present a single, stable projection of the generic setup record so that concurrent programs, forms, and external integrations can read institutional-level configuration flags without directly binding to the base transactional table. The view is keyed by the setup identifier and the operating unit, and it surfaces control flags such as whether a Social Security Number is required and whether the system permits automatic non-allowable completion. The column naming AUTO_NA_COMPLETE reflects the auto non-allowable completion indicator, which is the element most frequently searched when administrators are troubleshooting grants-related payables setup.

Underlying Base Objects

The view is defined over a single foundation table:

  • IGF_AP_GEN_SETUP — the base configuration table holding the general setup row for the grants payables process.

The view text selects from this table using a straightforward projection with no joins, aggregations, or filtering predicates. It does not expose three placeholder positions; instead it emits three NULL literals in fixed column positions to preserve a column contract expected by the consuming forms and reports. This design pattern is common where a view must remain structurally compatible with prior definitions while the physical table evolves. Because no additional base objects are documented, the view's cardinality equals that of the underlying setup table, and any change to a setup record is immediately visible through the view without refresh or materialization.

Key Columns

  • ROW_ID — the ROWID of the underlying setup row, providing a unique physical locator for the record.
  • GENST_ID — the primary setup identifier for the general setup record.
  • ORG_ID — the operating unit to which the setup applies, supporting multi-organization access control.
  • SSN_REQUIRED — indicates whether a Social Security Number is mandatory for the associated payables/grantee processing.
  • AUTO_NA_COMPLETE — the auto non-allowable completion flag; governs whether non-allowable cost processing completes automatically.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard audit columns recording who created and last modified the setup record.

Common Use Cases and Queries

The view is typically queried during implementation validation, grants payables configuration review, and diagnostic investigation of automatic non-allowable completion behavior. A representative query retrieves the setup flags for a given operating unit:

  • SELECT org_id, ssn_required, auto_na_complete FROM apps.igf_ap_gen_setup_v WHERE org_id = :p_org_id;
  • SELECT genst_id, org_id, auto_na_complete, last_updated_by, last_update_date FROM apps.igf_ap_gen_setup_v WHERE auto_na_complete = 'Y';
  • SELECT COUNT(*) FROM apps.igf_ap_gen_setup_v; — to confirm exactly one setup record exists per operating unit.

Integrations and reconciliation scripts use these queries to confirm that non-allowable completion is configured consistently across operating units and to audit when the flag was last changed and by whom.