Search Results oki_rnwl_bookings

Overview

OKILODRBK is a concurrent program owned by the OKI - Contracts Intelligence product family, a module that Oracle has classified as Obsolete. Its user-facing name is Load Renewal Bookings, Contract Intelligence, and the underlying description is "Load the OKI_RNWL_BOOKINGS table." As the name implies, the program performs a data-load operation: it populates the OKI_RNWL_BOOKINGS staging or interface table that Contracts Intelligence used for renewal booking analysis. The program does not perform calculations or reporting on its own; it exists solely to move renewal booking data into a table consumed by downstream Contracts Intelligence processes.

The search term "oki_rnwl_bookings" corresponds directly to the target table referenced in the program description, confirming that users searching this string are typically trying to trace how data reaches that table. The documented metadata records the program as Enabled: No, meaning that even in environments where the OKI module was once licensed and installed, this concurrent program is disabled and cannot be submitted as delivered.

Execution Details

The documented execution attributes in ETRM 12.2.2 are as follows:

• Execution Method: PL/SQL Stored Procedure
• Argument Method: Standard
• Executable: OKILODRBK
• Execution File Name: OKI_LOAD_RBK_PUB.CRT_RNWL_BKNG
• Subroutine Name: Not specified in the documented metadata

The executable resolves to a PL/SQL package procedure, OKI_LOAD_RBK_PUB.CRT_RNWL_BKNG. This follows the standard Oracle E-Business Suite pattern in which a concurrent program definition points to a package procedure rather than a standalone script or report binary. Because the execution method is PL/SQL Stored Procedure, the program runs within the database session established by the concurrent manager, and any errors surface through the concurrent request log generated by the procedure itself.

How to Run

Under normal circumstances, a program of this type would be submitted through the Standard Request Submission (SRS) window, using the responsibility that contains the Contracts Intelligence menu. The user would select Load Renewal Bookings, Contract Intelligence from the list of values, optionally supply standard arguments, and submit the request. Standard argument methods in EBS typically present parameters defined in the concurrent program definition, such as organization or ledger identifiers and date ranges scoping the load.

However, the documented Enabled: No flag is the controlling fact for this object. In a standard 12.1.1 or 12.2.2 installation, the program will not appear in the SRS list of values and cannot be submitted. It is retained in the data dictionary only as a historical definition because the OKI - Contracts Intelligence module is obsolete. There are no recommended parameter values to document, since Oracle does not support enabling or executing the program.

Related Objects

The principal related object is the OKI_RNWL_BOOKINGS table, the target of the load. Surrounding the load are typically the following components, consistent with the Contracts Intelligence data model:

• OKI_LOAD_RBK_PUB — the PL/SQL package containing the CRT_RNWL_BKNG procedure invoked by the executable.
• OKI_RNWL_BOOKINGS — the interface or staging table populated by this program and read by renewal booking inquiries and reports.
• Any Contracts Intelligence renewal or booking reports that query the populated table.

Because the module is obsolete and the program is disabled, no supported interface table, API, or report integration should be built against OKILODRBK in a current implementation. It should be treated as reference metadata only.