Results for “user_fk5”

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

Overview

ISCBV_BACKLOGS_FCV is an Oracle E-Business Suite view owned by the APPS schema and classified under the ISC (Supply Chain Intelligence) product family. It is a wrapper view constructed around the base view that supports the Backlog Snapshot fact table within the Supply Chain Intelligence reporting schema. As a wrapper, its primary purpose is to present a denormalized, aggregated, and consistently named projection of the underlying backlog fact data so that downstream Oracle Business Intelligence (OBIEE) repository metadata, Discoverer workbooks, and custom reports can query a stable interface rather than the base fact structure directly.

Because the object is a view and not a table, it stores no data of its own. All values are derived at query time from the base backlog fact table (documented internally as the Backlog Snapshot fact), which is populated during the Supply Chain Intelligence collection and fact-build process. The naming convention — the ISCBV prefix and FCV suffix — indicates an ISC business view intended for fact-level consumption. Its status is documented as VALID, meaning the compiled definition resolves successfully against the referenced objects in the 12.1.1 and 12.2.2 database releases.

Underlying Base Objects

The ETRM metadata identifies this view as a wrapper around the base view for the Backlog Snapshot fact table, but does not enumerate the specific base tables or the base view by name. In practice, the wrapper is defined over an underlying ISC backlog fact view (commonly named with a BASE or F suffix) which in turn reads the physical fact table loaded by the Supply Chain Intelligence fact build, typically stored in a dedicated ISC staging or fact schema.

The view definition performs an explicit GROUP BY over the full set of foreign key and dimension key columns — including BACKLOGS_PK, ITEM_ORG_FK, CUSTOMER_FK, DATE_BALANCE_FK, and the remaining FK columns — while aggregating the measure columns with SUM and retaining the maximum LAST_UPDATE_DATE. This confirms the wrapper is not a simple pass-through; it consolidates records from the base object to a single grain per dimensional key combination before exposing them.

Key Columns

• BACKLOGS_PK and SEQ_ID — surrogate and sequence identifiers for the backlog record combined with the dimensional key set.
• Dimension foreign keys — ITEM_ORG_FK, CUSTOMER_FK, SHIP_TO_CUST_FK, BILL_TO_CUST_FK, ORDER_CATEGORY_FK, ORDER_SOURCE_FK, ORDER_TYPE_FK, SALES_CHANNEL_FK, SALES_PERSON_FK, and related FK columns that link to the ISC dimension tables.
• Bill/Ship/Delinquent backlog measures — BILL_BKLG_MRG_T, SHIP_BKLG_MRG_T, DLQT_BKLG_MRG_T plus the corresponding REV_T and COST_T columns, expressed in transaction currency; the matching _G columns carry the global (functional) currency equivalents.
• Unbilled shipment measures — QTY_UNBILL_SHIP_B, UNBILL_SHIP_REV_T, UNBILL_SHIP_COST_T, UNBILL_SHIP_MRG_T and their _G counterparts.
• Quantity measures — QTY_BILL_BKLG_B, QTY_SHIP_BKLG_B, and QTY_DLQT_BKLG_B, in base UOM as indicated by BASE_UOM_FK.
• LAST_UPDATE_DATE — the maximum update timestamp retained for change-tracking and incremental loading.
• USER_ATTRIBUTE1 through USER_ATTRIBUTE15 — fifteen flex-style attributes available for customer-specific dimensional extensions and reporting customization.

Common Use Cases and Queries

Typical usage centres on backlog aging, order cycle analysis, and revenue/margin reporting where managers need backlog broken out by customer, item, organization, or sales channel. A representative query aggregates shipment backlog by item organization:

SELECT ITEM_ORG_FK, SUM(SHIP_BKLG_REV_G) total_ship_bklg_rev FROM APPS.ISCBV_BACKLOGS_FCV GROUP BY ITEM_ORG_FK;

A second common pattern filters to a specific customer or order category and compares transaction versus global currency measures to reconcile currency conversion results:

SELECT CUSTOMER_FK, SUM(BILL_BKLG_REV_T) bklg_rev_t, SUM(BILL_BKLG_REV_G) bklg_rev_g FROM APPS.ISCBV_BACKLOGS_FCV WHERE ORDER_CATEGORY_FK = :category GROUP BY CUSTOMER_FK;

Because the wrapper is already aggregated at the fact grain, joins to ISC dimension views (typically ISCBV_* dimension views joined on the *_FK columns) are straightforward and do not require additional GROUP BY clauses on the dimensional attributes. Reporting developers should note that data currency depends entirely on the last successful Supply Chain Intelligence fact build, so the MAX(LAST_UPDATE_DATE) column is a useful indicator of data freshness when validating report results.