Search Results open_rec_amt_g

Overview

The view APPS.ISC_RISK_INDICATORS_S is a reporting-layer database object in Oracle E-Business Suite (EBS) Release 12.1.1 and 12.2.2 that exposes supply chain and receivables risk indicators by operating unit. It is a thin wrapper defined exclusively over the single base table FII_AR_RISK_INDICATOR_F, presenting a stable, externally consumable projection of Operating Unit names and a defined set of monetary risk measures. The suffix indicator, "_S", conventionally denotes the "summary"/"secure" reporting variants used across Oracle EBS by Discoverer workbooks, business intelligence layers, and integration extracts.

The view is a runtime object available through ETRM (E-Business Suite Table and View Reference Manual) metadata. Users searching for the column token open_rec_amt_g are typically validating its data source, its aggregation, and its null handling, because that column is a measure exposed verbatim at the view layer from the underlying risk table.

Underlying Base Objects

The view is defined over exactly one documented base object:

• FII_AR_RISK_INDICATOR_F — the Accounts Receivable risk indicator table. This is the physical source of every Operating Unit and monetary measure projected by the view.

Because the view is a direct column-level SELECT against this table, all data acquisition, aggregation, and any incremental refresh logic are handled by the base table FII_AR_RISK_INDICATOR_F. No joins, filters, or unions are introduced by the view. The Operating Unit key and name, and each monetary measure, are passed through with only one transformation: the NVL(..., 0) default applied to each amount column. This guarantees that consumers never receive a NULL amount for the risk metrics exposed.

Key Columns

The view exposes six columns, all sourced directly from FII_AR_RISK_INDICATOR_F:

• OPER_UNIT_FK_KEY — the surrogate key for the Operating Unit, mapped from operating_unit_fk_key. This is the primary grouping key for the view.
• OPER_UNIT_NAME — the descriptive Operating Unit name, mapped from operating_unit_name.
• SHIP_BKLG_AMT_G — shipped backlog amount, defaulted to 0 when NULL.
• DLQT_BKLG_AMT_G — delinquent backlog amount, defaulted to 0 when NULL.
• OPEN_REC_AMT_G — the open receivables amount, sourced from open_rec_amt_g and defaulted to 0 when NULL. This is the column most frequently referenced by users searching for that token.
• PASTDUE_REC_AMT_G — the past-due receivables amount, defaulted to 0 when NULL.

The "_G" suffix on the amount columns denotes "global", indicating that the figures are stored and reported in the functional/global currency unit of the Operating Unit rather than a foreign or reporting-only currency.

Common Use Cases and Queries

The view is typically used in receivables and supply chain risk dashboards that report open receivables by Operating Unit. A minimal extract for the open_rec_amt_g metric is:

SELECT operating_unit_fk_key,
       operating_unit_name,
       open_rec_amt_g,
       pastdue_rec_amt_g
FROM   apps.isc_risk_indicators_s;

Aggregating the risk position per Operating Unit while relying on the enforced non-NULL defaults:

SELECT operating_unit_name,
       SUM(ship_bklg_amt_g)   AS ship_backlog,
       SUM(dlqt_bklg_amt_g)   AS delinquent_backlog,
       SUM(open_rec_amt_g)    AS open_receivables,
       SUM(pastdue_rec_amt_g) AS past_due_receivables
FROM   apps.isc_risk_indicators_s
GROUP  BY operating_unit_name;

Common scenarios include Accounts Receivable aging reviews, credit exposure reporting, and feeds into third-party BI environments that require a pre-joined, NULL-safe view rather than the raw FII_AR_RISK_INDICATOR_F table. Because the view performs no filtering, consumers must apply their own Operating Unit security predicates using OPER_UNIT_FK_KEY or OPER_UNIT_NAME in line with EBS multi-org access controls.