Search Results reset_base_tables

Overview

OKI_DBI_RESET_PUB is a public PL/SQL package in the APPS schema that forms part of the Oracle E-Business Suite Order Capture / OKI (Order Information) subsystem, specifically the DBI (database interface) utility layer. Its business function is to reset the OKI DBI base tables — that is, to clear or reinitialize the staging and interface data that the OKI DBI processes use when transferring order and contract data between the operational tables and downstream DBI structures. Such a reset is typically required during implementation, testing, or data-correction exercises so that the DBI load can be rerun from a clean state. The package body carries the header tag OKIPIRSB.pls 115.3, dated 2002/11/25, indicating it is a long-standing, stable component of the codebase carried forward into Release 12.1.1 and 12.2.2.

Key Procedures and Functions

• RESET_BASE_TABLES — The sole documented procedure in this package. It is the public entry point for the reset operation and does not itself contain the resetting logic. Instead, it delegates immediately to the private worker procedure OKI_DBI_RESET_PVT.reset_base_tables, which performs the actual deletion or truncation of DBI base table content. The public wrapper exists to provide a controlled, exception-safe interface: it captures the standard errbuf and retcode out parameters that conform to the Oracle EBS concurrent-program calling convention, and it traps errors raised by the private routine. Exceptions already raised as OKC_API.G_EXCEPTION_UNEXPECTED_ERROR are re-raised unchanged; any other unexpected error is logged using FND_MESSAGE with the message name CRM-DEBUG ERROR and the routine token set to OKI_DBI_RESET_PUB.reset_base_tables, written out via BIS_COLLECTION_UTILITIES.PUT_LINE, before being re-raised as the standard OKC unexpected-error exception.

Tables Accessed

The ETRM documentation for this object does not list any tables referenced through APPS synonyms. This is consistent with the package's design as a thin public wrapper: all DML against the OKI DBI base tables is performed inside the private package OKI_DBI_RESET_PVT, not here. Consequently, no direct table access can be attributed to OKI_DBI_RESET_PUB from the documented metadata, and any analysis of which tables are reset must be directed to the private package body rather than to this public shell.

Usage Notes

Because RESET_BASE_TABLES exposes the standard errbuf/retcode signature, it is designed to be registered and invoked as an Oracle EBS concurrent program. In practice it may also be called from custom PL/SQL, a hosted form, or a shell script via SQL*Plus during implementation and test cycles. The ETRM metadata records that no other packages reference OKI_DBI_RESET_PUB, so it sits at the top of its own call tree. Given that the procedure removes data from DBI base tables, it should be run only by administrators, outside normal business hours, and only after confirming that in-flight DBI loads are complete. Typical invocations include post-clone cleanup, resolution of failed or partial DBI runs, and preparation for a full DBI reload.