Results for “okc_subclass_resps_v”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
OKC_SUBCLASS_RESPS_V is an APPS-owned database view within the Oracle E-Business Suite Contracts Core (OKC) product family, documented as VALID in Oracle ETRM releases 12.1.1 and 12.2.2. Its stated purpose is to present a curated projection of the OKC_RESP_ACCESSES table, exposing responsibility-based access control records that associate a responsibility with a subclass and a defined access level. In the OKC data model, subclasses classify contract or document types, and responsibility assignments govern which users — based on the responsibility through which they sign in — may view or manipulate records belonging to those subclasses.
The view plays a reporting and integration role rather than a transactional one. Because it renames the surrogate ROWID to ROW_ID and carries forward audit columns, it can be consumed by Oracle Reports, BI Publisher data models, Oracle Application Framework (OAF) pages, and external interfaces without requiring developers to query the base table directly. This encapsulation is valuable in EBS environments where direct table access is discouraged and where the view may be granted to custom schemas or integrated applications.
Underlying Base Objects
The view is defined over OKC_SUBCLASS_RESPS, which in a standard EBS installation is exposed to the APPS schema through a synonym pointing at the OKC product schema. The dependency is a simple, single-table SELECT — no joins, unions, or aggregations are involved — so the view inherits the base table's row cardinality and constraints exactly.
Despite the ETRM description referring to OKC_RESP_ACCESSES, the documented view text selects exclusively from OKC_SUBCLASS_RESPS, aliased as SRAB. In 12.1.1 and 12.2.2 the underlying structure is consistent; OKC_RESP_ACCESSES is the conceptual/logical entity for responsibility access rows, while OKC_SUBCLASS_RESPS is the physical object queried. Implementers should treat OKC_SUBCLASS_RESPS as the source of truth when tracing data lineage or designing indexes.
Key Columns
- ROW_ID — the base table ROWID, preserved for row-level identification and used by some EBS frameworks for optimistic locking.
- RESP_ID — foreign key to FND_RESPONSIBILITY, identifying the responsibility granted access.
- SCS_CODE — the subclass code. This is the column most frequently searched by users and links the access record to the subclass definition.
- ACCESS_LEVEL — the permission granted, typically distinguishing read-only from update or full access.
- START_DATE / END_DATE — the effective dating window during which the access assignment is active.
- CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard EBS audit columns identifying who created or last modified the record and when.
Common Use Cases and Queries
Typical usage includes auditing access assignments by subclass, troubleshooting why a user cannot see or modify contract records, and feeding security data into custom reports. The following examples reflect common patterns.
- List all responsibilities with access to a given subclass:
SELECT resp_id, scs_code, access_level, start_date, end_date FROM apps.okc_subclass_resps_v WHERE scs_code = :p_scs_code AND TRUNC(SYSDATE) BETWEEN NVL(start_date, SYSDATE) AND NVL(end_date, SYSDATE); - Identify currently active access rows for a specific responsibility:
SELECT scs_code, access_level FROM apps.okc_subclass_resps_v WHERE resp_id = :p_resp_id AND TRUNC(SYSDATE) <= NVL(end_date, TRUNC(SYSDATE)+1);
- Audit recently modified assignments:
SELECT resp_id, scs_code, access_level, last_updated_by, last_update_date FROM apps.okc_subclass_resps_v WHERE last_update_date >= TRUNC(SYSDATE) - 30;
Because the view exposes ROW_ID, it can also be used in forms-based or OAF-based extensions requiring row identifiers, though direct DML should be directed at OKC_SUBCLASS_RESPS rather than the view.
-
View: OKC_SUBCLASS_RESPS_V 12.1.1
View for table OKC_RESP_ACCESSES
APPS.OKC_SUBCLASS_RESPS_V·↳ OKC_SUBCLASS_RESPS·Explore OKC module →
-
View: OKC_SUBCLASS_RESPS_V 12.2.2
View for table OKC_RESP_ACCESSES
APPS.OKC_SUBCLASS_RESPS_V·↳ OKC_SUBCLASS_RESPS·Explore OKC module →
-
12.2.2 FND Design Data 12.2.2
-
12.1.1 DBA Data 12.1.1
-
12.1.1 FND Design Data 12.1.1
-
12.2.2 DBA Data 12.2.2
-
APPS.OKC_UTIL SQL Statements 12.1.1
-
APPS.OKC_UTIL SQL Statements 12.2.2
-
PACKAGE BODY: APPS.OKC_UTIL 12.2.2
-
PACKAGE BODY: APPS.OKC_UTIL 12.1.1
-
12.2.2 DBA Data 12.2.2
-
eTRM - OKC Tables and Views 12.1.1
Intersection entity between templates and rules.
-
eTRM - OKC Tables and Views 12.2.2
Intersection entity between rules and templates
-
12.1.1 DBA Data 12.1.1