Results for “xx”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
View XX is a database object registered in the Oracle E-Business Suite ETRM (E-Business Suite Technical Reference Manual) under the Engineering (ENG) product family. The documented metadata carries the description "Retrofitted" and explicitly records that the view is not implemented in this database. This notation indicates that XX is a placeholder or stub entry generated during documentation extraction rather than an active, deployable database object in the referenced EBS 12.1.1 or 12.2.2 environment.
Within the standard EBS technical reference model, views are catalogued to describe how reporting and integration layers surface data to Oracle Forms, OAF pages, concurrent programs, and third-party extract routines. When a view is flagged as "not implemented," ETRM is signalling that no compiled object definition exists in the schema being documented. Consequently, XX does not participate in runtime reporting or integration in that instance, and any dependent code referencing it would fail at parse or execution time.
Underlying Base Objects
The ETRM metadata for XX documents no referenced base objects. Under normal circumstances, an EBS view entry lists the tables and views it selects from — for example, engineering item master tables such as ENG_ITEMS, BOM structures, or change management tables. For XX, these relationships are absent.
The recorded view text excerpt contains only the marker "Oracle Proprietary, Confidential Information" followed by "Legal Notices," indicating the extraction process retrieved a stub or header rather than a resolvable SQL body. The absence of documented base objects is consistent with the "Not implemented in this database" flag: a view with no deployable definition cannot expose column dependencies or lineage. Any parent-child relationship that would normally be traced through ETRM — for instance, from an ENG view to its underlying item, revision, or ECO tables — is therefore unavailable for XX.
Key Columns
Because XX is documented as not implemented and no view text or base object list is available, the metadata exposes no documented columns. There are no key columns, foreign key exposures, or derived computed fields recorded in the ETRM entry for this object in either 12.1.1 or 12.2.2.
Practitioners should treat any column reference to XX as unresolvable without a site-specific definition. If a customer environment has retrofitted XX locally, the effective column list must be obtained directly from the data dictionary using ALL_TAB_COLUMNS, DBA_VIEWS, or DBA_DEPENDENCIES rather than from ETRM documentation.
Common Use Cases and Queries
Since XX is not implemented in the documented database, there are no standard reporting use cases. The entry functions primarily as a documentation artifact, useful for impact analysis when auditing custom or retrofitted objects in an EBS instance. Analysts verifying whether XX exists in a target environment can query the data dictionary directly:
- Confirm existence:
SELECT owner, view_name, status FROM dba_views WHERE view_name = 'XX'; - Retrieve the actual definition if present:
SELECT text FROM dba_views WHERE view_name = 'XX'; - Identify dependents:
SELECT * FROM dba_dependencies WHERE referenced_name = 'XX'; - List columns in a locally retrofitted copy:
SELECT column_name, data_type FROM dba_tab_columns WHERE table_name = 'XX';
These queries should be executed in the specific instance under investigation. In the absence of a valid object, results will return no rows, confirming the ETRM "Not implemented" status.
-
View: XX 12.2.2
- Retrofitted
Not implemented in this database·Explore ENG module →
-
View: XX 12.1.1
- Retrofitted
Not implemented in this database·Explore ENG module →
-
PACKAGE: APPS.HZ_PURGE_GEN 12.1.1
-
PACKAGE: APPS.HZ_PURGE_GEN 12.2.2
-
VIEW: APPS.OKL_STREAMS_REP_V 12.2.2
-
VIEW: APPS.OKL_STREAMS_REP_V 12.1.1
-
Item template listing xx xx Short Name INVIRTMP Itemp Template Report
-
Table: PAY_US_ASG_REPORTING 12.1.1
Denormalised performance table for accessing balances.
-
Table: PAY_US_ASG_REPORTING 12.2.2
Denormalised performance table for accessing balances.
-
Concurrent Program: INVIRTMP 12.1.1
Item Template Report
-
Concurrent Program: INVIRTMP 12.2.2
Item Template Report
-
Item template listing xx xx Short Name INVIRTMP Itemp Template Report