Results for “sun_duration”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
OKS_ACTION_TIMES_V is an Oracle E-Business Suite view owned by the APPS schema in the Service Contracts (OKS) module. It exposes the contents of the OKS_ACTION_TIMES base table in a stable, read-only form intended for reporting, inquiry, and integration consumption. The object is documented in the E-Business Suite Technical Reference Manual (ETRM) for release 12.2.2 as a VALID view, and as a thin, presentation-oriented layer over contract action time definitions.
The view records the duration allocated to a given service contract action type for each day of the week, expressed in a unit of measure. It is therefore central to service coverage scheduling, response-time modelling, and entitlement calculations where the time window in which a covered action may be performed depends on the day of the week. Because it carries the standard EBS audit and concurrency columns, the view can be joined to other transactional Service Contracts entities and included in extract programs without losing the lineage of the originating row.
Underlying Base Objects
The view is defined over the base object OKS_ACTION_TIMES, accessed through a synonym in the APPS schema. The SELECT list is a one-to-one projection of the underlying table columns, with no filters, joins, or derivations applied. Consequently, every row and attribute in OKS_ACTION_TIMES is visible through OKS_ACTION_TIMES_V without transformation, and the view inherits the table's indexes, constraints, and who-column semantics. Because it is a simple projection, the view is safe for query use; it is not intended as a DML target and is exposed for read access only.
Key Columns
- ID — Primary identifier for the action time row.
- COV_ACTION_TYPE_ID — The identifier of the covered action type to which the time definitions apply; this is the column the user's search term "cov_action_type_id" references and is the primary join key to action type definition data.
- CLE_ID — Identifier linking the record to the coverage or contract line element context in which the action time applies.
- DNZ_CHR_ID — Denormalized character identifier used by Service Contracts for cross-entity referencing.
- UOM_CODE — Unit of measure in which the daily durations are expressed (for example, minutes or hours).
- SUN_DURATION, MON_DURATION, TUE_DURATION, WED_DURATION, THU_DURATION, FRI_DURATION, SAT_DURATION — The duration permitted for the action on each day of the week.
- SECURITY_GROUP_ID and OBJECT_VERSION_NUMBER — Multi-tenancy and optimistic locking columns used by the EBS framework.
- PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, REQUEST_ID — Concurrent program audit columns identifying the process that last touched the row.
- CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard who-columns supporting audit and change tracking.
Common Use Cases and Queries
Typical scenarios include reporting the service window defined per covered action type, validating that weekly durations are consistent with agreed service levels, and feeding downstream scheduling or entitlement engines. A frequent pattern joins the view to action type definitions on COV_ACTION_TYPE_ID.
Find all durations for a specific covered action type:
SELECT id, cov_action_type_id, uom_code, sun_duration, mon_duration, tue_duration, wed_duration, thu_duration, fri_duration, sat_duration FROM apps.oks_action_times_v WHERE cov_action_type_id = :p_action_type_id;SELECT cov_action_type_id, uom_code, SUM(NVL(sun_duration,0)+NVL(mon_duration,0)+NVL(tue_duration,0)+NVL(wed_duration,0)+NVL(thu_duration,0)+NVL(fri_duration,0)+NVL(sat_duration,0)) weekly_total FROM apps.oks_action_times_v GROUP BY cov_action_type_id, uom_code;SELECT id, cov_action_type_id, cle_id, dnz_chr_id, last_update_date, last_updated_by FROM apps.oks_action_times_v WHERE last_update_date >= TRUNC(SYSDATE) - 7 ORDER BY last_update_date DESC;
Because the view mirrors OKS_ACTION_TIMES exactly, these queries can be rewritten against the base table where indexing or performance tuning requires it.
-
View: OKS_ACTION_TIMES_V 12.1.1
View for OKS Action Times
APPS.OKS_ACTION_TIMES_V·↳ OKS_ACTION_TIMES·Explore OKS module →
-
This table is suggested to store Reaction/Resolution times.
-
This table is suggested to store Reaction/Resolution times.
-
View: OKS_COV_ACTION_TIMES_V 12.1.1
This view lists the action times defined for business processes in a coverage. This will be used by the Coverage UI.
APPS.OKS_COV_ACTION_TIMES_V·↳ OKC_K_LINES_B·↳ OKS_ACTION_TIMES·↳ OKS_ACTION_TIME_TYPES·Explore OKS module →
-
View: OKS_ACTION_TIMES_V 12.2.2
View for OKS Action Times
APPS.OKS_ACTION_TIMES_V·↳ OKS_ACTION_TIMES·Explore OKS module →
-
View: OKS_COV_ACTION_TIMES_V 12.2.2
This view lists the action times defined for business processes in a coverage. This will be used by the Coverage UI.
APPS.OKS_COV_ACTION_TIMES_V·↳ OKC_K_LINES_B·↳ OKS_ACTION_TIMES·↳ OKS_ACTION_TIME_TYPES·Explore OKS module →
-
VIEW: OKS.OKS_ACTION_TIMES# 12.2.2
-
VIEW: OKS.OKS_ACTION_TIMES# 12.2.2
-
View: OKS_ENT_REACT_TIME_L_V 12.2.2
Lists all Reaction time detail informations.
APPS.OKS_ENT_REACT_TIME_L_V·↳ OKS_ACTION_TIMES·↳ OKS_ACTION_TIME_TYPES·Explore OKS module →
-
View: OKS_ENT_REACT_TIME_L_V 12.1.1
Lists all Reaction time detail informations.
APPS.OKS_ENT_REACT_TIME_L_V·↳ OKS_ACTION_TIMES·↳ OKS_ACTION_TIME_TYPES·Explore OKS module →
-
TABLE: OKS.OKS_ACTION_TIMES 12.2.2
-
TABLE: OKS.OKS_ACTION_TIMES 12.1.1
-
PACKAGE: APPS.OKS_ACM_PVT 12.1.1
-
PACKAGE: APPS.OKS_ACM_PVT 12.2.2