Results for “igs_or_unit_acct_cd”

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

Overview

IGS_OR_UNIT_ACCT_CD is a secured (Multi-Org compliant) view owned by the APPS schema in the Oracle E-Business Suite Student System (IGS) product family. It presents organizational unit account code assignments, allowing consumers to resolve, by organization unit and effective start date, the revenue account code associated with a given organizational unit within a specific operating unit (ORG_ID). The view is defined over the _ALL base table IGS_OR_UNIT_ACCT_CD_ALL and is therefore the reporting-facing, operating-unit-filtered counterpart to the underlying table. Its status is documented as VALID in ETRM 12.2.2 and it is compatible with EBS 12.1.1 and 12.2.2 environments.

Because the view applies a Multi-Org security predicate, it returns only those rows whose ORG_ID matches the operating unit context established by the session's CLIENT_INFO value (or rows with a NULL ORG_ID, which are treated as global). This makes it suitable for operational reporting, concurrent programs, and integration extracts that must respect the caller's current organization context rather than exposing data across all operating units.

Underlying Base Objects

The only documented base object referenced by the view text is IGS_OR_UNIT_ACCT_CD_ALL. The view selects ROWID (aliased as ROW_ID in the documented column list) together with the substantive columns from that table and appends the standard Multi-Org security filter. ETRM 12.2.2 documents no additional referenced base objects beyond this table.

The security predicate compares the row-level ORG_ID against the value derived from USERENV('CLIENT_INFO'), defaulting to -99 when no organization context is present. This is the standard Oracle Multi-Org (VPD-style) pattern used throughout the _ALL/_V view pairs in EBS. Consequently, the view is functionally a projection of IGS_OR_UNIT_ACCT_CD_ALL constrained by the session's operating unit, and it inherits the _ALL table's date-effective structure through the START_DT column.

Key Columns

• ROW_ID — The ROWID of the underlying _ALL table row, exposed for uniqueness and direct row addressing.
• ORG_ACCOUNT_CD_ID — Primary key identifier for the unit-to-account assignment record.
• ORG_UNIT_CD — The organizational unit code to which the account code applies.
• START_DT — The effective start date of the assignment, supporting date-effective retrieval of the active account code.
• REV_ACCOUNT_CD — The revenue account code assigned to the organizational unit, the principal business attribute of this view.
• ORG_ID — Operating unit identifier used by the Multi-Org security predicate and by reporting joins to organization/operating unit reference data.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard EBS WHO columns providing audit lineage for each assignment.

Common Use Cases and Queries

Typical uses include validating the active revenue account code for an organizational unit as of a reporting period, building date-effective account lookups for revenue recognition extracts, and auditing changes to unit-to-account assignments. Because the view enforces operating unit security, callers must run within the correct ORG context (for example, through a Multi-Org–initialized session or a concurrent program that sets CLIENT_INFO) to see the intended rows.

• Retrieve the current effective revenue account for a specific unit:

SELECT ORG_UNIT_CD, REV_ACCOUNT_CD, START_DT
FROM   APPS.IGS_OR_UNIT_ACCT_CD
WHERE  ORG_UNIT_CD = :p_unit
AND    START_DT <= SYSDATE
ORDER BY START_DT DESC;

• Report all account assignments for the current operating unit, ordered for review:

SELECT ORG_ACCOUNT_CD_ID, ORG_UNIT_CD, START_DT, REV_ACCOUNT_CD
FROM   APPS.IGS_OR_UNIT_ACCT_CD
ORDER BY ORG_UNIT_CD, START_DT;

Since the underlying base object and filter are limited to the documented _ALL table, any query returning more rows than expected at the operating unit level should be reconciled against IGS_OR_UNIT_ACCT_CD_ALL and the active CLIENT_INFO organization context.