Search Results oper_unit_name




Overview
Explore in AI Chat

Overview

ISC_RISK_INDICATORS_S is a Supply Chain Intelligence (ISC) view owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It exposes a curated set of accounts receivable risk indicators aggregated at the operating unit level, together with the operating unit identifier and name. Because it is a view rather than a table, it stores no data of its own; it presents a relational projection over a single underlying ISC fact table, FII_AR_RISK_INDICATOR_F.

The view's principal purpose is to simplify consumption by reporting tools, Discoverer workbooks, BI Publisher reports, and integration interfaces. Consumers reference the stable column names exposed by the view rather than the base fact table, which may carry additional or differently named columns. The trailing _S designation is consistent with the ETRM naming convention used for secured or synonym-style presentation objects, indicating that the object is intended as a simplified, security-conscious row source. The view is marked VALID in the ETRM documentation, confirming that it compiles successfully against its base object at the supported release levels.

Underlying Base Objects

The documented view definition selects exclusively from FII_AR_RISK_INDICATOR_F, the accounts receivable risk indicator fact table in the ISC schema family. No additional base tables or objects are documented as referenced. The view applies no joins, filters, or aggregation of its own; its transformation logic is limited to column aliasing and the substitution of zero values for nulls.

Specifically, the definition maps OPERATING_UNIT_FK_KEY to the view column OPER_UNIT_FK_KEY and OPERATING_UNIT_NAME to OPER_UNIT_NAME. The measure columns are wrapped in NVL(..., 0), ensuring that a missing or unpopulated risk metric is returned as zero rather than NULL. This behavior is significant for arithmetic and aggregation, since it prevents null propagation from distorting totals. The seed column OPERATING_UNIT_FK_KEY is the foreign key that joins the risk indicators back to the operating unit dimension.

Key Columns

  • OPER_UNIT_FK_KEY — The operating unit foreign key, aliased from OPERATING_UNIT_FK_KEY. This column is the search term of interest and serves as the join key to operating unit dimensions such as HR_OPERATING_UNITS or the ISC operating unit staging tables.
  • OPER_UNIT_NAME — The descriptive name of the operating unit, denormalized into the view for display without a join.
  • SHIP_BKLG_AMT_G — Shipping backlog amount, expressed in the reporting currency (the _G suffix conventionally denotes the global or reporting currency amount). Nulls are returned as 0.
  • DLQT_BKLG_AMT_G — Delinquent backlog amount, in reporting currency, with nulls returned as 0.
  • OPEN_REC_AMT_G — Open receivables amount, in reporting currency, with nulls returned as 0.
  • PASTDUE_REC_AMT_G — Past-due receivables amount, in reporting currency, with nulls returned as 0.

Common Use Cases and Queries

The view is typically used to populate operating-unit-level risk dashboards and exception reports. A typical query returns all risk indicators for a single operating unit:

SELECT OPER_UNIT_FK_KEY, OPER_UNIT_NAME, SHIP_BKLG_AMT_G, DLQT_BKLG_AMT_G, OPEN_REC_AMT_G, PASTDUE_REC_AMT_G FROM APPS.ISC_RISK_INDICATORS_S WHERE OPER_UNIT_FK_KEY = :p_operating_unit;

Because OPER_UNIT_FK_KEY is the join key, the view is frequently combined with the operating unit dimension to resolve legal entity, ledger, and organization hierarchy context. Aggregating total exposure across all operating units is also common:

SELECT SUM(OPEN_REC_AMT_G) TOTAL_OPEN, SUM(PASTDUE_REC_AMT_G) TOTAL_PASTDUE FROM APPS.ISC_RISK_INDICATORS_S;

Reporting users should note that the zero-substitution behavior means a metric that is genuinely absent is indistinguishable from a true zero in the view. Where that distinction matters, the underlying FII_AR_RISK_INDICATOR_F should be queried directly.