Results for “edw_proj_cls7_lstg”

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

Overview

EDW_PROJ_CLS7_LSTG is a staging table within the FII (Financial Intelligence) product family of Oracle E-Business Suite. Its documented purpose is to serve as a staging area for project class 7 level data, which corresponds to the seventh level of the project classification hierarchy used by Oracle Projects to categorize projects along dimensions such as project type, organization, and funding source. The table carries the FII schema owner and is documented in ETRM 12.1.1 with seventeen columns.

The metadata explicitly marks the FII product as obsolete, and the implementation notes state that the object is "not implemented in this database." This indicates that EDW_PROJ_CLS7_LSTG is a legacy artifact retained for documentation and upgrade lineage purposes rather than an actively populated object in current environments. In Oracle EBS 12.1.1 and 12.2.2, most Financial Intelligence extraction logic has been superseded by the Enterprise Command Center (ECC) and OBIA-based analytics, so the staging tables in this family typically appear only in historical schemas or in databases upgraded from earlier 11i installations.

Mined from its foreign key structure, the heuristic Data Vault classification for this table is standalone. As a modeling suggestion, this implies the table does not function as a conventional hub, link, or satellite within a Data Vault model, but operates as an independent staging construct whose relationships are enforced through application logic rather than a dense web of foreign key constraints.

Key Information Stored

The table's most significant columns and their roles are as follows:

• PROJ_CLS7_PK — The surrogate primary key for the staging row. This is the technical identifier used by the extraction process to sequence and reconcile records during a load.
• PROJ_CATEG7_FK — The foreign key to the project class 7 category definition; the primary business-key candidate linking the staging row to the source classification.
• PROJ_CATEG7_FK_KEY — A derived key column, often a concatenated or hashed value of the category foreign key used for warehouse-level matching.
• PROJECT_CLASS7 — The descriptive name of the class 7 value being staged.
• NAME — A general descriptive label, typically the category or set name associated with the staged record.
• INSTANCE — Identifies the source EBS instance or operating unit from which the record was extracted.
• REQUEST_ID — The concurrent request identifier that produced the staging load, essential for tracing batch runs.
• COLLECTION_STATUS — Indicates the processing state of the row (for example, extracted, loaded, or errored).
• ERROR_CODE — Captures any load or validation failure associated with the record.
• OPERATION_CODE — Encodes the DML intent of the record (insert, update, or delete) during incremental loads.
• ROW_ID — A row identifier sourced from CS_SYSTEMS_ALL_B_TEMP, used in the documented foreign key relationship.
• DELETION_DATE — Records when the staged classification was logically removed from the source system.
• USER_ATTRIBUTE1 through USER_ATTRIBUTE5 — Flexible descriptor columns available for client-specific extensions.

The documented foreign key relationship is EDW_PROJ_CLS7_LSTG.ROW_ID referencing CS_SYSTEMS_ALL_B_TEMP.

Common Use Cases and Queries

Because the table is obsolete and unimplemented, queries typically appear during data lineage investigations, upgrade impact assessments, or reconstruction of historical Financial Intelligence extracts. A representative pattern joins the staging table to the concurrent request for audit:

SELECT l.PROJ_CLS7_PK, l.PROJECT_CLASS7, l.COLLECTION_STATUS, l.ERROR_CODE
FROM FII.EDW_PROJ_CLS7_LSTG l
WHERE l.REQUEST_ID = :request_id
ORDER BY l.PROJ_CLS7_PK;

Error triage queries filter on COLLECTION_STATUS and ERROR_CODE to isolate failed rows from a specific batch run. Lineage checks join ROW_ID to CS_SYSTEMS_ALL_B_TEMP to confirm source reconciliation. During migrations from 11i to 12.1.1 or 12.2.2, DBAs may probe for the table's existence to determine whether legacy extraction jobs remain scheduled.

Related Objects

• CS_SYSTEMS_ALL_B_TEMP — Referenced by EDW_PROJ_CLS7_LSTG.ROW_ID; the temporary source for system and row identifiers.
• EDW_PROJ_CLS1_LSTG through EDW_PROJ_CLS6_LSTG and EDW_PROJ_CLS8_LSTG — Sibling staging tables for the other project classification levels, sharing the same structural pattern.
• FND_CONCURRENT_REQUESTS — Joined on REQUEST_ID to resolve the submitting concurrent program and its status.
• PA_PROJECT_CLASSES / PA_CLASS_CATEGORIES — The Oracle Projects base tables that define the class 7 hierarchy staged here.
• EDW_PROJ_STG — The parent project staging construct into which class 7 rows are ultimately consolidated.
• FII schema extraction programs — Legacy concurrent programs that populated these staging tables before the product was obsoleted.