Results for “assignment_changed”

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

Overview

BEN_CWB_PPAUD_DOWNLOAD_V is an Oracle E-Business Suite database view owned by the APPS schema and registered as VALID in the ETRM repository. It belongs to the BEN (Advanced Benefits) product family and is documented as a "View to download the Post Process Audit Log Report using webadi." In practical terms, the view exists to expose the audit trail generated by the Compensation Workbench post-process audit routine in a flattened, WebADI-friendly format so that administrators and compensation analysts can extract it to a spreadsheet for review, reconciliation, or archival.

The Post Process Audit Log records what happened to an employee's compensation, benefit plan, or option when a Compensation Workbench process was executed — including calculated amounts, units, and any error or warning text raised during processing. Because the view emits a fixed, predictable set of columns and applies its own filtering and ordering, it is well suited to being consumed by WebADI as a download integration rather than by ad hoc reporting against the underlying detail table.

Although BI Publisher, Oracle Reports, and the Compensation Workbench UI are the primary consumers of this data, the view is commonly queried directly by technical consultants who need to validate processing outcomes or troubleshoot plan-level discrepancies. Note that the object is Oracle proprietary and confidential, and its metadata is governed by Oracle's legal notices.

Underlying Base Objects

Per the documented 12.2.2 metadata, BEN_CWB_PPAUD_DOWNLOAD_V references a single base object: BEN_CWB_RPT_DETAIL, which is exposed in the APPS schema as a synonym. BEN_CWB_RPT_DETAIL is the staging/detail table populated by the Compensation Workbench reporting and post-process audit routines. The view does not join to any additional tables; instead, it selects from this detail table, applies a filter, and renames selected columns through column aliases.

The defining filter is WHERE NVL(PERSON_RATE_ID, 0) <> -9999, which suppresses rows flagged with the sentinel value -9999 in PERSON_RATE_ID. This sentinel is typically used to denote non-rate or summary rows that are not meaningful to the audit download. The query also applies ORDER BY FULL_NAME, so the output is sorted alphabetically by employee name, which supports readable spreadsheet output.

Key Columns

• EMPLOYEE_NAME — supplies the employee's full name from the base object's FULL_NAME column. This is the primary sort key.
• EMPLOYEE_NUMBER — the employee number, retained as EMPLOYEE_NUMBER and the column of interest for the original search. This is the standard HR identifier used to reconcile audit output against the person records.
• BUSINESS_GROUP_NAME — the business group under which the person is recorded, useful for filtering a download by legal employer or BG.
• MANAGER_NAME — the manager associated with the person or action, supporting supervisory review.
• PLAN_NAME and OPTION_NAME — the benefit or compensation plan and the specific option (e.g., coverage level) affected by the processed action.
• AMOUNT and UNITS — the compensation or benefit amount and associated unit quantity produced by the process.
• PERFORMANCE_RATING — the rating carried into the Compensation Workbench calculation, where applicable.
• ASSIGNMENT_CHANGED — aliased from ASSIGNMENT_CHANGED_FLAG, indicating whether the assignment was modified during processing.
• ERROR_MESSAGE — aliased from ERROR_OR_WARNING_TEXT; the error or warning text raised by the audit, blank when the row processed cleanly.
• PERSON_RATE_ID and BENEFIT_ACTION_ID — surrogate keys linking the audit row back to the person rate and the benefit action that generated it.

Common Use Cases and Queries

The principal use case is the WebADI download of the Post Process Audit Log Report, where the view's stable column list and ordering serve as the integration contract. Beyond that, the view is frequently used for troubleshooting batch Compensation Workbench runs, confirming that amounts and units were written as expected, and identifying employees whose processing produced errors or warnings.

A typical query retrieves all audit rows for a specific employee number:

• SELECT employee_number, employee_name, plan_name, option_name, amount, units, error_message FROM apps.ben_cwb_ppaud_download_v WHERE employee_number = :p_emp_num;

To isolate only rows that raised issues, filter on the error column:

• SELECT employee_number, plan_name, option_name, error_message FROM apps.ben_cwb_ppaud_download_v WHERE error_message IS NOT NULL ORDER BY employee_name;

To review results for a plan or business group, restrict on the corresponding columns and aggregate amounts:

• SELECT business_group_name, plan_name, SUM(amount) total_amount FROM apps.ben_cwb_ppaud_download_v GROUP BY business_group_name, plan_name;

Because the view applies its own filtering and sorting, these queries generally run efficiently and return data in a form suitable for direct export or further reporting. Consultants should treat BEN_CWB_RPT_DETAIL as volatile staging data and re-execute the post-process audit before relying on the view's contents.