Search Results vea_versions




Overview
Explore in AI Chat

Overview

VEA.VEA_VERSIONS is a table owned by the VEA schema, registered in Oracle E-Business Suite as part of the VEA – Automotive product module. The ETRM metadata classifies the object with a status of VALID, but its product description is explicitly recorded as "Not currently used." This designation indicates that while the physical table exists in the 12.1.1 and 12.2.2 schemas and retains a valid, compileable definition, Oracle does not expose it through any active Automotive application flow. It is best understood as a dormant or legacy repository rather than a functional business object in the delivered application.

The heuristic Data Vault classification mined from the foreign-key structure is standalone. In Data Vault modeling terms this suggests the table functions as neither a true hub, link, nor satellite within its documented relationships: it holds its own primary key (VERSION_ID) but no foreign keys of its own are recorded, and its downstream references are effectively orphan-style joins from unrelated modules. Analysts building a vault model should treat VERSION_ID as a candidate hub key despite the absence of inbound dependencies, but should validate against live data before relying on it.

Key Information Stored

The documented physical schema for 12.2.2 lists 14 columns. The most significant are:

Because no foreign keys originate from VEA_VERSIONS, and no unique business index is documented beyond the primary key, VERSION_ID remains the only reliable unique identifier.

Common Use Cases and Queries

As the table is "not currently used," reporting queries are typically investigative or data-migration oriented. Typical patterns include verifying population and checking orphaned downstream references:

  • Row count and date-range profiling: SELECT COUNT(*), MIN(CREATION_DATE), MAX(CREATION_DATE) FROM VEA.VEA_VERSIONS;
  • Joining to dependents to confirm whether any downstream rows still point at this table, for example SELECT v.VERSION_ID, v.VERSION_NUMBER, j.VERSION_ID FROM VEA.VEA_VERSIONS v, JTS.JTS_CONFIG_VERSIONS_B j WHERE v.VERSION_ID = j.VERSION_ID;
  • Cleanup or archival assessment ahead of upgrades, since a deprecated object may be a candidate for purge.

Related Objects

Numerous tables in other modules carry a VERSION_ID foreign key nominally pointing to VEA_VERSIONS. The most significant include: