Results for “oke_chg_logs”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
OKE_CHG_LOGS is a transactional table in the OKE (Project Contracts) product module of Oracle E-Business Suite, valid in releases 12.1.1 and 12.2.2. It stores the status history of contract change requests, functioning as an audit trail that records each state transition a change request undergoes during its lifecycle. Each row captures a single status change event together with the workflow context in which that change occurred, allowing implementers and business users to reconstruct the progression of a change request from submission through approval or rejection.
From a dimensional modeling perspective, the table's foreign key structure suggests a satellite-leaning classification within a Data Vault model. It carries a surrogate primary key and multiple descriptive attributes tied to parent hubs and links via foreign keys, which is characteristic of satellite behavior rather than that of a hub or link. This classification is a heuristic suggestion only; the definitive model depends on the enterprise's chosen data architecture.
Key Information Stored
The table is owned by the OKE schema and contains eleven documented columns. The most significant columns are:
- CHG_LOG_ID — the surrogate primary key, defined by the OKE_CHG_LOGS_PK constraint, uniquely identifying each status history record.
- CHG_REQUEST_ID — foreign key to OKE_CHG_REQUESTS, linking each log entry to its parent contract change request.
- CHG_STATUS_CODE — foreign key to OKE_CHG_STATUSES_B, indicating the status value assigned at the time of the event.
- WF_ITEM_TYPE and WF_ITEM_KEY — identify the Oracle Workflow item instance associated with the change, enabling correlation with workflow activity.
- WF_PROCESS — the workflow process name that drove the status transition.
- CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, and LAST_UPDATE_LOGIN — standard audit columns recording who created or last modified the row and when.
The business key is effectively the combination of the change request and status code at a point in time, though the documented schema does not list a unique index beyond the surrogate primary key. The inverse relationship is established by OKE_CHG_REQUESTS.LAST_CHG_LOG_ID, which points back to the most recent log entry for a request.
Common Use Cases and Queries
Typical usage centers on audit reporting and workflow diagnostics. A common pattern joins the log to the change request header to list the full status history of a specific request:
- SELECT l.CHG_LOG_ID, l.CHG_STATUS_CODE, l.CREATION_DATE, l.WF_ITEM_KEY FROM OKE.OKE_CHG_LOGS l WHERE l.CHG_REQUEST_ID = :request_id ORDER BY l.CREATION_DATE;
- Join OKE_CHG_STATUSES_B to translate CHG_STATUS_CODE into a user-facing status name.
- Join WF_ITEMS on WF_ITEM_TYPE and WF_ITEM_KEY to inspect the workflow step that generated each transition.
- Aggregate CREATION_DATE to measure cycle time between statuses for change governance reporting.
Related Objects
The most significant related objects are:
- OKE_CHG_REQUESTS — parent table; joined on OKE_CHG_LOGS.CHG_REQUEST_ID = OKE_CHG_REQUESTS.CHG_REQUEST_ID, and referenced in reverse through LAST_CHG_LOG_ID.
- OKE_CHG_STATUSES_B — lookup table for CHG_STATUS_CODE.
- WF_ITEM_TYPES and WF_ITEMS — workflow metadata referenced by WF_ITEM_TYPE and WF_ITEM_KEY.
-
stores information about contract change statuses history
-
stores information about contract change statuses history
-
SYNONYM: APPS.OKE_CHG_LOGS 12.1.1
-
TABLE: OKE.OKE_CHG_LOGS 12.1.1
-
SYNONYM: APPS.OKE_CHG_LOGS 12.2.2
-
TABLE: OKE.OKE_CHG_LOGS 12.2.2
-
VIEW: OKE.OKE_CHG_LOGS# 12.2.2
-
View: OKE_CHG_LOGS_V 12.1.1
View for change request logs
APPS.OKE_CHG_LOGS_V·↳ OKE_CHG_LOGS·↳ OKE_CHG_STATUSES_TL·↳ WF_ITEM_TYPES_VL·Explore OKE module →
-
View: OKE_CHG_LOGS_V 12.2.2
View for change request logs
APPS.OKE_CHG_LOGS_V·↳ OKE_CHG_LOGS·↳ OKE_CHG_STATUSES_TL·↳ WF_ITEM_TYPES_VL·Explore OKE module →
-
VIEW: OKE.OKE_CHG_LOGS# 12.2.2
-
VIEW: APPS.OKE_CHG_LOGS_V 12.1.1
-
VIEW: APPS.OKE_CHG_LOGS_V 12.2.2
-
12.1.1 DBA Data 12.1.1
-
12.1.1 DBA Data 12.1.1
-
12.1.1 FND Design Data 12.1.1
-
12.2.2 FND Design Data 12.2.2
-
12.2.2 DBA Data 12.2.2
-
12.2.2 DBA Data 12.2.2
-
12.2.2 DBA Data 12.2.2
-
12.2.2 DBA Data 12.2.2
-
12.2.2 DBA Data 12.2.2
-
12.1.1 DBA Data 12.1.1
-
VIEW: APPS.OKE_CHG_LOGS_V 12.1.1
-
VIEW: APPS.OKE_CHG_LOGS_V 12.2.2
-
stores information about contract change requests
-
stores information about contract change requests