Search Results ben_svc_area_v




Overview
Explore in AI Chat

Overview

BEN_SVC_AREA_V is a seeded, VALID database view owned by the APPS schema within the Oracle E-Business Suite Advanced Benefits (BEN) module. It exposes service area definitions — geographic or organizational groupings used to segment eligibility, plan offerings, and rate determination in benefits administration. The view is documented in the ETRM 12.2.2 repository and carries forward into 12.1.1 as a retrofitted object; the metadata description "Retrofitted" indicates it was introduced or re-sequenced during an upgrade cycle as part of date-effective table support, rather than being part of the original BEN data model.

Functionally, the view presents the current-row projection of the service area base table as filtered by the active application session. This makes it a session-aware read construct rather than a static table snapshot, and it is this behavior that distinguishes it from directly querying the underlying physical table.

Underlying Base Objects

The view is defined over two documented base objects:

  • BEN_SVC_AREA_F (SYNONYM) — the date-effective ("_F" / datetrack) table holding service area records, aliased in the view as SVA.
  • FND_SESSIONS (SYNONYM) — the standard Oracle Forms session table, aliased as SE.

The join condition is SE.SESSION_ID = USERENV('SESSIONID') and SE.EFFECTIVE_DATE BETWEEN SVA.EFFECTIVE_START_DATE AND SVA.EFFECTIVE_END_DATE. In effect, the view restricts the date-effective service area rows to those valid as of the session's effective date. The ROWID of the base row is exported as ROW_ID, preserving the physical row identifier for Forms-based DML.

Key Columns

Common Use Cases and Queries

Typical uses include eligibility rule debugging, service area validation, and integration extracts. Because the view depends on a populated FND_SESSIONS row for the current session, ad-hoc queries from SQL*Plus or third-party tools (which lack a Forms session) may return no rows; use the base table or supply a session context when this behavior is observed.

  • Listing effective service areas for the current user's business group:

SELECT svc_area_id, name, org_unit_prdct FROM apps.ben_svc_area_v WHERE business_group_id = :p_bg_id ORDER BY name;

  • Inspecting DFF attribute usage across service areas:

SELECT svc_area_id, sva_attribute_category, sva_attribute1, sva_attribute2 FROM apps.ben_svc_area_v;

  • Joining to the base table when session context is unavailable:

SELECT sva.svc_area_id, sva.name FROM apps.ben_svc_area_f sva WHERE TRUNC(SYSDATE) BETWEEN sva.effective_start_date AND sva.effective_end_date;

The view should be treated as read-only reference data; DML must target BEN_SVC_AREA_F through the supported BEN forms or APIs.