Search Results oks_oc_int_kto_pvt




Overview
Explore in AI Chat

Overview

OKS_OC_INT_KTO_PVT is a private PL/SQL package in the Oracle EBS Service Contracts (OKS) module. Its name reflects its role: an integration (INT) package that supports the K-to-O ("K to Order") flow, where a contract (OKC "K" header, i.e., the Service Contract) is used to generate a sales order (OE/ASO "O"). The package provides the programmatic bridge that transforms contract header and line data into quote input records, which are then handed to Oracle Order Management's order-creation interface. In practice, this supports business scenarios where a service contract or subscription entitlement must trigger creation of an associated order — for example, service renewal or subscription-based order generation.

The package is classified as a private (PVT) API, meaning it is intended for internal use by other OKS/OC components rather than as a public integration point for customer extensions. Its source header (OKSRKTOS.pls) and the documented metadata confirm it is part of the seeded APPS schema, compiled under Oracle EBS 12.1.1 and 12.2.2.

Key Procedures and Functions

The metadata documents a single procedure:

  • CREATE_ORDER_FROM_K — Creates an order from a contract by populating quote input records derived from the contract as the initial stage. It accepts a contract identifier and associated context (customer, group, operating unit, contract header/line ranges, and default date), and returns the identifier of the created order. Internally it calls ASO_ORDER_INT.CREATE_ORDER to perform the actual order creation. Output parameters report API return status, message count, and message data, consistent with the standard Oracle EBS API error-handling convention. A documented bug fix (Bug 4915691) is reflected in the inclusion of contract line ID low/high range parameters, indicating support for processing contract lines in bounded batches.

No other procedures or functions are documented in the available metadata.

Tables Accessed

The package references the following tables (via APPS synonyms), reflecting its contract-to-order transformation role:

Usage Notes

Because OKS_OC_INT_KTO_PVT is a private API, it is not intended for direct invocation by external or custom code. It is referenced by one other package, indicating it sits within an internal OKS call chain. It is typically invoked indirectly — for example, from Service Contracts UI flows, concurrent/order-generation processes, or other internal packages that need to programmatically derive a sales order from a contract. Developers extending the K-to-Order process should call the supported parent API rather than this PVT package, and must respect the documented API conventions (API version, message list initialization, and return-status checking). The presence of contract header and line range parameters further suggests its use in batch or bounded processing contexts.