Results for “ben_cwb_rep_salary_v”

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

Overview

BEN_CWB_REP_SALARY_V is a view in the APPS schema of Oracle E-Business Suite, owned by the Advanced Benefits (BEN) product. It belongs to the Compensation Workbench (CWB) family of objects, which support the compensation planning, budgeting, and salary distribution processes used by HR and compensation administrators. The ETRM documentation for release 12.2.2 lists the object as a VALID view owned by APPS and identifies its only referenced base object as the DUAL synonym. Its published view text is SELECT 1 DUMMY FROM DUAL, exposing a single numeric column named DUMMY.

The view therefore functions as a structural placeholder rather than a data-bearing reporting object. In Oracle EBS, views of this pattern are typically seeded by the application during installation or patching to satisfy dependency or compilation requirements while the substantive logic resides in other CWB objects, such as the salary, budget, or worksheet views used by the Compensation Workbench user interface and concurrent programs. Its role in reporting and integration is consequently indirect: it confirms the presence of the CWB schema footprint and can be referenced by dependent objects without returning compensation data.

Underlying Base Objects

The documented base object is DUAL, exposed to the APPS schema in Oracle EBS through a synonym. Because the view selects a literal constant rather than projecting any column from DUAL, it carries no dependency on business data and cannot be joined to employee, assignment, or salary tables through its own columns. It does not reference BEN tables such as the compensation workbench plan, worksheet, or salary repository objects documented elsewhere in Advanced Benefits.

From a dependency standpoint, querying BEN_CWB_REP_SALARY_V exercises only the DUAL synonym under APPS. DBAs should treat it as a metadata artifact when analyzing invalid objects or dependency chains following an upgrade or patch application.

Key Columns

• DUMMY — the sole documented column, defined by the literal 1. It has no business meaning and is not derived from any BEN table.

No salary amount, person, assignment, plan, or date columns are exposed. The name of the view suggests a reporting purpose related to representative or reported salary, but the documented definition provides no such attributes in 12.1.1 or 12.2.2.

Common Use Cases and Queries

Because the view returns exactly one row with a constant value, it is unsuitable for compensation analysis, salary extraction, or integration feeds. A direct query such as the following simply returns the constant:

• SELECT dummy FROM apps.ben_cwb_rep_salary_v;

Practical uses are limited to validation and dependency checks. For example, a DBA verifying object validity after a patch can run:

• SELECT object_name, status FROM dba_objects WHERE object_name = 'BEN_CWB_REP_SALARY_V' AND owner = 'APPS';
• SELECT text FROM dba_views WHERE view_name = 'BEN_CWB_REP_SALARY_V' AND owner = 'APPS';

Administrators seeking actual Compensation Workbench salary data should query the substantive CWB tables and views that underpin plans, worksheets, and budgets rather than this placeholder. Attempting to join it to HR or BEN salary tables on DUMMY would produce a meaningless Cartesian result. In summary, BEN_CWB_REP_SALARY_V is a documented, valid but non-functional view whose metadata should be understood before it is relied upon for any reporting requirement.