Results for “igs_da_access_level”

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

Overview

APPS.IGS_DA_CNFG_V is a reporting and integration view in the Oracle E-Business Suite "IGS" (Intelligent Grants / Sponsored Programs) product family. It exposes configuration data governing "DA" (deferred/dynamic access or document access) request handling at the responsibility level. Specifically, the view joins the base configuration table IGS_DA_CNFG to two reference sources — FND_RESPONSIBILITY_VL and IGS_LOOKUP_VALUES — to simultaneously surface the stored configuration values and their human-readable meanings. This design allows downstream reports, forms, and interfaces to display descriptive labels rather than raw codes, which is especially relevant to the user's search term "igs_da_access_level," the lookup type that drives the ACCESS_LEVEL column semantics. The view is documented in ETRM for release 12.2.2 and is applicable to 12.1.1 as the underlying tables and lookup structures are consistent across those releases.

Underlying Base Objects

The view text identifies three source objects, though ETRM records no formally documented base object list. These are:

• IGS_DA_CNFG — the primary configuration table, aliased DAC, holding request type, responsibility, access level, and standard WHO audit columns.
• FND_RESPONSIBILITY_VL — the seeded Oracle Applications responsibility view, aliased FRV, used to resolve the responsibility key to its description. The join constrains VERSION = 'W' and APPLICATION_ID = 8405.
• IGS_LOOKUP_VALUES — the IGS lookup table, aliased LKUP, used to decode the ACCESS_LEVEL code into a meaning via lookup_type 'IGS_DA_ACCESS_LEVEL'.

The join is an inner join across all three objects; rows in IGS_DA_CNFG whose responsibility key does not resolve, or whose access level lacks a matching lookup value, will not appear in the result set.

Key Columns

• ROW_ID — the ROWID of the base configuration row, useful for updates and row-level identification.
• REQUEST_TYPE_ID — identifier of the associated DA request type.
• RESPONSIBILITY_NAME — the responsibility key configured for the DA request.
• RESPONSIBILITY_NAME_MEANING — the responsibility description resolved from FND_RESPONSIBILITY_VL.
• ACCESS_LEVEL — the stored access-level code.
• ACCESS_LEVEL_MEANING — the decoded meaning from the IGS_DA_ACCESS_LEVEL lookup.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — standard audit (WHO) columns inherited from IGS_DA_CNFG.

Common Use Cases and Queries

Typical uses include validating DA access configuration per responsibility, building setup reports, and feeding integration extracts that require descriptive labels. A representative query lists all configured access levels with their meanings:

• SELECT responsibility_name, responsibility_name_meaning, access_level, access_level_meaning, request_type_id FROM apps.igs_da_cnfg_v ORDER BY responsibility_name;
• SELECT * FROM apps.igs_da_cnfg_v WHERE access_level = :p_access_level; — filter by a specific access level, using the "igs_da_access_level" lookup code.
• SELECT responsibility_name, access_level_meaning FROM apps.igs_da_cnfg_v WHERE responsibility_name = :p_resp; — resolve access for a given responsibility.

Because the view resolves descriptions at query time, it is suitable for read-only reporting and validation, but not for direct DML; modifications must target IGS_DA_CNFG.