Results for “hr_admin_lov_v”
15 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
HR_ADMIN_LOV_V is a database view owned by the APPS schema within the PER (Human Resources) product family in Oracle E-Business Suite 12.1.1 and 12.2.2. The ETRM metadata describes it as the "Hr Web Offers list of values view," identifying its functional role in supporting the list of values (LOV) mechanism used by the Oracle HRMS Web Offers (Recruitment) self-service pages. In Oracle EBS, LOV views are lightweight, purpose-built objects that supply the pick-list values rendered by the OA Framework (OAF) or older web-based recruitment pages without incurring the overhead of full base-table queries.
Its status is documented as VALID, indicating the object compiles and is present in a supported state within the APPS schema. While its name suggests a data-rich LOV, the documented implementation reveals that the view is a structural placeholder rather than a substantive data source. It contains no references to applicant, offer, or candidate tables, and therefore contributes nothing to reporting or integration in isolation.
Underlying Base Objects
The documented view definition references exactly one base object: SYS.DUAL, the standard one-row, one-column Oracle dictionary table. The ETRM 12.2.2 metadata explicitly lists DUAL (TABLE) as the only referenced base object. The view text is:
SELECT DUMMY||'1' ID1, DUMMY||'2' ID2, DUMMY||'3' ID3 FROM SYS.DUAL
Because DUAL contains a single row with the value X, the view resolves to a single row with the constants X1, X2, and X3. There is no join to HR_APPLICANTS, HR_OFFERS, PER_ALL_PEOPLE_F, or any other PER table. Consequently, the view carries no dependency chain beyond the dictionary, and no foreign-key or parent-child relationship applies.
Key Columns
The view exposes three columns, each produced by concatenating DUAL's DUMMY value with a numeric literal. Their documented names and effective values are:
- ID1 — expression
DUMMY||'1'; resolves to the constantX1. - ID2 — expression
DUMMY||'2'; resolves to the constantX2. - ID3 — expression
DUMMY||'3'; resolves to the constantX3.
The absence of descriptive columns (no meaning, description, or code value fields) confirms that this object is not intended to return business data. The IDs are opaque placeholders aligned to the HRMS Web Offers LOV framework, where a consuming page expects one or more ID columns to bind selection values. Analysts should not interpret ID1–ID3 as surrogate keys to any PER entity.
Common Use Cases and Queries
Practical use of HR_ADMIN_LOV_V is limited. It is typically invoked internally by the Web Offers administration LOV rather than by end-user reports. A query against the view returns the following deterministic result set:
SELECT id1, id2, id3 FROM apps.hr_admin_lov_v;— returns one row:X1, X2, X3.
Typical scenarios include inventory verification during EBS upgrades (confirming the object exists and is VALID in APPS), dependency analysis via USER_DEPENDENCIES or ALL_DEPENDENCIES, and troubleshooting recruitment LOV rendering failures. Because the view depends only on SYS.DUAL, it cannot be used to enumerate offers, applicants, or candidates. Developers needing genuine HR offer data must query the underlying PER recruitment tables instead. The view should be regarded strictly as a framework artifact whose documented ETRM definition is its authoritative specification.
-
View: HR_ADMIN_LOV_V 12.1.1
Hr Web Offers list of values view
-
View: HR_ADMIN_LOV_V 12.2.2
Hr Web Offers list of values view
-
VIEW: APPS.HR_ADMIN_LOV_V 12.1.1
-
VIEW: APPS.HR_ADMIN_LOV_V 12.2.2
-
12.2.2 FND Design Data 12.2.2
-
12.1.1 FND Design Data 12.1.1
-
TABLE: SYS.DUAL 12.2.2
-
TABLE: SYS.DUAL 12.1.1
-
12.2.2 DBA Data 12.2.2
-
12.1.1 DBA Data 12.1.1
-
eTRM - PER Tables and Views 12.1.1
Table to store NQF Training info for a person
-
eTRM - PER Tables and Views 12.2.2
Table to store NQF Training info for a person
-
eTRM - PER Tables and Views 12.1.1
Table to store NQF Training info for a person
-
eTRM - PER Tables and Views 12.2.2
Table to store NQF Training info for a person