Search Results get_iface_create_recs

Overview

CSI_ML_CREATE_PVT is a private PL/SQL package in the APPS schema belonging to the Oracle Enterprise Asset Management (eAM) and Enterprise Install Base (CSI) product family. It functions as the internal implementation layer for the CSI_ML_CREATE_PUB public API, which supports the creation of install base records derived from interface staging tables. In Oracle EBS 12.1.1 and 12.2.2, the "CSI" prefix designates the Install Base (Customer Service Intelligence) module, and the "PVT" suffix identifies a private package that is intended for internal use by the public API wrapper rather than direct invocation by external code.

The package's primary business purpose is to move data from the interface tables populated by external feeds — such as an Asset Tracking, metering, metering loop, or third-party interface — into the actual Install Base instance and relationship tables. This is the "ML" (metering loop) creation path, used to build instance relationships and asset interface records during data conversion, bulk load, or integration scenarios.

Key Procedures and Functions

The ETRM documentation for release 12.2.2 records two documented procedures or functions within CSI_ML_CREATE_PVT:

• GET_IFACE_CREATE_RECS — Retrieves the interface rows targeted for creation of new metering loop (ML) instances. It identifies the staging records in the instance interface tables that are eligible for processing and returns them to the calling layer for validation and insertion into the Install Base.
• GET_IFACE_REL_RECS — Retrieves interface rows that represent relationships between instances, supplying the relationship data needed to build the corresponding entries in the relationship interface and ultimately the Install Base relationship tables.

These procedures are internal helpers; parameter details are not exposed in the metadata and should not be assumed. Their evident role is to organize and return staged interface records to the loading logic in the calling public package.

Tables Accessed

CSI_ML_CREATE_PVT references the following tables through APPS synonyms:

• CSI_I_ASSET_INTERFACE — Staging table for asset-level interface records.
• CSI_I_PARTY_INTERFACE — Staging table for party (customer/account) interface records.
• CSI_INSTANCE_INTERFACE — The primary interface table for instance records awaiting conversion into the Install Base.
• CSI_II_RELATION_INTERFACE — Interface table holding relationship records between instances.
• CSI_IEA_VALUE_INTERFACE — Interface table for install base extended attribute values.
• CSI_INSTALL_PARAMETERS — System-level installation parameters that govern Install Base behavior and validation.
• PLITBLM — An internal PL/SQL table (index-by table) type used for array processing of the fetched interface rows.

These tables support the extraction, validation, and staging of metering loop instance and relationship data before insertion into the base Install Base tables.

Usage Notes

CSI_ML_CREATE_PVT is not designed for direct invocation. It is called exclusively by CSI_ML_CREATE_PUB, which is itself the supported interface for programmatic creation of metering loop records. Because it is a private ("PVT") package, the supported entry point for custom development, concurrent programs, or Oracle Forms is the corresponding public package (CSI_ML_CREATE_PUB), which encapsulates the calls to the private procedures. Standard Oracle EBS modules — including install base conversion and interface import concurrent programs — invoke the public API, which in turn calls this private package. Any customization should target the public layer and must respect the standard FND_API error handling conventions referenced by the package. The package also references CSI_ML_UTIL_PVT, CSI_DATASTRUCTURES_PUB, and FND_API as dependent objects. Direct use of CSI_ML_CREATE_PVT carries the risk of bypassing validation and error-handling logic enforced by the public API and should be avoided.