Results for “igi_itr_charge_auth_v”

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

Overview

IGI_ITR_CHARGE_AUTH_V is a seeded Oracle E-Business Suite view owned by the APPS schema and defined in the IGI – Public Sector Financials International product. It presents charge authority assignment data by joining the charge authorization table IGI_ITR_CHARGE_AUTH with FND_USER, the standard EBS applications user repository. The view exposes one row per charge authority record, combining the authorization attributes with the corresponding application user name. Its principal role is to provide a denormalized, read-only projection of charge authority assignments that reports, concurrent programs, and integration interfaces can query without embedding the join to FND_USER themselves. The view is documented as VALID in both EBS 12.1.1 and 12.2.2, and its structure is consistent across those releases.

Underlying Base Objects

The view is defined over two referenced objects, both resolved through APPS synonyms:

• IGI_ITR_CHARGE_AUTH — the base charge authority table, aliased AUTH in the view text. It supplies the primary key ROWID, the USER_ID, CHARGE_CENTER_ID, and the standard WHO audit columns (CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN).
• FND_USER — aliased FU, the EBS user table. The view joins FU.USER_ID = AUTH.USER_ID and selects FU.USER_NAME as AUTH_NAME_DSP.

Because the relationship is an inner join on USER_ID, only charge authority rows whose USER_ID resolves to an existing FND_USER record are returned. Charge authority rows with an orphaned or null USER_ID are therefore excluded from the view result set, a behavior worth considering when reconciling the view against the base table.

Key Columns

• ROW_ID — the ROWID of the underlying IGI_ITR_CHARGE_AUTH row. This is a unique row identifier per charge authority record and is useful for direct-row addressing, though it is not the primary key in the relational sense.
• USER_ID — the FND_USER identifier of the user to whom the charge authority is assigned; the join key to FND_USER.
• CHARGE_CENTER_ID — the identifier of the charge center (the organization or budgetary unit) for which the user holds charge authority. This is the column most frequently searched in this context and is the principal filter attribute for charge authority reporting.
• AUTH_NAME_DSP — the user name from FND_USER, exposed as a display value so reports can show the authorized user without a secondary lookup.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — the standard EBS audit columns carried through from IGI_ITR_CHARGE_AUTH, supporting audit trail, change tracking, and load diagnostics.

Common Use Cases and Queries

The view is typically used to answer who is authorized to charge to a given charge center, and conversely which charge centers a user is authorized over. A common reporting query lists all authorities for a specific charge center:

SELECT auth_name_dsp, user_id, charge_center_id, creation_date
FROM apps.igi_itr_charge_auth_v
WHERE charge_center_id = :p_charge_center_id;

A second pattern enumerates the charge centers assigned to a user, using the display name for readability:

SELECT user_id, auth_name_dsp, charge_center_id
FROM apps.igi_itr_charge_auth_v
WHERE user_name = :p_user_name
ORDER BY charge_center_id;

Because the view already joins FND_USER, querying AUTH_NAME_DSP avoids a separate lookup and is well suited to concurrent programs, XML Publisher reports, and inbound/outbound integration extracts that need authoritative charge authority assignments. For audit or reconciliation purposes, comparing counts between the view and IGI_ITR_CHARGE_AUTH identifies charge authority records missing a matching FND_USER row.

Oracle Proprietary, Confidential Information.