Search Results log_errors

Overview

OKS_CT_EVENTS_WFA is a Workflow Activity (WFA) package body that belongs to the Oracle Service Contracts (OKS) module. Its primary purpose is to implement the PL/SQL logic invoked by Oracle Workflow when a Contract Event of type "EVENT" is processed. In Oracle EBS 12.1.1 and 12.2.2, service contracts rely on the Workflow engine to orchestrate the lifecycle of contract events, including the creation of service requests. This package provides the callback functions that the Workflow engine invokes at specific activity points, most notably the SELECTOR and related functions that determine the next activity in the workflow and populate item attributes.

The package is classified as "OTHER" in the ETRM metadata, indicating it is not a formal public API but rather an internal implementation component used exclusively by the Workflow infrastructure. The header comment identifies it as the "Contract EVENT Item Type" implementation, confirming its role as the Workflow item type handler for contract events. The header date (2006) indicates the logic has remained stable across the 12.1.1 and 12.2.2 releases.

Key Procedures and Functions

• SELECTOR — The central workflow selector function. It receives the item type, item key, activity ID, and function mode (such as 'RUN' or 'SET_CTX'). Based on the function mode, it sets workflow item attributes and returns a result value that tells the Workflow engine which subsequent activity to execute. In the documented excerpt, it returns 'CREATE_SR' to trigger service request creation.
• GET_VALUES — Retrieves attribute values from the workflow item or underlying data sources, populating item attributes used by downstream activities.
• CREATE_SR — Performs the actual creation of a service request when the selector directs the workflow to that activity, using the service request type mappings and contract data.
• VALIDATE_RECEIVER — Validates the receiver (user or role) designated to receive workflow notifications, ensuring the recipient is valid before the workflow continues.
• UPDATE_EVENT — Updates the contract event record, reflecting the outcome or progression of the workflow activity.

Tables Accessed

The package reads from and writes to several tables via APPS synonyms. Service request configuration tables — CS_INCIDENT_SEVERITIES, CS_INCIDENT_STATUSES, CS_INCIDENT_TYPES, CS_INCIDENT_URGENCIES, and CS_SR_TYPE_MAPPING — supply the classification and mapping data needed when creating a service request. FND_USER and HZ_PARTIES / HZ_RELATIONSHIPS resolve the requesting or receiving party and their user account. MTL_SYSTEM_ITEMS and OKC_K_ITEMS link the contract line to the inventory item and contract structure. OKC_K_PARTY_ROLES_B provides the contract party role definitions used to determine the correct receiver and responsible parties.

Usage Notes

OKS_CT_EVENTS_WFA is invoked by the Oracle Workflow engine, not directly by forms or concurrent programs. It is triggered automatically whenever the Workflow item type for contract events executes an activity such as creating a service request. Administrators debugging service contract workflows may find the log_errors search term relevant because the package's exception handlers (notably the WHEN OTHERS THEN NULL blocks) can silently suppress errors, causing workflow failures to lack diagnostic output. Customizations should avoid modifying this package; instead, workflow attributes and profile options such as OKS_SERVICE_REQUEST_CREATOR should be used for configuration. The package is referenced by no other PL/SQL packages, confirming its narrow, workflow-specific role.