Results for “okc_k_accesses”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
OKC_K_ACCESSES is a Contracts Core (OKC) table in Oracle E-Business Suite 12.1.1 and 12.2.2 that records the level of access granted to a resource or a resource group for a specific contract. In effect, it is the authorization ledger of the Contracts module: each row answers the question of which user (resource) or team (resource group) may see or act upon a given contract header, and to what degree. Because contract visibility in OKC is enforced through this table rather than through generic function security alone, OKC_K_ACCESSES participates directly in the Contracts security model, alongside the security group assigned to each row.
From a Data Vault modeling perspective — this classification is a heuristic mined from the foreign key structure and should be treated only as a modeling suggestion — OKC_K_ACCESSES resolves as a link table. It carries no descriptive natural-key attributes of its own beyond the access level; instead it connects a contract header, a resource, and a resource group to express a many-to-many authorization relationship between contracts and the people or teams entitled to work on them.
Key Information Stored
The table is documented with twelve columns in the ETRM 12.2.2 schema. The most significant of these are:
- ID — the surrogate primary key, enforced by OKC_K_ACCESSES_PK and by unique index OKC_K_ACCESSES_U1. It is system-generated and carries no business meaning.
- CHR_ID — foreign key to OKC_K_HEADERS_B, identifying the contract header to which the access grant applies. This is the anchor of the authorization record.
- RESOURCE_ID — foreign key to JTF_RS_RESOURCE_EXTNS, identifying the individual resource (typically a user or employee) granted access.
- GROUP_ID — foreign key to JTF_RS_GROUPS_B, identifying the resource group granted access. A grant is normally expressed through either a resource or a group, not both.
- ACCESS_LEVEL — the descriptive payload of the link, holding the degree of access conferred (for example, view versus update authority) for the contract, resource, or group combination.
- SECURITY_GROUP_ID — foreign key to FND_SECURITY_GROUPS, which scopes the row to a security group and therefore to a specific operating unit or business boundary.
- OBJECT_VERSION_NUMBER — the optimistic locking column used by the Oracle Application Framework to detect concurrent updates.
- CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — the standard EBS WHO columns capturing audit and last-touch information.
The unique index OKC_K_ACCESSES_U2 on (CHR_ID, RESOURCE_ID, GROUP_ID) is the principal business-key candidate: it guarantees that a given contract cannot hold duplicate grants for the same resource and group combination.
Common Use Cases and Queries
The dominant use case is contract security administration and reporting. Administrators and support analysts query OKC_K_ACCESSES to determine who can currently see a contract, to audit grants for compliance, and to diagnose "contract not visible" issues. A typical pattern joins the table to OKC_K_HEADERS_B for the contract number and to the JTF resource tables for the actual user or group name:
- Listing all resources and groups granted access to a contract, with their access levels, filtered by CHR_ID.
- Reverse lookup: identifying every contract a given RESOURCE_ID can access, useful when off-boarding a user or reviewing entitlements.
- Auditing rows by SECURITY_GROUP_ID to confirm that grants respect operating-unit boundaries.
- Reconciliation reports comparing grants in OKC_K_ACCESSES against assignments expected from contract ownership or organization defaults.
- Detecting stale or duplicate grants using the OKC_K_ACCESSES_U2 key columns.
Because ACCESS_LEVEL semantics are enforced by Contracts application logic, queries should generally be validated against the seeded access-level values rather than assumed.
Related Objects
The documented foreign keys identify the core dependency chain:
- OKC_K_HEADERS_B — joined on OKC_K_ACCESSES.CHR_ID; supplies contract identity and is the parent of every access grant.
- JTF_RS_RESOURCE_EXTNS — joined on OKC_K_ACCESSES.RESOURCE_ID; resolves the individual resource and links onward to FND_USER and PER_ALL_PEOPLE_F.
- JTF_RS_GROUPS_B — joined on OKC_K_ACCESSES.GROUP_ID; resolves the resource group and its membership.
- FND_SECURITY_GROUPS — joined on OKC_K_ACCESSES.SECURITY_GROUP_ID; defines the security group that scopes each row.
- OKC_K_ACCESSES_PK / OKC_K_ACCESSES_U1 / OKC_K_ACCESSES_U2 — the primary and unique indexes that enforce row identity and prevent duplicate grants.
Contracts APIs and concurrent programs that create or validate contract security rely on this table implicitly; direct DML should be avoided in favor of the supported Contracts security interfaces, since the access rows are typically maintained in step with contract header processing.
-
Level of access granted to a resource or resource group for a contract.
-
Level of access granted to a resource or resource group for a contract.
-
TABLE: OKC.OKC_K_ACCESSES 12.2.2
-
SYNONYM: APPS.OKC_K_ACCESSES 12.1.1
-
SYNONYM: APPS.OKC_K_ACCESSES 12.2.2
-
TABLE: OKC.OKC_K_ACCESSES 12.1.1
-
VIEW: OKC.OKC_K_ACCESSES# 12.2.2
-
View: OKC_K_ACCESSES_V 12.1.1
View for table OKC_ACCESS_SECURITYS
-
View: OKC_K_ACCESSES_V 12.2.2
View for table OKC_ACCESS_SECURITYS
-
VIEW: APPS.OKC_K_ACCESSES_V 12.2.2
-
VIEW: OKC.OKC_K_ACCESSES# 12.2.2
-
VIEW: APPS.OKC_K_ACCESSES_V 12.1.1
-
View: OKC_K_ACCESSES_HV 12.2.2
History view for OKC_K_ACCESSES.
APPS.OKC_K_ACCESSES_HV·↳ OKC_K_ACCESSES_H·Explore OKC module →
-
View: OKC_K_ACCESSES_HV 12.1.1
History view for OKC_K_ACCESSES.
APPS.OKC_K_ACCESSES_HV·↳ OKC_K_ACCESSES_H·Explore OKC module →
-
VIEW: APPS.OKC_K_ACCESSES_HV 12.2.2
-
Table: OKC_K_HEADERS_B 12.2.2
Stores header level attributes of a Contract. It groups all the lines and terms and conditions of a contract.
Not implemented in this database·Explore OKC module →
-
List of Related Contracts
APPS.OKL_RELATED_CONTRACT_ALL_UV·↳ FND_GLOBAL·↳ JTF_RS_GROUPS_DENORM·↳ JTF_RS_GROUP_MEMBERS·Explore OKL module →
-
View: OKC_LAUNCH_KGRID_V 12.1.1
View for Main Launchpad Grid
APPS.OKC_LAUNCH_KGRID_V·↳ FND_GLOBAL·↳ HR_ALL_ORGANIZATION_UNITS_TL·↳ JTF_RS_GROUPS_DENORM·Explore OKC module →
-
View: OKC_LAUNCH_KGRID_V 12.2.2
View for Main Launchpad Grid
APPS.OKC_LAUNCH_KGRID_V·↳ FND_GLOBAL·↳ HR_ALL_ORGANIZATION_UNITS_TL·↳ JTF_RS_GROUPS_DENORM·Explore OKC module →
-
Table: OKC_K_HEADERS_B 12.1.1
Stores header level attributes of a Contract. It groups all the lines and terms and conditions of a contract.
Not implemented in this database·Explore OKC module →
-
List of Related Contracts
APPS.OKL_RELATED_CONTRACT_ALL_UV·↳ FND_GLOBAL·↳ JTF_RS_GROUPS_DENORM·↳ JTF_RS_GROUP_MEMBERS·Explore OKL module →
-
VIEW: APPS.OKC_K_ACCESSES_HV 12.1.1
-
12.1.1 FND Design Data 12.1.1
-
VIEW: APPS.OKC_K_ACCESSES_V 12.1.1
-
VIEW: APPS.OKC_K_ACCESSES_V 12.2.2
-
12.2.2 DBA Data 12.2.2