Search Results edw_pmi_pgrd_pgrd_ltc

Overview

The object EDW_PMI_PGRD_PGRD_LTC is a database table documented within the Oracle E-Business Suite (EBS) documentation set for release levels 12.1.1 and 12.2.2. It belongs to the product family PMI — Process Manufacturing Intelligence, which Oracle has classified as Obsolete. Objects carrying the EDW_ prefix are typically artifacts of the Oracle Enterprise Data Warehouse / Business Intelligence extensions shipped alongside Process Manufacturing Intelligence, used to stage or expose grade-related data for analytical reporting rather than for transactional processing.

The ETRM metadata explicitly records that this table is not implemented in this database. Consequently, in most environments the object exists only as documentation, as a remnant in an upgrade script, or as a data model reference; it will generally not resolve in ALL_TABLES or DBA_TABLES. This is a key practical fact: any attempt to query the table directly should first be guarded by a dictionary check.

Based on the primary key structure EDW_PMI_PGRD_PGRD_LTC_U on the column GRADE_PK, and the associated unique key EDW_PMI_PGRD_PGRD_LTC_UKEY on GRADE_PK_KEY, the heuristic Data Vault classification mined from the foreign key structure is standalone. In Data Vault modelling terms this suggests the table behaves as a hub-like or reference entity for grade data — it carries a surrogate primary key and an alternate business key, but shows no documented foreign key dependencies linking it to other tables in the vault. This is a modelling suggestion derived from FK metadata, not a normative Oracle designation.

Key Information Stored

The documented metadata names only the key-bearing columns, which are the most significant attributes available:

• GRADE_PK — the surrogate primary key column, governed by the constraint EDW_PMI_PGRD_PGRD_LTC_U. This is the unique internal identifier for each row in the table.
• GRADE_PK_KEY — the business-key candidate, governed by the unique index/constraint EDW_PMI_PGRD_PGRD_LTC_UKEY. This column typically carries the integration or natural key value derived from the source grade definition, used to reconcile EDW rows back to the operational Process Manufacturing grade records.

The table takes its name from the Process Manufacturing grade (PGRD) domain, and the _LTC suffix commonly denotes a "load to core" or level/lookup table variant within the EDW staging convention. Beyond the two documented key columns, the metadata does not provide a column list; additional descriptive attributes should be treated as undocumented until verified against the actual installation.

Common Use Cases and Queries

Because the object is obsolete and unimplemented, its primary use case is impact analysis and migration verification. A defensive query pattern is recommended:

• Existence check prior to any reference:

  SELECT table_name, owner
  FROM   all_tables
  WHERE  table_name = 'EDW_PMI_PGRD_PGRD_LTC';

• Key and constraint discovery from the data dictionary:

  SELECT constraint_name, constraint_type, column_name
  FROM   all_cons_columns
  WHERE  table_name = 'EDW_PMI_PGRD_PGRD_LTC';

• Once existence is confirmed, a grade-level reporting join would resolve the natural key back to the operational grade master:

  SELECT edw.grade_pk, edw.grade_pk_key
  FROM   edw_pmi_pgrd_pgrd_ltc edw;

Typical consumption scenarios include legacy BI extract validation, comparison of pre- and post-upgrade data model inventories, and assessment of whether any downstream custom report or OBIEE repository still references the obsolete object before removal.

Related Objects

Per the documented relationship data, the table's Data Vault classification is standalone, and no foreign keys are recorded. The only documented relationships are the two constraints on the table itself:

• EDW_PMI_PGRD_PGRD_LTC_U — primary key constraint on GRADE_PK, referenced by the table's own key definitions.
• EDW_PMI_PGRD_PGRD_LTC_UKEY — unique key constraint on GRADE_PK_KEY, used for business-key reconciliation.

Join candidates would logically be the Process Manufacturing grade master (PGRD_GRADE-class objects) and other EDW_PMI_PGRD_* warehouse tables, but no explicit FK join columns are documented in the supplied metadata, and such relationships should be confirmed against the live schema before being relied upon. Given the object's obsolete status, no EBS API or concurrent program currently depends on it in supported configurations.