Search Results rcn_rsn

Overview

The APPS.OKS_COV_ENT_PVT package body is a private (PVT-classified) Oracle EBS Service Contracts API that supports entitlement coverage determination within the Service Contracts (OKS) module. Its central responsibility is to derive default reaction and resolution timeframes for a coverage entitlement, based on a combination of the coverage template, business process, severity, timezone, and customer context supplied by the caller. The package is invoked when the application must compute a response target — for example, the default "react by" and "resolve by" dates for a service request or entitlement line — without requiring an end user to enter these values manually.

The package body header identifies revision OKSRCENB.pls 120.3.12010000.2, dated 2010/05/03, which places it within the 12.0/12.1 lineage subsequently carried into the 12.1.1 and 12.2.2 releases. Annotations in the source indicate that the logic was modified to support the Access Hour enhancement (ER 9675504) and the 12.0 Entitlement Timezone project, reflecting iterative refinement of timezone-aware entitlement calculations.

Key Procedures and Functions

The documented package surface contains a single public procedure, GET_DEFAULT_REACT_RESOLVE_BY. Its purpose is to return the default reaction record and resolution record for a given entitlement input record. The procedure accepts a structured input record describing the coverage template identifier, business process identifier, severity identifier, request date, timezone identifier, and customer/site/location identifiers. It returns the API return status, message count, message data, and two output records — one for the reaction ("react by") result and one for the resolution ("resolve by") result.

Internally, the procedure normalizes the request date (defaulting to SYSDATE when null), establishes a rule category constant of 'RCN_RSN', and evaluates reaction and resolution durations with their associated units of measure. It computes reaction and resolution start and target date-times using the caller-supplied timezone, consistent with the Dates_In_Input_TZ attribute introduced by the entitlement timezone enhancement. Additional local constants control exception stack behavior and template handling.

Tables Accessed

The ETRM metadata for this object documents no direct table references through APPS synonyms, which is consistent with its PVT designation: OKS_COV_ENT_PVT is a private implementation package, and any data retrieval is expected to be delegated to supporting public or internal packages rather than embedded SQL against base tables. Reaction and resolution duration logic typically relies on entitlement template and rule definitions maintained elsewhere in the OKS schema. Because no tables are explicitly documented, integrators should treat the data contract as procedural rather than table-driven.

Usage Notes

As a private package, OKS_COV_ENT_PVT is not intended to be called directly by customer extensions or forms; it is referenced by one other package within the application's internal call stack, which is the expected pattern for PVT-classified APIs. The user search term "g_app_name_okc" suggests investigation of the application name global used during API initialization, a common concern when diagnosing FND_API initialization or message-stack behavior in OKS/OKC integrations.

Practical invocation scenarios include Oracle Service entitlement processing, service request creation where default response commitments are calculated, and any concurrent or form-based flow that needs timezone-aware default reaction and resolution dates. When troubleshooting, confirm that the caller supplies a valid coverage template, business process, severity, and timezone; null request dates are tolerated and default to the current system date. Because the package relies on FND_API-style return status and message handling, callers should inspect x_return_status, x_msg_count, and x_msg_data after every invocation before consuming the returned reaction and resolution records.