Search Results edw_local_instance




Overview
Explore in AI Chat

Overview

EDW_PROJECT_MPV is a database view historically shipped under the FII – Financial Intelligence product family. In the Oracle EBS 12.1.1 and 12.2.2 release streams, FII is classified as obsolete, meaning the view is retained only for backward compatibility with legacy EDW (Enterprise Data Warehouse) extraction routines and is not part of any currently supported functional flow. Its documented purpose is to serve as a source-side data validity view for project and task records, providing a consolidated, extract-ready projection of project and task keys together with their last update timestamps.

The view is significant in the context of the "edw_local_instance" search because EDW_LOCAL_INSTANCE is the anchor object that supplies the INSTANCE_CODE used to tag each extracted record. By concatenating a source identifier with the instance code, the view produces delta-detection keys that allow ETL processes to determine which project or task records have changed since the last extraction cycle.

Underlying Base Objects

The view text references four base objects:

Documented ETRM metadata records the owner as blank and lists no referenced base objects for the 12.2.2 release, confirming that the object is not implemented in current databases. Where it does exist, it is a UNION ALL of three query blocks, each joining a source table to EDW_LOCAL_INSTANCE to produce a composite key.

Key Columns

  • DIM_PK – the composite primary key exposed by the view, formed as TASK_ID || '-' || INSTANCE_CODE (or the project/Seiban equivalent). This is the value ETL processes use to match source rows to warehouse dimensions.
  • DIM_PK_DATE – the LAST_UPDATE_DATE carried through from the source record, used for delta detection and change-data-capture filtering.

The first UNION branch emits task-level keys, the second emits project-level keys suffixed with '-PJ-PRJ', and the third emits Seiban project keys. Only leaf tasks are returned, since the query filters on the NOT EXISTS clause or a NULL PARENT_TASK_ID.

Common Use Cases and Queries

Typical usage is confined to legacy EDW staging extracts that need a single, instance-tagged key stream for projects and tasks. A representative query:

  • SELECT DIM_PK, DIM_PK_DATE FROM EDW_PROJECT_MPV WHERE DIM_PK_DATE > :last_run_date; — incremental extraction.
  • SELECT * FROM EDW_PROJECT_MPV WHERE DIM_PK LIKE '%-PJ-PRJ'; — isolate project-level rows.

Because FII is obsolete and the view is not implemented in 12.1.1/12.2.2 databases, it should be treated as reference material only. Replacements should query PA_TASKS, PA_PROJECTS_ALL, and EDW_LOCAL_INSTANCE directly, or adopt the current subledger accounting and BI Publisher extraction views.