Search Results g_product_status

Overview

OE_INSTALL is an installation and diagnostic utility package in the Oracle Order Management (OE) module of Oracle E-Business Suite. As its name indicates, the package supports the installation, validation, and interoperability configuration of the Order Management application rather than transactional order-processing logic. It is owned by the APPS schema and holds a VALID status in both Oracle EBS 12.1.1 and 12.2.2.

The package body depends on a small, focused set of Oracle components: the public FND_API and FND_INSTALLATION packages, the OE_MSG messaging package, the OE_INSTALL specification itself, and the SYS.STANDARD package. This dependency profile confirms that OE_INSTALL performs product registration and status-reporting duties on behalf of the Order Management application, using the standard EBS installation and messaging infrastructure to do so.

Key Procedures and Functions

The ETRM documentation for 12.2.2 enumerates three documented program units within the package, classified generically as OTHER rather than as a public API set:

• GET_ACTIVE_PRODUCT — Returns the active Order Management product identifier used during installation and interoperability processing. This supports logic that must determine whether the OE product is installed and active before dependent setup steps proceed.
• GET_STATUS — Reports the current installation or configuration status of the Order Management product. It is typically used by diagnostics and by installation verification routines to confirm the module is properly registered.
• CREATE_INTEROP_SYNONYM — Creates the synonyms required for Order Management interoperability. This routine underpins the ability of external or EDI-based order sources to reference OE objects through the expected public names.

No parameter lists are documented in the ETRM metadata; signatures should be confirmed against the deployed package specification in the target instance.

Tables Accessed

The documented metadata does not list any base tables referenced through APPS synonyms for OE_INSTALL. Its data retrieval is instead satisfied through the FND_INSTALLATION and AD_APPS_PRIVATE components, which expose the installation repository that stores product registration and status information. The package therefore reads installation metadata rather than Order Management transactional or setup tables.

Usage Notes

OE_INSTALL is not referenced by any database object, meaning it is not invoked as a dependency from other PL/SQL packages. Instead it is called directly during installation, patching, and diagnostic activities, and it may be exercised manually by a DBA or technical consultant during troubleshooting of Order Management registration or interoperability problems. The synonym-creation routine is relevant when interoperability has not been fully configured or after cloning.

Although the package is not referenced by database objects, the 12.2.2 ETRM metadata records that it is referenced by thirty other packages through the documented usage graph, so its behavior indirectly influences dependent Order Management components. It should be treated as an installation-time utility: changes or manual execution carry risk and should be performed only under guidance from Oracle support or a controlled change process.