Search Results project_fk




Overview
Explore in AI Chat

Overview

FII_PROJ_TOP_TASK_LCV is a reporting view belonging to the FII (Financial Intelligence) product family, which Oracle has since designated as obsolete within the E-Business Suite 12.1.1 and 12.2.2 release lines. The view presents Project Top Task level data and serves as a source for the Project dimension within the Enterprise Data Warehouse (EDW) associated with Financial Intelligence. In practical terms, it exposes the highest-level task structure of a project — the "top task" — together with identifying keys, descriptive attributes, scheduling dates, and cost-related information. Because FII was designed to feed analytical and data-warehousing workloads rather than transactional processing, FII_PROJ_TOP_TASK_LCV is intended to be consumed by ETL processes that populate and refresh the Project dimension.

For users researching the "project_fk" column, this view is directly relevant: it exposes PROJECT_FK, the foreign key that links each top task row to its owning project. This relationship is central to building dimensional hierarchies in which tasks roll up to projects and ultimately to higher organizational groupings.

Underlying Base Objects

According to the documented view definition, FII_PROJ_TOP_TASK_LCV is a thin wrapper over a single base view, FIIBV_PROJ_TOP_TASK_LCV. Its SELECT statement projects a defined column list from that base object and appends five NULL placeholders that map to the user attribute slots. No base tables are documented beyond this reference, and the ETRM metadata notes that the view text was captured but that no other referenced base objects are documented.

The columns exposed are TOP_TASK_PK, NAME, TOP_TASK, TASK_NUMBER, PROJECT_FK, INSTANCE, TASK_START_DATE, TASK_END_DATE, SERVICE_TYPE_CODE, LABOR_COST_MULT, LAST_UPDATE_DATE, followed by the five USER_ATTRIBUTE slots (USER_ATTRIBUTE1 through USER_ATTRIBUTE5), which are populated as NULLs in this definition. Importantly, the metadata states that the object is "Not implemented in this database," meaning that in the environment from which the documentation was drawn, the view did not physically exist. Its definition is preserved as reference documentation.

Key Columns

  • TOP_TASK_PK — The unique primary key identifying the top task record.
  • PROJECT_FK — The foreign key associating the top task with its parent project; the pivot column for project-to-task joins.
  • NAME / TOP_TASK / TASK_NUMBER — Descriptive identifiers for the task: its display name, the top task designation, and the task number.
  • INSTANCE — Identifies the source instance or operating unit context from which the record was extracted.
  • TASK_START_DATE / TASK_END_DATE — Scheduled or actual start and end dates for the top task, supporting time-based analysis.
  • SERVICE_TYPE_CODE — Classifies the type of service associated with the task.
  • LABOR_COST_MULT — The labor cost multiplier applied to the task, used in costing and revenue calculations.
  • LAST_UPDATE_DATE — The timestamp of the most recent modification, essential for incremental ETL loads.
  • USER_ATTRIBUTE1–5 — Discretionary attribute slots projected as NULL.

Common Use Cases and Queries

The principal use case is EDW extraction: populating the Project dimension and its top-task hierarchy, filtered or joined on PROJECT_FK. A representative query retrieves top tasks for a specific project:

  • SELECT TOP_TASK_PK, NAME, TASK_NUMBER, TASK_START_DATE, TASK_END_DATE FROM FII_PROJ_TOP_TASK_LCV WHERE PROJECT_FK = :project_id;
  • Incremental extraction: SELECT * FROM FII_PROJ_TOP_TASK_LCV WHERE LAST_UPDATE_DATE > :last_run_date;
  • Hierarchy staging joined to project master data on PROJECT_FK to resolve project names and organizations.

Because the object is obsolete and reported as not implemented, these patterns are documented for reference and migration analysis rather than active production use.